Boeing 737-3H4
Service difficulty reports · 52,340
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '7373H4' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = '7373H4' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR SWAA2014110733896Light · looseRIGHT EEPLS LOOSE AT ROW 8. SECURED EEPLS IAW MM.SDR SWAA2014110733895Door Frame · crackedL1 DOOR LOWER EDGE FRAME CRACKED AT FWD LOWER CORNER STOP FITTING. R & R DOOR IAW MM.SDR SWAA2014111234082Tie Clip · crackedSTRINGER TIE CLIP CRACKED AT BS 360 STRINGER 5L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014110733899Duct · overheatedCARGO FIRE PANEL DISPLAYS BOTTLE DISCHARGED 2 & MX LIGHTS ILLUMINATED. FOUND DUCT OVERHEATED. R & R SUPPRESSION CONTROL UNIT IAW AMM.SDR SWAA2014110733885Lens · looseFORWARD ENTRY EMER LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2014110633846Battery Pack · dischargedM1675 EMER CABIN BULLNOSE LIGHT IN FWD CABIN INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014110633861Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 847 STRINGER 1L. R & R SKIN IAW SRM.SDR SWAA2014110633860Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 807 STRINGER 2R. R & R SKIN IAW SRM.SDR SWAA2014110633859Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 807 STRINGER 2L. R & R SKIN IAW SRM.SDR SWAA2014110633858Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 727A STRINGER 2L. R & R SKIN IAW SRM.SDR SWAA2014110633857Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 827 STRINGER 2R. R & R SKIN IAW ER & EA.SDR SWAA2014110633856Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 847 STRINGER 1L. R & R SKIN IAW SRM.SDR SWAA2014110633855Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 801 STRINGER 2R. R & R SKIN IAW SRM.SDR SWAA2014110633854Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 787 STRINGER 2R. R & R SKIN IAW SRM.SDR SWAA2014110633853Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 727B STRINGER 2L. R & R SKIN IAW SRM.SDR SWAA2014110633852Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 807 STRINGER 1L. R & R SKIN IAW SRM.SDR SWAA2014110633851Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 801 STRINGER 1L. R & R SKIN IAW SRM.SDR SWAA2014110633850Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 727C STRINGER 26. R & R SKIN IAW EA.SDR SWAA2014110633870Lens · looseFORWARD EXIT SIGN COVER LENS LOOSE. SECURED LENS IAW SIP.SDR SWAA2014110633869Battery Pack · dischargedM1674 EMER CABIN BULLNOSE LIGHT IN FWD CABIN INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014111134045Seat Track · crackedLONGITUDINAL FLOORBEAM SEAT TRACK INBD FLANGE CRACKED AT BS 727B RBL 24.8. REPAIRED SEAT TRACK IAW SRM.SDR SWAA2014110633872Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500A STRINGER 11R. R & R CLIP IAW SRM & DWG.SDR SWAA2014110633862Slide · low pressureR2 DOOR EMER EVAC SLIDE PRESS LOW. R & R SLIDE IAW MT.SDR SWAA2014110433721Spoiler · looseLEFT WING INBD GND SPOILER HINGE POINT LOOSE. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2014110533818Battery · dischargedFORWARD INBD FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2014110433669Lens · missingLEFT OVERHEAD BIN EMER EXIT LIGHT LENS COVER MISSING AT ROW 18. INSTALLED LENS COVER IAW SIP.SDR SWAA2014112434411Glowstrip · delaminatedEEPLS PHOTO LUMINESCENT STRIPS DELAMINATED. R & R EEPLS IAW MM.SDR SWAA2014110533811Cover · crackedFORWARD ENTRY DOOR EMER LIGHT COVER CRACKED. R & R COVER IAW SIP.SDR SWAA2014110333622Lens · unsecureFORWARD EMER EXIT LIGHT LENS FELL OFF. REINSTALLED LENS IAW MM.SDR SWAA2014110333608Module · faultyDURING LANDING LT MAIN GEAR WOULD NOT EXTEND, UNSAFE INDICATION, CYCLED GEAR. R & R LT GEAR MODULAR PACKAGE IAW AMM.SDR SWAA2014120834752Skin · crackedSKIN CRACKED AT BS 370, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2014120834751Skin · crackedSKIN CRACKED BETWEEN BS 500B+4 TO 500B+5, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2014120434666Skin · crackedSKIN CRACKED BETWEEN BS 373 TO 374, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2014120434665Skin · crackedSKIN CRACKED BETWEEN BS 500B+4 TO 500B+6, STRINGER 19L. REPAIRED SKIN IAW EA.SDR SWAA2014112134387Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STRINGER 22L. R & R CLIP IAW DWG & SRM.SDR SWAA2014112134359Shear Tie · crackedSHEAR TIE CRACKED AT BS 361, STRINGER 14R. R & R SHEAR TIE IAW DWG.SDR SWAA2014112134358Shear Tie · crackedSHEAR TIE CRACKED AT BS 500, STRINGER 14R. R & R SHEAR TIE IAW DWG.SDR SWAA2014112134357Shear Tie · crackedSHEAR TIE CRACKED AT BS 460, STRINGER 14R. R & R SHEAR TIE IAW DWG.SDR SWAA2014112134356Shear Tie · crackedSHEAR TIE CRACKED AT BS 420, STRINGER 14R. R & R SHEAR TIE IAW DWG.SDR SWAA2014111834281Floor Support · crackedLEFT MAIN WW UPPER PRESS DECK LONGITUDINAL FLOORBEAM LOWER CHORD INBD FLANGE ANGLE CRACKED AT BS 663, LBL 45. REPAIRED CHORD IAW SRM.SDR SWAA2014111834280Floor Support · crackedLEFT MAIN WW UPPER PRESS DECK LONGITUDINAL FLOORBEAM LOWER CHORD ANGLE INBD FLANGE DOUBLER CRACKED AT BS 663, LBL 24. R & R ANGLE IAW SRM & DWG.SDR SWAA2014111734197Angle · crackedLEFT MAIN WW UPPER PRESS DECK ANGLE CRACKED AT BS 663, LBL 24. REPAIRED ANGLE IAW SRM.SDR SWAA2014110633871Buttstrap · crackedBUTT STRAP SPLICE CRACKED AT BS 362 STRINGER 14R. REPAIRED BUTT STRAP IAW SRM & DWG.SDR SWAA2014110533752Shear Web · crackedAFT FUSELAGE CABIN FLOOR SHEAR WEB CRACKED AT BS 1006 RBL 40. R & R WEB IAW DWG & SRM.SDR SWAA2014110333657Slide · looseL2 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2014110333650Light · inoperativeRIGHT BULLNOSE EMER LIGHT INOPERATIVE AT ROW 4. RELAMPED LIGHT IAW AMM.SDR SWAA2014110333644Scuff Plate · crackedFORWARD CARGO DOOR FRAME MIDDLE SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2014110333627Lens · looseLEFT EMER EXIT CUT OUT LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2014110333624Battery · dischargedSTOWAGE BIN MOUNTED EMER FLOODLIGHTS INOPERATIVE BETWEEN ROW 1 - 5. R & R BATTERY IAW AMM.SDR SWAA2014110333621Hinge · brokenRIGHT WING NR 5 GND SPOILER HINGE BROKEN. R & R SPOILER IAW AMM.
Back to Boeing 737-3H4