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 SWAA2015102045131Spar · crackedLEFT WING CRACKED ON THE INBD SIDE OF RSS 224.14, UPPER SIDE OF SPAR WEB. REPAIRED SPAR WEB IAW EA.SDR SWAA2015101344875Spar · crackedLEFT WING UPPER SIDE OF SPAR WEB AT FASTENER HOLE NR 7 CRACKED AT RSS 224.14. REPAIRED WEB IAW EA.SDR SWAA2015092844342Shear Tie · crackedSHEAR TIE CRACKED, BETWEEN BS 927 - 947, STRINGER 26R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015091443839Skin · crackedLEFT WING SKIN CRACKED AT UPPER SKIN. REPAIRED SKIN IAW EA.SDR SWAA2015083143352Lens · looseRIGHT EEPLS LENS LOOSE AT ROW 12. REPAIRED LENS IAW EA.SDR SWAA2015082743256Lens · looseFORWARD EMER EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2015082743253Cover · looseL1 DOOR EMER EXIT LIGHT COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2015101644990Skin · crackedLEFT WING, UPPER SKIN FASTENER HOLE CRACKED, APPROX RSS 267, .750" FWD OF TE. REPAIRED SKIN IAW ER & EA.SDR SWAA2015101644989Skin · crackedLEFT WING, UPPER SKIN FASTENER HOLE CRACKED, APPROX RSS 254, .750" FWD OF TE. REPAIRED SKIN IAW ER & EA.SDR SWAA2015101644988Skin · crackedLEFT WING, UPPER SKIN FASTENER HOLE CRACKED, APPROX RSS 250, .750" FWD OF TE. REPAIRED SKIN IAW ER & EA.SDR SWAA2015101644987Skin · crackedLEFT WING, UPPER SKIN FASTENER HOLE CRACKED, APPROX RSS 229, .750" FWD OF TE. REPAIRED SKIN IAW ER & EA.SDR SWAA2015101644986Skin · crackedLEFT WING, UPPER SKIN FASTENER HOLE CRACKED, APPROX RSS 216, .750" FWD OF TE. REPAIRED SKIN IAW ER & EA.SDR SWAA2015101644985Skin · crackedLEFT WING, UPPER SKIN FASTENER HOLE CRACKED, APPROX RSS 214, 2.5" FWD OF TE. REPAIRED SKIN IAW ER & EA.SDR SWAA2015101644984Skin · crackedLEFT WING UPPER SKIN FASTENER HOLE CRACKED AT APPROX RSS 206, 3.5" FWD OF TE EA1-357-T1243. REPAIRED SKIN IAW ER & EA.SDR SWAA2015082743249Lens · missingLEFT BULLNOSE EMER LIGHT LENS MISSING AT ROW 14. INSTALLED LENS IAW SIP.SDR SWAA2015082643232Light · inoperativeAFT GALLEY EMER EXIT LIGHT INOPERATIVE, OTBD OF THE G4 GALLEY. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015101344874Support Fitting · crackedRIGHT WING REAR SPAR MLG AFT SUPPORT FITTING, CRACKED AT UPPER INBD FASTENER HOLE. REPAIRED FITTING IAW ER.SDR SWAA2015091443828Skin · crackedFUSELAGE SKIN CRACKED AT BS 811, STRINGER 1. REPAIRED SKIN IAW EA.SDR SWAA2015091443827Skin · crackedFUSELAGE SKIN CRACKED AT BS 823, STRINGER 1. REPAIRED SKIN IAW EA.SDR SWAA2015091443826Skin · crackedFUSELAGE SKIN CRACKED AT BS 832, STRINGER 1. REPAIRED SKIN IAW EA.SDR SWAA2015091443825Skin · crackedFUSELAGE SKIN CRACKED AT BS 842, STRINGER 1. REPAIRED SKIN IAW EA.SDR SWAA2015091443824Skin · crackedFUSELAGE SKIN CRACKED AT BS 891, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015091043583Skin · crackedFUSELAGE SKIN CRACKED AT BS 752, STRINGER 1. REPAIRED SKIN IAW SRM.SDR SWAA2015090243428Skin · crackedFUSELAGE SKIN CRACKED AT BS 762, STRINGER 1L. REPAIRED SKIN IAW SRM.SDR SWAA2015090243427Skin · crackedFUSELAGE SKIN CRACKED AT BS 727D+4, STRINGER 1. REPAIRED SKIN IAW SRM.SDR SWAA2015083143342Skin · crackedFUSELAGE SKIN CRACKED AT BS 494.5, STRINGER 1. REPAIRED SKIN IAW SRM.SDR SWAA2015083143341Skin · crackedFUSELAGE SKIN CRACKED AT BS 504, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015082543174Lens · brokenFORWARD ENTRY EMER EXIT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2015102145181Skin · crackedRIGHT WING UPPER SKIN CRACKED AFT EDGE FASTENER HOLE AT RSS 237. REPAIRED SKIN IAW ER & EA.SDR SWAA2015101644983Frame · corrodedFRAME FORGING CORRODED AT BS 665, RBL 70.8. REPAIRED FRAME IAW EA.SDR SWAA2015082643225Window · arcedL1 CAPTAINS FWD WINDSHIELD ARCED IN CTR OF L1, ABOUT 3/4 WAY DIAGONAL. R & R L1 WINDOW IAW AMM.SDR SWAA2015082543175Cover · unsafetiedFORWARD ENTRY DOOR EMER EXIT LIGHT COVER FELL OFF. INSTALLED COVER IAW MM.SDR SWAA2015082443090Skin · crackedFUSELAGE SKIN CRACKED AT BS 802, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2015082543181Light · inoperativeLEFT OVERWING EMER EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015082543180Light · inoperativeL1 DOOR EMER EXIT LIGHT INOPERATIVE AT FWD LOWER CORNER. RELAMPED LIGHT IAW AMM.SDR SWAA2015082443110Cover · brokenRIGHT EMER EXIT ROW LIGHT COVER BROKEN. R & R COVER IAW AMM.SDR SWAA2015091643970Fitting · crackedLEFT WING AFT SPAR, CRACKED IN FWD LG FITTING, COMMON TO UPPER SPAR CHORD. REPAIRED FITTING IAW EA.SDR SWAA2015091643969Fitting · crackedLEFT WING REAR SPAR, FWD LG BEAM FITTING CRACKED. REPAIRED FITTING IAW EA.SDR SWAA2015082443111Cover · looseR1 DOOR EXIT LIGHT COVER LOOSE. R & R BASE ASSEMBLY IAW AMM.SDR SWAA2015082443072Circuit Card · faultyON APPROACH WHEN LANDING GEAR SELECTED DOWN, LT MLG INDICATED RED & NO GREEN CYCLED GEAR ALL GREEN INDICATIONS. R & R LANDING GEAR LOGIC CARD IAW MM.SDR SWAA2015082443089Cover · brokenFORWARD ENTRY DOOR EXIT SIGN COVER BROKEN. REPAIRED COVER IAW SIP.SDR SWAA2015101644982Skin · crackedLEFT WING PLANK SKIN CRACKED ON UPPER SURFACE AT RSS 237. REPAIRED SKIN IAW EA.SDR SWAA2015100544590Skin · crackedRIGHT WING UPPER SKIN TE CRACKED AT AFT FASTENER ROW. REPAIRED SKIN IAW EA.SDR SWAA2015100144458Skin · crackedLEFT WING TE UPPER SKIN AT REAR SPAR FOUND CRACKED IN FASTENER HOLE, AFT FASTENER ROW WS 231. REPAIRED SKIN IAW EA.SDR SWAA2015092844328Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500B, BETWEEN STRINGER 27L - 28L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015092844327Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500B, BETWEEN STRINGER 26L - 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015092144109Floorbeam · crackedFLOORBEAM UPPER CHORD OTBD FLANGE, CRACKED AT BS 727B, RBL 24.82. REPAIRED FLANGE IAW EA.SDR SWAA2015092144106Skin · delaminatedRIGHT WING INBD FORE FLAP, UPPER SKIN DELAMINATED 13" FROM INBD END. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015091844039Fitting · looseLEFT MLG BEAM FITTING BEARING LOOSE. R & R FITTING ASSEMBLY IAW SRM.SDR SWAA2015091643954Fitting · crackedRIGHT AFT MLG BEAM FITTING CRACKED. R & R FITTING IAW SRM & EA.
Back to Boeing 737-3H4