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 SWAA2016022549405Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 747 - 767, AT AFT LIGHTNING HOLE AREA. R & R WEB IAW SRM & DWG.SDR SWAA2016022549404Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 727C - 727D, AT CTR LIGHTNING HOLE AREA. R & R WEB IAW DWG.SDR SWAA2016022549403Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 500 - 500A, AT FWD LIGHTNING HOLE AREA. R & R WEB IAW DWG & SRM.SDR SWAA2016022549402Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 440 - 460. R & R WEB IAW DWG.SDR SWAA2016022549401Skin · crackedL1 DOOR FUSELAGE SKIN CUT OUT CRACKED AT SCUFF PLATE AT BS 344, STRINGER 17L, LOWER AFT CORNER SUPPORT FASTENER HOLE. REPAIRED SKIN IAW SRM.SDR SWAA2016022449351Fitting · crackedLEFT WING TE, NR 3 FLAP TRACK FAIRING CLIP ASSEMBLY, CRACKED ON RSS 270. R & R CLIP ASSEMBLY IAW SRM.SDR SWAA2016022449348Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 400 - 420. R & R WEB IAW DWG & SRM.SDR SWAA2016022449347Door Sill · corrodedRIGHT MOP SILL CORRODED, BETWEEN BS 291 - 360, BETWEEN RBL 60 - 63. R & R MOP SILL IAW SRM & DWG.SDR SWAA2016021949229Flashlight · brokenAFT GALLEY AREA FLASHLIGHT BASE BROKEN. R & R FLASHLIGHT IAW CMM.SDR SWAA2016021949228Flashlight · brokenFORWARD GALLEY AREA FLASHLIGHT BASE BROKEN. R & R FLASHLIGHT IAW CMM.SDR SWAA2016021949227Plate · crackedRIGHT WING PLATE CRACKED ON TE AT WBL 85.85. R & R PLATE IAW SRM & DWG.SDR SWAA2016021949226Angle · crackedLEFT WING ANGLE CRACKED AT RSS 537.806, APPROX IN TE. R & R ANGLE IAW SRM & DWG.SDR SWAA2016040450557Skin · crackedRIGHT WING INSPAR UPPER SKIN TE CRACKED AT WBL 171. REPAIRED SKIN IAW EA.SDR SWAA2016032250121Skin · crackedFUSELAGE SKIN CRACKED AT BS 327, STRINGER 17R. REPAIRED SKIN IAW SRM & EA.SDR SWAA2016032150100Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 278, STRINGER 14R. REPAIRED INTERCOSTAL IAW EA.SDR SWAA2016032150099Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 28L - 28R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016032150075Plate · crackedLEFT WING LOWER SPLICE PLATE, WAFFLE BOARD, CRACKED AT RSS 27.3. REPAIRED SPLICE PLATE IAW SRM & DWG.SDR SWAA2016031850001Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 500D, STRINGER 27R - 28R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016031850000Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 500C, LBL 16, WL 156. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016031849999Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 500A, LBL 12, WL 156. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016031149824Failsafe · corrodedFORWARD CARGO BAY FAIL SAFE CHORD CORRODED AT BS 500D, LBL 12. R & R CHORD IAW DWG & SRM.SDR SWAA2016030149823Shear Tie · corrodedSHEAR TIE CORRODED AT BS 480, RBL 14. R & R SHEAR TIE IAW EA.SDR SWAA2016030849733Bracket · deterioratedR2 DOOR EMER EVAC SLIDE FLOOR MOUNTED HARDWARE PLATE BRACKET DETERIORATED. R & R BRACKET IAW AMM.SDR SWAA2016030749701Skin · delaminatedTAIL CONE EXTERNAL SKIN DELAMINATED AT TAIL CONE. REPAIRED SKIN IAW SRM.SDR SWAA2016030749681Frame · crackedFRAME CRACKED AT BS 351.2, 4TH HOLE FROM BOTTOM, APPROX WL 212. REPAIRED FRAME IAW ER & EA.SDR SWAA2016030749680Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986, BETWEEN LT & RT SIDE UPPER SURFACE. REPAIRED FLOORBEAM IAW ER & EA.SDR SWAA2016030749679Keelbeam · corrodedKEEL BEAM CORRODED AT BS 794, RBL 8. REPAIRED KEEL BEAM IAW EA.SDR SWAA2016030749678Shear Tie · corrodedSHEAR TIE CORRODED AT BS 793, RBL 8. REPAIRED SHEAR TIE IAW ER & EA.SDR SWAA2016030349603Floorbeam · corrodedFLOORBEAM CORRODED AT BS 967, RBL 27. REPAIRED BEAM IAW EA & ER.SDR SWAA2016030249579Frame · corrodedAFT CARGO COMPARTMENT, LOWER FLANGE OF FRAME CORRODED, AT BS 747, BETWEEN STRINGER 27L - 26L. REPAIRED FRAME IAW SRM.SDR SWAA2016030249571Shear Tie · corrodedSHEAR TIE CORRODED, AT BS 947, LBL 15. R & R SHEAR TIE IAW DWG & SRM.SDR SWAA2016030249570Shear Tie · corrodedSHEAR TIE CORRODED AT BS 907, RBL 2. R & R SHEAR TIE IAW SRM.SDR SWAA2016030249569Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 277, STRINGER 10R. R & R CLIP IAW SRM & EA.SDR SWAA2016022949523Cargo Track · crackedAFT CARGO COMPARTMENT, TRACK CRACKED AT BS 787, LBL 17.24. REPAIRED TRACK IAW SRM.SDR SWAA2016022949520Door Sill · corrodedAFT SERVICE DOOR MOP SILL CORRODED. R & R MOP SILL IAW SRM.SDR SWAA2016022949519Door Sill · corrodedAFT ENTRY DOOR MOP SILL CORRODED, BETWEEN BS 947 - 1000, WL 208.1. R & R MOP SILL IAW DWG & SRM.SDR SWAA2016022949518Pressure Panel · crackedPRESSURE WEB CRACKED AT BS 1016, STRINGER 6L. R & R WEB IAW SRM.SDR SWAA2016022649449Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 328, STRINGER 20R. R & R CLIP IAW SRM.SDR SWAA2016022549400Door Sill · corrodedAFT SERVICE DOOR MOP SILL CORRODED. R & R MOP SILL IAW SRM.SDR SWAA2016021249018Light · inoperativeRIGHT EMER EXIT LIGHT INOPERATIVE AT ROW 24. RELAMPED LIGHT IAW AMM.SDR SWAA2016040550607Stiffener · crackedRIGHT MAIN WW CTR WING SECTION, STIFFENER CRACKED AT BS 663.75, RBL 6.15. REPAIRED STIFFENER IAW EA.SDR SWAA2016032150098Floor Support · crackedLONGITUDINAL BEAM CRACKED AT BS 662, RBL 24. REPAIRED BEAM IAW EA.SDR SWAA2016030749699Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727C, BETWEEN STRINGER 26R - 27R. REPAIRED SHEAR TIE IAW ER & EA.SDR SWAA2016030149547Skin · delaminatedEXTERNAL SKIN LOWER AREA AT TAIL CONE DELAMINATED, BETWEEN 5 & 6 O CLOCK. REPAIRED SKIN IAW SRM.SDR SWAA2016022949517Shear Tie · corrodedSHEAR TIE CORRODED AT BS 747, BETWEEN STRINGER 27L - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016021949234Skin · corrodedRIGHT WING UPPER SKIN AT REAR SPAR CORRODED, BETWEEN APPROX WBL 447 - 448. REPAIRED SKIN IAW EA.SDR SWAA2016021949232Skin · crackedRIGHT AFT WING SKIN FASTENER HOLE, AT WING STATION RSS 251 CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2016021849157Skin · crackedLEFT WING FIXED LE SKIN AT KRUEGER FLAP SEAL DOOR CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2016021649071Bulkhead · crackedMAIN WW AFT UPPER KEEL BEAM PANEL, JUST FWD OF AFT BULKHEAD CRACKED AT RT CORNER. REPAIRED BULKHEAD IAW SRM.SDR SWAA2016021148948Actuator · leakingRIGHT WING NR 5 SPOILER, OTBD ACTUATOR LEAKED. R & R NR 5 SPOILER ACTUATOR IAW MM.
Back to Boeing 737-3H4