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 SWAA2014013124723Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW ATS ER & EA.SDR SWAA2014012724590Skin · crackedSKIN CRACKED AT BS 988.5 STRINGER 7L. REPAIRED SKIN IAW SRM.SDR SWAA2014012724589Support Angle · crackedRT WING UPPER TE PANEL SUPPORT ANGLE OTBD OF PYLON CRACKED AT AFT END. ANGLE IAW SRM.SDR SWAA2014012724610Skin · crackedFUSELAGE SKIN CRACKED AT BS 327, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2014012724609Skin · crackedFUSELAGE SKIN CRACKED AT BS 957.5, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2014012424516Skin · crackedFUSELAGE SKIN CRACKED AT BS 958.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2014012324458Bear Strap · crackedBEAR STRAP CRACKED AT BS 989 STRINGER 7L. REPAIRED STRAP IAW SRM.SDR SWAA2014012224405Pressure Panel · crackedNOSE WW CRACKED AT RT SIDE FWD PRESS PANEL, LOWER FWD CORNER. REPAIRED PANEL IAW SRM.SDR SWAA0144010124084Indicator · faultyDIVERT, WHEN FLAP 15 SELECTED FLAPS INDICATED 10. WHEN ALTERNATE FLAPS SWITCH ARMED, LT FLAP INDICATED 15 RT FLAP INDICATED 10. R & R INDICATOR IAW MM.SDR SWAA2014011324064Slat · crackedRT WING NR 6 SLAT CRACKED. REPAIRED SLAT IAW SRM.SDR SWAA2014011324032Skin · delaminatedRT WING INBD AFT FLAP TE UPPER SURFACE DELAMINATED. R & R AFT FLAP IAW MM.SDR SWAA2014011324031Lens · brokenFWD ENTRY EMERGENCY EXIT LIGHT LENS BROKEN. R & R LENS IAW MM.SDR SWAA2014011324073Sign · unsecureOVERWING EMERGENCY EXIT SIGN FELL OFF. REINSTALLED SIGN IAW SIP.SDR SWAA2014020324785Frame · crackedFRAME CRACKED AT BS 727, STRINGER 18L. REPAIRED FRAME IAW ATS & EA.SDR SWAA2014020324774Frame · crackedFRAME CRACKED AT BS 727, STRINGER 18R. REPAIRED FRAME IAW ATS ER & EA.SDR SWAA2014013024681Doubler · corrodedSKIN DOUBLER CORRODED AT BS 727E+3 RBL 11. R & R DOUBLER IAW DRAWING & SRM.SDR SWAA2014012724588Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767 BETWEEN LBL 5 TO RBL 5. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014012724587Shear Tie · corrodedSHEAR TIE CORRODED AT BS 907 BETWEEN LBL 3 TO RBL 3.5. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014012724586Shear Tie · corrodedSHEAR TIE CORRODED AT BS 927 BETWEEN RBL 15 TO RBL 17. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014012724613Skin · crackedRT WING NR 5 LE SLAT LOWER SKIN OTBD AFT OF OTBD AUXILIARY TRACK CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014012724612Skin · crackedLT WING NR 2 LE SLAT LOWER SKIN INBD AFT OF INBD AUXILIARY TRACK CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014012324457Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767 LBL 18.5. R & R SHEAR TIE IAW SRM.SDR SWAA2014011324016Frame · crackedFRAME CRACKED AT BS 500B BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW SWA EA.SDR SWAA2014011324033Light · inoperativeFWD ENTRY DOOR LOWER EMERGENCY EXIT LIGHT INOPERATIVE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014011324072Lens · brokenLT OVERWING EMERGENCY EXIT LIGHT LENS BROKEN. R & R LENS IAW SIP.SDR SWAA2014012924668Frame · crackedFRAME CRACKED AT BS 500C BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2014012724585Rib · crackedRT WING INSIDE THE TANK, RIB 135.5 LOWER CHORD, BETWEEN STRINGER S2 & S3, AFT LOWER CHORD RADIUS CRACKED. REPAIRED CHORD IAW SWA EA.SDR SWAA2014012324479Pressure Deck · crackedPRESS DECK FLOOR CRACKED AT BS 665 LBL 33. REPAIRED DECK IAW SRM.SDR SWAA2014011524130Acm · faultyAIR TURN BACK, DECLARED EMERGENCY. CREW REPORTED LT PACK TURN ON, GOES TO OVERTEMP NO CONTROL WITH MANUAL OR AUTO MODE. R & R AIR CYCLE MACHINE & AIR MIX VLV IAW MM.SDR SWAA2014011524074Module · faultyAIR TURN BACK, DECLARED EMERGENCY ON DEPARTURE, FLIGHT ATTENDANT REPORTED SMOKE & FUMES IN CABIN, PERFORMED QRH. DURING QRH PROCEDURES, SMOKE DISSIPATED AFTER PACK SELECTED OFF. RETURNED TO DTW. R & R HYD RESERVOIR AIR PRESSURE MODULE & LT COALESCENT BAG ISDR SWAA2014011424098Bracket · brokenFWD CARGO COMPARTMENT DOOR HOOK BRACKET BROKEN. R & R BRACKET IAW SRM.SDR SWAA2014011324074Coalescer Bag · faultyON DEPARTURE FLIGHT ATTENDANT REPORTED SMOKE & FUMES IN CABIN. R & R COALESCENT BAG & CABIN RECIRCULATING FILTER IAW AMM.SDR SWAA2014010923923Skin · crackedRT WING NR 5 SLAT UPPER SURFACE CRACKED. R & R NR 5 SLAT IAW AMM.SDR SWAA2014010923922Cover · crackedFWD ENTRY LOWER EMERGENCY EXIT LIGHT ASSEMBLY COVER CRACKED. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014010923910Skin · delaminatedRT WING INBD FORE FLAP UPPER SURFACE DELAMINATED. R & R FORE FLAP IAW MM.SDR SWAA2014012324452Skin · crackedAFT CARGO DOOR SKIN CRACKED AT UPPER AFT FASTENER HOLE OF DOOR HANDLE CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014012024264Support Bracket · brokenR2 DOOR EMERGENCY EVAC SLIDE SUPPORT BRACKET BROKEN. R & R BRACKET IAW DRAWING & SRM.SDR SWAA2014011424111Channel · crackedSPLICE CHANNEL CRACKED AT BS 908, STRINGER 4R. R & R CHANNEL IAW SRM & BAC DRAWING.SDR SWAA2014010923909Lug · brokenRT WING NR 5 GND SPOILER LUG BROKEN. R & R SPOILER IAW MM.SDR SWAA2014010923908Lens · missingAFT RT EMERGENCY EXIT SIGN LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2014010823904Smoke Detector · faultyAFT LAVATORY SMOKE DETECTOR WENT OFF IN FLIGHT. R & R DETECTOR IAW MM.SDR SWAA2014010823878Light · brokenL1 DOOR EMERGENCY EXIT THRESHOLD LIGHT BROKEN. R & R LIGHT IAW SIP.SDR SWAA2014011424110Splice · crackedSPLICE CRACKED AT BS 908, STRINGER 4L. R & R SPLICE IAW SRM & BAC DRAWING.SDR SWAA2014010723844Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 440 STRINGER 9L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014010723843Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 440, STRINGER 8L. R & R CLIP IAW SRM.SDR SWAA2014010723807Cover · brokenL1 DOOR EMERGENCY EXIT LIGHT COVER BROKEN. R & R LIGHT IAW MM.SDR SWAA2014010923938Smoke Detector · faultyAFT LAVATORY SMOKE DETECTOR ALARM SOUNDED. NO SMOKE, NO FIRE DETECTED. R & R DETECTOR IAW MM.SDR SWAA2014012724608Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 787, STRINGER 26R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014011324066Skin · delaminatedRT WING OTBD AFT FLAP INBD END DELAMINATED ON LOWER SURFACE & UPPER SURFACE. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014011324053Bulkhead · crackedVERTICAL BEAM WEB CRACKED AT BS 178 LBL 5.7. REPAIRED WEB IAW SRM.
Back to Boeing 737-3H4