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 SWAA2014100232558Skin · crackedLEFT BS 480 LOWER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014100232557Skin · crackedLEFT BS 500C UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014100232556Skin · crackedLEFT BS 500B UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014100232555Skin · crackedLEFT BS 500A UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014100232554Skin · crackedLEFT BS 500 UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014100232553Skin · crackedLEFT BS 480 UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014100232552Skin · crackedLEFT BS 440 UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014100232518Web · crackedWEB CRACKED AT BS 639 AT STRINGER 15L. R & R WEB IAW SRM & DWG.SDR SWAA2014101032517Seat Track · crackedSEAT TRACK CRACKED AT BS 727B LBL 44.5. REPAIRED SEAT TRACK IAW SRM.SDR SWAA2014092232152Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75 STRINGER 10R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014091832078Skin · crackedRIGHT WING INBD FIXED LE CRACKED AT PREVIOUS TRIM OUT INBD OF PYLON AT FSS 197.5. REPAIRED SKIN IAW SRM & EA.SDR SWAA2014091531969Slide · unsecureL1 DOOR INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW TASK CARD.SDR SWAA2014091531951Lug · brokenLEFT WING NR 4 GND SPOILER OTBD ATTACH LUG BROKEN. R & R SPOILER IAW MM.SDR SWAA2014091531983Cover · missingFORWARD ENTRY DOOR EMER EXIT LIGHT COVER MISSING. INSTALLED COVER SIP.SDR SWAA2014091531980Flap · delaminatedLEFT WING OTBD AFT FLAP INBD END DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2014091531979Skin · delaminatedRIGHT WING INBD AFT FLAP DELAMINATED AT INBD EDGE UPPER SURFACE TE. R & R AFT FLAP IAW AMM.SDR SWAA2014091531978Bracket · crackedRIGHT WING AILERON COVE BRACKET CRACKED AT LOWER RADIUS. R & R BRACKET IAW SRM.SDR SWAA2014110533771Structure · crackedLOWER FWD CRACKED AT BS 727 STRINGER 18L IN THE INNER CHORD. R & R CHORD IAW EA.SDR SWAA2014100732714Floorbeam · corrodedFLOORBEAM HORIZONTAL CHORD CORRODED AT BS 986 BETWEEN LBL 5 TO LBL 40. REPAIRED CHORD IAW ER & EA.SDR SWAA2014100732713Angle · crackedLEFT WING AILERON WHIPPER PANEL OTBD END ANGLE CRACKED AT LOWER FASTENER AT RSS 545. R & R ANGLE IAW SRM.SDR SWAA2014100732712Angle · crackedLEFT WING NR 1 PYLON UPPER AFT PANEL SUPPORT INBD L ANGLE CRACKED. R & R L ANGLE IAW SRM.SDR SWAA2014100732711Keelbeam · delaminatedKEEL BEAM DELAMINATED AT BS 597 RBL 4. R & R KEEL BEAM IAW SRM.SDR SWAA2014100732709Angle · crackedLEFT WING INBD & OTBD ANGLE CRACKED OF STABILIZING LINKS BETWEEN THE MLG BEAM & THE REAR SPAR. R & R ANGLE IAW SRM & DWG.SDR SWAA2014100732720Floorbeam · corrodedRIGHT FLOORBEAM T CAP CORRODED AT BS 986. R & R T CAP IAW SRM.SDR SWAA2014100632649Angle · crackedRIGHT WING NR 2 PYLON UPPER AFT PANEL SUPPORT BEAM INBD L ANGLE CRACKED. R & R L ANGLE IAW SRM.SDR SWAA2014100332615Toggle · looseRIGHT WING INBD FORE FLAP INBD TOGGLE OTBD FWD ROLLER LOOSE. R & R TOGGLE IAW AMM.SDR SWAA2014100332614Angle · crackedRIGHT WING TE AT RSS 515 AILERON WHIPPER PANEL OTBD UPPER ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014100332613Skin · crackedFORWARD GALLEY DOOR CUT OUT CRACKED AT BS 294 RBL 57. REPAIRED CUT OUT IAW EA.SDR SWAA2014091632030Stiffener · crackedPRESSURE BULKHEAD, FWD SIDE OF DOME, Z STIFFENER CRACKED AT BS 1016 LBL 1.5. REPAIRED Z STIFFENER IAW EA.SDR SWAA2014091531970Sign · brokenFORWARD ENTRY DOOR EMER EXIT SIGN ASSEMBLY BROKEN. R & R SIGN ASSEMBLY IAW MM.SDR SWAA2014091531981Cover · brokenFORWARD ENTRY EMER EXIT LIGHT COVER BROKEN. REPAIRED COVER IAW EA.SDR SWAA2014110533789Frame · crackedFRAME CHORD LOWER FWD HOLE CRACKED AT BS 727 STRINGER 18AR, 9 O'CLOCK POSITION. REPAIRED CHORD IAW EA.SDR SWAA2014110533770Frame · crackedFRAME CHORD LOWER FWD HOLE CRACKED AT BS 727 STRINGER 18AL, 3 O'CLOCK & 8 O'CLOCK POSITION. REPAIRED CHORD IAW EA.SDR SWAA2014101633005Tip Cap · crackedLEFT HORIZONTAL STABILIZER OTBD TIP CRACKED. R & R TIP IAW MM.SDR SWAA2014101632994Panel · crackedNOSE WW RT FWD SIDE PANEL CRACKED BELOW SIDE PANEL 3103R. REPAIRED PANEL IAW SRM.SDR SWAA2014101632993Panel · crackedNOSE WW LT SIDE PANEL CRACKED BETWEEN SIDE PANELS 3104L & 3106L. R & R PANEL IAW SRM.SDR SWAA2014100932812Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 675 LBL 24.82. REPAIRED CHORD IAW EA.SDR SWAA2014100932811Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707 LBL 24.5. REPAIRED WEB IAW EA.SDR SWAA2014100932810Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 715.5 LBL 0.07. REPAIRED WEB IAW EA.SDR SWAA2014100932809Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 710.5 LBL 0.07. REPAIRED WEB IAW EA NO.SDR SWAA2014100932808Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709.5 BETWEEN BBL 0.07. REPAIRED WEB IAW EA.SDR SWAA2014100632648Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 359 STRINGER 7L. REPAIRED SPLICE IAW SRM.SDR SWAA2014100632641Light · crackedLEFT EEPLS CRACKED AT ROW 11. R & R EEPLS IAW AMM.SDR SWAA2014100632633Light · crackedRIGHT EEPLS CRACKED BETWEEN ROW 3 TO ROW 14. R & R EEPLS IAW AMM.SDR SWAA2014100332611Stiffener · crackedVERTICAL STIFFENER CRACKED AT BS 328 RBL 30. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014100232532Bulkhead · corrodedAFT PRESS BULKHEAD LOWER WEB CORRODED AT BS 1016 RBL 1. REPAIRED WEB IAW EA.SDR SWAA2014091832120Circuit Breaker · trippedEMERGENCY EXIT LIGHT FAULTY. FOUND EMER EXIT LIGHT CB TRIPPED. RESET CB IAW MM.SDR SWAA2014091531932Cover · disconnectedAFT GALLEY EMER EXIT COVER DISCONNECTED. RECONNECTED COVER IAW MM.SDR SWAA2014091131847Keelbeam · crackedRIGHT UPPER KEEL BEAM WEB PANEL CRACKED AT BS 724. REPAIRED BEAM IAW SRM.SDR SWAA2014100932807Skin · crackedFUSELAGE SKIN CRACKED AT BS 420+13 STRINGER 1. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4