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 SWAA2014072130128Fitting · crackedL1 DOOR FWD FRAME CLIP CRACKED AT BS 348 STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014071530002Web · corrodedWEB CORRODED BETWEEN BS 420 TO 440 STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2014071129891Plate · crackedRIGHT HORIZONTAL STABILIZER ACCESS PANEL 9226R PLATE CRACKED. R & R PLATE IAW DWG.SDR SWAA2014070729647Strap · crackedAFT E & E COMPARTMENT CEILING SUPPORT STRAP CRACKED INBD OF OTBD AT BS 312. R & R STRAP IAW SRM.SDR SWAA2014070729646Panel · crackedLEFT WING UPPER PANEL CRACKED AFT OF PANEL 57710L. REPAIRED PANEL IAW EA.SDR SWAA2014070729645Strap · crackedAFT E & E COMPARTMENT OTBD CEILING SUPPORT STRAP CRACKED AT BS 312. REPAIRED STRAP IAW SRM.SDR SWAA2014070329619Cover · missingFORWARD PAX CABIN EXIT SIGN ABOVE THE CTR AISLE MISSING COVER. R & R COVER IAW MM.SDR SWAA2014070229600Light · inoperativeL1 DOOR EXTERNAL EMER EXIT LIGHT INOPERATIVE. RELAMPED IAW MM.SDR SWAA2014070229578Lens · looseL1 DOOR EMER EXIT LIGHT LENS LOOSE. REINSTALLED LIGHT LENS IAW MM.SDR SWAA2014080630630Door Frame · crackedFORWARD ENTRY DOOR FRAME OUTER CHORD CRACKED AT BS 348.2. REPAIRED CHORD IAW EA.SDR SWAA2014080430575Structure · crackedAFT CARGO DOOR FWD END T CHORD CRACKED. REPAIRED T CHORD IAW EO.SDR SWAA2014080130514Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 STRINGER 16L. REPAIRED CHORD IAW EA.SDR SWAA2014080130513Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014072330241Angle · crackedANGLE CRACKED AT BS 348.2 STRINGER 16L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014072330240Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 887 TO 907. R & R ANGLE IAW SRM & DWG.SDR SWAA2014072330239Frame · corrodedFRAME CORRODED AT BS 767 BETWEEN STRINGER 26R TO 27R. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2014072130114Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 947.5 STRINGER 25R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014071530001Cargo Track · crackedCARGO TRACK CRACKED AT BS 747 RBL 13.80. REPAIRED TRACK IAW SRM.SDR SWAA2014071429910Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 947.5, STRINGER 25R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014071129890Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 947.5, STRINGER 25L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014071029853Web · crackedRIGHT INBD EXHAUST ATTACH WEB CRACKED AT BS 662. R & R WEB IAW SRM & DWG.SDR SWAA2014070829730Web · crackedL1 DOOR UPPER CUT OUT WEB CRACKED AT BS 338. R & R WEB IAW SRM & DWG.SDR SWAA2014070329626Skin · crackedRIGHT WING SKIN CRACKED AT NR 6 SLAT AUXILIARY TRACK CUT OUT. REPAIRED SKIN IAW SRM.SDR SWAA2014070329606Angle · crackedZ ANGLE CRACKED BELOW L1 DOOR THRESHOLD PLATE. R & R ANGLE IAW SRM.SDR SWAA2014080730673Skin Panel · crackedKEEL BEAM LOWER SKIN PANEL CRACKED BETWEEN BS 661 TO STATION 727 BETWEEN LBL 6.30 TO RBL 6.30. R & R SKIN IAW EO & EA.SDR SWAA2014073130492Floorbeam · crackedFLOORBEAM CRACKED AT BS 663.75+8, LBL 24.5. REPAIRED BEAM IAW EA.SDR SWAA2014073030463Frame · crackedFRAME WEB CRACKED AT BS 492 STRINGER 24R. R & R WEB IAW SRM & EA.SDR SWAA2014072830398Beam · crackedSTUB BEAM CRACKED AT BS 616 RT. R & R STUB BEAM IAW EA.SDR SWAA2014072830375Stiffener · crackedLEFT HORIZONTAL STABILIZER LOWER STIFFENER CRACKED AT STAB STATION 120.30. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014070729644Support Angle · crackedRIGHT WING SUPPORT ANGLE CRACKED AT LEVEL OF RSS 530. R & R ANGLE IAW SRM & DWG.SDR SWAA2014070329616Skin · crackedFUSELAGE SKIN CRACKED AT STATION 258.3, STRINGER 23L. REPAIRED SKIN IAW SRM.SDR SWAA2014070329614Skin · crackedFUSELAGE SKIN CRACKED AT STATION 258.3, STRINGER 23R. REPAIRED SKIN IAW SRM.SDR SWAA2014070229586Skin · crackedFUSELAGE SKIN CRACKED AT STATION 258.5, ABOVE STRINGER 23L. REPAIRED SKIN IAW SRM.SDR SWAA2014070229583Skin · crackedFUSELAGE SKIN CRACKED AT STATION 258.5, ABOVE STRINGER 23R. REPAIRED SKIN IAW SRM.SDR SWAA2014080430574Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 664 LBL 17. REPAIRED WEB IAW EO & EA.SDR SWAA2014072930445Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 673.5 RBL 38. REPAIRED WEB IAW EO & EA.SDR SWAA2014072930444Pressure Panel · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 666 RBL 38. REPAIRED WEB IAW EO & EA.SDR SWAA2014073130491Structure · crackedCHORD CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2014073130490Structure · crackedCHORD CRACKED AT BS 727 STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2014073130489Structure · crackedUPPER CHORD OVAL HOLE CRACKED AT BS 663.75+4, LBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2014073130488Structure · crackedUPPER CHORD CRACKED AT BS 663.75+2, LBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2014072830397Angle · crackedFORWARD ENTRY DOOR L ANGLE CRACKED AT BS 348 STRINGER 15L AT DOOR STOP FITTING, CRACK INDICATIONS AT LOWER OTBD HOLE. R & R L ANGLE IAW DWG & EA.SDR SWAA2014072830374Skin · crackedFUSELAGE SKIN CRACKED AT BS 328 STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2014072330251Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B RBL 45.5. REPAIRED BEAM IAW ER & EA.SDR SWAA2014072330250Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B LBL 45.5. REPAIRED BEAM IAW ER & EA.SDR SWAA2014072330249Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B RBL 24.8. REPAIRED CHORD IAW ER & EA.SDR SWAA2014072130150Seat Track · crackedSEAT TRACK HORIZONTAL FLANGE CRACKED AT BS 727B RBL 45.5. REPAIRED SEAT TRACK IAW SRM & EA.SDR SWAA2014072130127Fitting · crackedCLIP CRACKED AT BS 348.20 STRINGER 16L. R & R CLIP IAW DWG.SDR SWAA2014072130147Stop Fitting · crackedL1 DOOR STOP FITTING CRACKED AT BS 348 STRINGER 16L. REPAIRED FITTING IAW SRM.SDR SWAA2014071429909Support Angle · crackedLEFT MAIN WW SUPPORT ANGLE CRACKED AT BS 680. R & R ANGLE IAW SRM & DWG.
Back to Boeing 737-3H4