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 SWAA2016032850306Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 221. REPAIRED WEB IAW EA.SDR SWAA2016032850286Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 221. REPAIRED WEB IAW EA.SDR SWAA2016032350171Skin · crackedLOWER FWD CORNER OF THE AFT CARGO DOOR CUTOUT SKIN CRACKED, STATION 840, STRINGER 24R. REPAIRED SKIN IAW SRM.SDR SWAA2016032250122Frame · crackedFRAME WEB CRACKED AT BS 277, STRINGER 16R. REPAIRED WEB IAW SRM.SDR SWAA2016032150094Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 665, RBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2016032150041Plate · crackedRIGHT WING TE PLATE CRACKED AT WBL 208.60 ON LOWER SURFACE. R & R PLATE IAW SRM.SDR SWAA2016031549937Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 277, STRINGER 11R. R & R CLIP IAW SRM.SDR SWAA2016031549936Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 767, STRINGER 25L - 25R. REPAIRED FRAME IAW SRM.SDR SWAA2016031549935Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STATION 727B, STRINGER 25L. R & R CLIP IAW SRM.SDR SWAA2016031549918Frame · crackedFUSELAGE FRAME CRACKED, AT STATION 440, STRINGER 24R. REPAIRED FRAME IAW SRM.SDR SWAA2016031149807Spar · crackedLEFT WING TE UPPER SPAR CHORD & SPAR WEB CRACKED, AT LOWER FASTENER HOLE RSS 219. REPAIRED WEB IAW EA.SDR SWAA2016031149806Spar · crackedLEFT WING TE UPPER SPAR CHORD CRACKED, AT UPPER FASTENER HOLE RSS 221.5. REPAIRED CHORD IAW EA.SDR SWAA2016031149830Spar · crackedRIGHT WING AT 3RD UPPER HOLE, INBD OF MLG AFT SUPPORT FITTING AT RSS 219. REAR SPAR WEB CRACKED. REPAIRED WEB IAW EA.SDR SWAA2016031149829Spar · crackedRIGHT WING AT MLG AFT SUPPORT FITTING, UPPER INBD NR 5 HOLE RSS 222, REAR SPAR UPPER CHORD CRACKED. REPAIRED CHORD IAW EA.SDR SWAA2016031149805Support Fitting · crackedLEFT WING TE UPPER SPAR CHORD, SPAR WEB & MLG, AFT SUPPORT FITTING CRACKED AT NR 5 FASTENER HOLE RSS 222.5. REPAIRED FITTING IAW EA.SDR SWAA2016030749698Skin · corrodedSKIN CORRODED AT BS 727D+11, BL 0. REPAIRED SKIN IAW EA.SDR SWAA2016022649453Floorbeam · crackedFLOORBEAM T CAP CRACKED AT BS 294, LBL 54. REPAIRED T CAP IAW SRM & DWG.SDR SWAA2016032150105Shear Tie · corrodedSHEAR TIE CORRODED AT BS 827, BETWEEN STRINGER 27L - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016032150104Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STRINGER 27L - 27R. REPAIRED FRAME IAW SRM.SDR SWAA2016032150103Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 24.8, AFT END INBD FWD FASTENER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2016032150102Support Angle · crackedRIGHT WING INBD SUPPORT ANGLE, CRACKED ON AFT END OF UPPER FLANGE. R & R ANGLE IAW SRM.SDR SWAA2016032150101Support Angle · crackedLEFT WING INBD NO STEP PANEL, SUPPORT ANGLE CRACKED AT AFT END OF UPPER FLANGE. R & R ANGLE IAW SRM.SDR SWAA2016032150093Shear Tie · corrodedSHEAR TIE CORRODED AT BS 967, BETWEEN STRINGER 26R - 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016032150092Frame · corrodedFRAME CORRODED AT BS 887, BETWEEN STRINGER 27L - 27R. REPAIRED FRAME IAW SRM.SDR SWAA2016031549934Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 1006, STRINGER 26L - 27L. REPAIRED FRAME IAW SRM.SDR SWAA2016031549933Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 947, STRINGER 27L - 27R. REPAIRED FRAME IAW RM.SDR SWAA2016031549932Intercostal · corrodedINTERCOSTAL CORRODED AT STATION 847 - 867, STRINGER 27R. REPAIRED INTERCOSTAL IAW SRM.SDR SWAA2016031549931Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 807, STRINGER 26R. REPAIRED FRAME IAW SRM.SDR SWAA2016031549930Stringer Clip · corrodedSTRINGER CLIP CORRODED AT STATION 747, STRINGER 27R. R & R CLIP IAW SRM.SDR SWAA2016031549929Stringer Clip · corrodedSTRINGER CLIP CORRODED AT STATION 747, STRINGER 27L. R & R CLIP IAW SRM.SDR SWAA2016031149828Stringer Clip · corrodedAFT CARGO BAY STRINGER CLIP CORRODED, AT BS 787, STRINGER 27L. R & R CLIP IAW DWG & SRM.SDR SWAA2016031149827Frame · corrodedFRAME SHEAR TIE CORRODED, AT BS 787, BETWEEN STRINGER 27R - 25R. R & R FRAME IAW SRM.SDR SWAA2016031149826Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STRINGER 25L - 25R. R & R FRAME IAW SRM & DWG.SDR SWAA2016031149825Support Bracket · crackedLEFT WING UPPER TE PANEL, SUPPORT BRACKET ON OTBD SIDE OF PYLON CRACKED. R & R BRACKET IAW SRM.SDR SWAA2016031049783Bracket · crackedLEFT WING NR 4 GND SPOILER INBD SUPPORT FITTING BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2016030749700Skin · crackedFUSELAGE SKIN CRACKED AT BS 291.50, WL 223.50. REPAIRED SKIN IAW EA.SDR SWAA2016030749683Crease Beam · corrodedLEFT SIDE CREASE BEAM WEB CORRODED, BETWEEN BS 500 - 500A, AT FWD END. R & R WEB IAW SRM.SDR SWAA2016030749682Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 420 - 440. R & R WEB IAW SRM.SDR SWAA2016030249581Support Angle · crackedRIGHT WING NR 6 FLAP TRACK FAIRING, INBD SIDE SUPPORT ANGLE CRACKED AT WBL 183.40, TE. R & R ANGLE IAW SRM & DWG.SDR SWAA2016030249580Frame · corrodedAFT CARGO COMPARTMENT, LOWER FLANGE ON FRAME CORRODED, AT BS 747, BETWEEN STRINGER 27L - 27R. REPAIRED FRAME IAW SRM.SDR SWAA2016030249573Support Angle · corrodedTHRESHOLD SUPPORT ANGLE CORRODED, AT BS 320, RBL 63. R & R ANGLE IAW SRM & DWG.SDR SWAA2016030249572Support Angle · corrodedTHRESHOLD SUPPORT ANGLE CORRODED, BETWEEN BS 304 - 322, RBL 60. R & R ANGLE IAW SRM.SDR SWAA2016030149549Channel · corrodedAFT CARGO COMPARTMENT, CHANNEL CORRODED AT BS 859, RBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2016030149548Channel · corrodedAFT CARGO COMPARTMENT CHANNEL CORRODED, AT BS 859, RBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA2016022949531Skin · crackedL1 DOOR LOWER AFT CORNER SKIN CUT OUT CRACKED AT BS 351. REPAIRED CUT OUT IAW EA.SDR SWAA2016022949522Plate · corrodedL1 DOOR GIRT BAR FITTING ATTACHMENT PLATES CORRODED. R & R PLATE IAW SRM.SDR SWAA2016022949521Door Sill · corrodedFORWARD ENTRY DOOR MOP SILL UPPER SURFACE CORRODED. R & R MOP SILL IAW DWG & SRM.SDR SWAA2016022549409Angle · crackedLEFT WING TE ANGLE CRACKED ON WBL 84. R & R ANGLE IAW SRM & DWG.SDR SWAA2016022549407Crease Beam · corrodedLEFT SIDE CREASE BEAM WEB CORRODED, BETWEEN BS 500A - 500B, AT CTR LIGHTNING HOLE AREA. R & R WEB IAW SRM.SDR SWAA2016022549406Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 767 - 787, AT AFT LIGHTNING HOLE AREA. R & R WEB IAW SRM & DWG.
Back to Boeing 737-3H4