Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2014011324061Floorbeam · corrodedFLOOR BEAM UPPER FLANGE CORRODED AT BS 312 LBL 8. REPAIRED BEAM IAW SRM.SDR SWAA2014011324060Bracket · crackedRT WING NR 8 FLAP TRACK BRACKET CRACKED. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2014011324059Support Angle · crackedRT WING NR 6 FLAP TRACK FAIRING INBD LOWER SIDE SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011324058Reveal · crackedFWD SERVICE DOOR FWD UPPER CORNER REVEAL CRACK BETWEEN BS 294.5 TO BS 312, BETWEEN STRINGER 7R TO STRINGER 8R. R & R REVEAL IAW SRM & DRAWING.SDR SWAA2014010923929Angle · crackedLT WING INBD FIXED TE STRUCTURE ANGLE CRACKED ON WBL 183.4. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021225081Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+16, STRINGER 18L. REPAIRED SKIN IAW EA.SDR SWAA2014021024990Skin · crackedSKIN CRACKED AT BS 787+11.5, STRINGER 18L. REPAIRED SKIN IAW EA.SDR SWAA2014021024989Skin · crackedSKIN CRACKED AT BS 747+16, STRINGER 25L. R & R SKIN IAW EA.SDR SWAA2014021024988Skin · crackedSKIN CRACKED AT BS 767+6.25, STRINGER 25L. R & R SKIN IAW EA.SDR SWAA2014021024987Skin · crackedSKIN CRACKED AT BS 807+7, STRINGER 24L. R & R SKIN IAW EA.SDR SWAA2014021024986Skin · crackedSKIN CRACKED AT BS 807+13, STRINGER 23L. R & R SKIN IAW EA.SDR SWAA2014021024985Floor Support · crackedLONGITUDINAL FLOOR BEAM LOWER CHORD CRACKED AT BS 663, RBL 24.08. REPAIRED CHORD IAW EA.SDR SWAA2014021024979Skin · crackedSKIN CRACKED AT BS 767+8, STRINGER 25L. R & R SKIN IAW EA.SDR SWAA2014021024939Skin · crackedSKIN CRACKED AT BS 908+12.75, STRINGER 23L. REPAIRED SKIN IAW EO & EA.SDR SWAA2014021024938Skin · crackedSKIN CRACKED AT BS 927+3.5, STRINGER 21L. REPAIRED SKIN IAW EO & EA.SDR SWAA2014021024937Plate · crackedLT WING UPPER SURFACE TE PLATE CRACKED BETWEEN WING STATION 391 TO WING STATION 402 IN UPPER SURFACE. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014021024936Plate · crackedRT WING NR 8 SPOILER PLATE CRACKED. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014012024275Plate · crackedRT WING PLATE CRACKED AT WBL 204.40. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014011624145Lens · brokenGALLEY NR 4 EMERGENCY EXIT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014010223744Floorbeam · crackedFLOOR BEAM WEB LOWER CHORD CRACKED AT BS 708, LBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2014021024978Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+1.5, LBL 24.5+14.5. REPAIRED WEB IAW EA.SDR SWAA2014021024935Door Frame · crackedFWD GALLEY DOOR AFT FRAME CRACKED. R & R DOOR IAW SRM.SDR SWAA2014020524894Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD AFT END CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD IAW EO & EA.SDR SWAA2014020524862Seat Track · crackedFLOOR BEAM UPPER CHORD SEAT TRACK CRACKED AT BS 727B, LBL 44.5. REPAIRED SEAT TRACK IAW EO & EA.SDR SWAA2014020524872Seat Track · crackedFLOOR BEAM UPPER CHORD SEAT TRACK CRACKED AT BS 727B, LBL 46.5. REPAIRED SEAT TRACK IAW EO & EA.SDR SWAA2014013024679Light · delaminatedFWD CABIN EEPLS DELAMINATED. R & R EEPLS IAW AMM.SDR SWAA2014012024274Plate · crackedPLATE CRACKED AT BS 1112 STRINGER 8R. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014011324057Holder · brokenFWD LAVATORY FLASHLIGHT HOLDER BROKEN. R & R HOLDER IAW MM.SDR SWAA2014010723814Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 709 LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013121823484Actuator · leakingLT WING GND SPOILER INBD ACTUATOR LEAKING. R & R ACTUATOR IAW MM.SDR SWAA2013121623367Lens · unsecureEMERGENCY EXIT SIGN FELL OFF. R & R LENS IAW AMM.SDR SWAA2013122723656Skin · crackedFUSELAGE SKIN CRACKED AT STATION 920 TO STATION 923.2, STRINGER 25R. REPAIRED SKIN IAW SRM & SWA EA.SDR SWAA2013122323606Skin · crackedFUSELAGE SKIN CRACKED AT STATION 784, STRINGER 22L. REPAIRED SKIN IAW SRM & SWA EA.SDR SWAA2013122323605Skin · crackedFUSELAGE SKIN CRACKED AT STATION 946 TO STATION 948.3, STRINGER 24R. REPAIRED SKIN IAW SRM.SDR SWAA2013121923536Skin · crackedCHEM MILL SKIN CRACKED AT BS 764, STRINGER 23L. REPAIRED SKIN IAW SRM.SDR SWAA2013121623366Skin · crackedSKIN CRACKED AT BS 482B TO BS 520, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2013121623365Retainer · looseLT WING INBD GND SPOILER LOWER SKIN PANEL SEAL RETAINER LOOSE FROM PANEL DUE TO INSERTS FAILING. R & R SPOILER IAW AMM.SDR SWAA2013121623364Skin · damagedLT WING INBD FORE FLAP DAMAGED UPPER SKIN CUT BY LOOSE SHELF SCREW. R & R FORE FLAP IAW AMM.SDR SWAA2013120923085Lens · unsecureRT OVERWING EMERGENCY EXIT LIGHT LENS OVER DOOR FELL OFF. SECURED LENS IAW EA.SDR SWAA2013120923084Lens · unsecureRT OVER WING EMERGENCY EXIT LIGHT LENS OVER DOOR FELL OFF. REPAIRED LENS IAW MM.SDR SWAA2013120523026Lens · looseFWD SERVICE DOOR EMERGENCY EXIT LIGHT LOOSE. R & R LENS IAW AMM.SDR SWAA2013121623287Fitting · crackedRT WING MID FLAP INBD TORQUE TUBE SUPPORT INBD FITTING FWD LOWER HOLE CRACKED. R & R MID FLAP IAW MM.SDR SWAA2013112622772Spoiler · delaminatedNR 9 SPOILER DELAMINATED. R & R NR 9 SPOILER IAW MM.SDR SWAA2013121123205Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 20R & 21R. R & R FRAME IAW SRM.SDR SWAA2013120923083Light · inoperativeRT OVERWING EMERGENCY EXIT INTERIOR LOWER LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2013120322899Frame · crackedFRAME CRACKED AT STATION 847, STRINGER 20R. REPAIRED FRAME IAW ACO.SDR SWAA2013120222847Angle · crackedNR 6 CANOE FAIRING THE OTBD ANGLE AT THE FORE FLAP CRACKED. R & R ANGLE IAW SRM.SDR SWAA2013112722796Light · inoperativeRT OVERWING DOOR EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED IAW MM.SDR SWAA2013112722795Light · inoperativeAFT LAVATORY EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED IAW MM.SDR SWAA2013112622771Bracket · looseL2 DOOR EVAC SLIDE AFT GIRT BAR BRACKET LOOSE. ADJUSTED L2 DOOR GIRT BAR BRACKET IAW SIP.
Back to Boeing 737-5H4