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 SWAA2014071429903Light · looseRIGHT EEPLS LOOSE AT ROW 8. SECURED EEPLS IAW MM.SDR SWAA2014082731310Crossbeam · crackedC2 DOOR CROSSBEAM WEB CRACKED AT LOWER FASTENER. R & R C2 DOOR IAW MM.SDR SWAA2014082631263Frame · crackedFRAME AUXILIARY & OTBD CHORD CRACKED AT BS 727 STRINGER 18A RT LOWER FWD HOLE. R & R CHORD IAW EA.SDR SWAA2014082631255Structure · crackedOUTBOARD CHORD CRACKED AT BS 727 STRINGER 18A LT FWD LOWER HOLE. R & R CHORD IAW EA.SDR SWAA2014082531184Pressure Deck · crackedMAIN CABIN PRESS DECK BEADED WEB PANEL OVER MAIN WW CRACKED AT BS 673 LBL 42.50. REPAIRED WEB IAW EA.SDR SWAA2014082131079Door Frame · crackedR1 EMER EXIT DOOR FRAME CRACKED AT LOWER FWD EDGE WEB. REPAIRED FRAME IAW SRM.SDR SWAA2014081930993Floor Support · corrodedL1 DOOR ENTRY AREA UNDER FLOOR SUPPORT CORRODED AT BS 328 LBL 28. REPAIRED SUPPORT IAW SRM.SDR SWAA2014080130544Keelbeam · corrodedKEEL BEAM SKIN ASSEMBLY CORRODED AT BS 616 BETWEEN LBL 6.30 TO RBL 6.30. R & R KEEL BEAM SKIN ASSEMBLY IAW EA.SDR SWAA2014072830401Attach Bracket · crackedRIGHT WING NR 6 SLAT INBD MAIN TRACK COVER PLATE ATTACHING BRACKET CRACKED. R & R BRACKET IAW DWG.SDR SWAA2014072830380Skin · delaminatedRIGHT WING OTBD AFT FLAP OTBD END LOWER SKIN DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014072830407Angle · crackedFORWARD GALLEY DOOR SPLICE ANGLE CRACKED ON AFT LOWER CORNER. R & R ANGLE IAW SRM & DWG.SDR SWAA2014072530315Skin · delaminatedLEFT WING INBD FORE FLAP UPPER SKIN DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014072530314Skin · delaminatedRIGHT WING OTBD AFT FLAP LOWER SKIN DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014072530352Skin · damagedSKIN CREASED BETWEEN BS 794 TO 807 BETWEEN STRINGER 25R TO 26R. REPAIRED SKIN IAW EA.SDR SWAA2014072130143Wire · brokenFORWARD LAVATORY EMER LIGHT ASSEMBLY WIRE BROKEN. R & R WIRE IAW SWPM.SDR SWAA2014071630052Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STAB BL 80, 2 INCHES FWD OF REAR SPAR. REPAIRED SKIN IAW SRM & EA.SDR SWAA2014071129894Cover · looseL1 DOOR EMER EXIT LIGHT COVER LOOSE. R & R COVER IAW MM.SDR SWAA2014071029841Hydraulic Line · failedB HYD QTY GAUGE SHOWED 1/2 FULL. ON APPROACH ENG 2 LOW PRESS LIGHT FLICKERED TWICE. R & R B SYS ELEC HYD PUMP PRESS LINE IAW MM.SDR SWAA2014080630634Splice Plate · crackedRIGHT WING FORE FLAP OTBD SLICE PLATE CRACKED. REPAIRED FORE FLAP IAW EO & EA.SDR SWAA2014072130145Shear Tie · crackedSHEAR TIE CRACKED AT BS 328 STRINGER 17R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014071630042Plate · crackedPLATE CRACKED BETWEEN BS 492 TO 500 BETWEEN STRINGER 24R TO 26R. REPAIRED PLATE IAW SRM.SDR SWAA2014071429962Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 559 STRINGER 1. R & R CLIP IAW SRM & DWG.SDR SWAA2014071429961Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 663 STRINGER 4L. R & R CLIP IAW SRM & DWG.SDR SWAA2014071029870Angle · crackedRIGHT WW FWD CUT OUT ANGLE CRACKED UPPER CORNER. R & R ANGLE IAW DWG & SRM.SDR SWAA2014073030472Strap · crackedSTRAP CRACKED BETWEEN BS 343 TO 348 STRINGER 16L. R & R STRAP IAW SRM & DWG.SDR SWAA2014072830393Skin · crackedRIGHT BS 787+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072530346Skin · crackedRIGHT BS 887+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330224Window Frame · crackedRIGHT BS 400+10 WINDOW FRAME CRACKED AT HOLES 5 & 6. R & R FRAME IAW DWG.SDR SWAA2014072130160Skin · crackedRIGHT BS 887+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB & TC.SDR SWAA2014072130159Skin · crackedRIGHT BS 807+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB & TC.SDR SWAA2014072130158Skin · crackedRIGHT BS 847+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB & TC.SDR SWAA2014072130157Skin · crackedRIGHT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB & TC.SDR SWAA2014072130156Skin · crackedRIGHT BS 807+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB & TC.SDR SWAA2014072130155Skin · crackedRIGHT BS 787+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB & TC.SDR SWAA2014072130154Skin · crackedRIGHT BS 767+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072130153Skin · crackedRIGHT BS 727E+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072130152Skin · crackedRIGHT BS 727+10 UPPER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014070929818Door Frame · crackedR1 DOOR CRACKED LOWER EDGE FRAME AT AFT LOWER CORNER STOP FITTING. R & R DOOR IAW AMM.SDR SWAA2014073030471Skin · crackedLEFT BS 440+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072830379Light · delaminatedAFT CABIN EEPLS DELAMINATED. R & R EEPLS IAW MM.SDR SWAA2014072530351Flap · delaminatedRIGHT WING AFT FLAP OTBD EDGE DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014072330267Skin · crackedRIGHT BS 500C+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330266Skin · crackedRIGHT BS 480+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330265Skin · crackedRIGHT BS 420+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330264Skin · crackedRIGHT BS 360+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330263Skin · crackedRIGHT BS 520+10 UPPER FWD WINDOW CORNER SKIN CUT OUT. REPAIRED SKIN IAW EA.SDR SWAA2014072330262Skin · crackedRIGHT BS 500B+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330261Skin · crackedRIGHT BS 440+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330260Skin · crackedRIGHT BS 420+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330259Skin · crackedRIGHT BS 400+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4