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 SWAA2016050351524Beam · crackedAFT CARGO DOOR AFT END OF E BEAM CRACKED AT OTBD SIDE, FWD END OF STOP FITTING IN WEB. REPAIRED E BEAM IAW EA.SDR SWAA2016042551255Skin · crackedRIGHT WING UPPER SKIN CRACKED AT REAR SPAR WBL 171.25. REPAIRED SKIN IAW EA.SDR SWAA2016042551254Skin · crackedLEFT WING UPPER SKIN AT REAR SPAR CRACKED AT WBL 171.25. REPAIRED SKIN IAW EA.SDR SWAA2016040150769Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 951.5, STRINGER 20R. R & R CLIP IAW SRM & DWG.SDR SWAA2016041150768Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 947.5, STRINGER 27R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2016040550616Stringer Clip · corrodedAFT CARGO BAY STRINGER CLIP CORRODED AT BS 947.5, STRINGER 27R. R & R CLIP IAW SRM.SDR SWAA2016040550615Stringer Clip · corrodedAFT CARGO BAY STRINGER CLIP CORRODED AT BS 947.5, STRINGER 27L. R & R CLIP IAW SRM.SDR SWAA2016040150528Flap Track · looseRIGHT WING OTBD MID FLAP INBD AFT FLAP TRACK LOOSE. R & R MID FLAP IAW MM.SDR SWAA2016033050435Attach Angle · crackedRIGHT WING NR 6 INBD FLAP, OTBD TRACK FAIRING, OTBD FWD LOWER PANEL ATTACH ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2016033050434Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2016033050424Flap · brokenRIGHT WING OTBD MID FLAP, INBD AFT FLAP, TRACK SUPPORT ASSEMBLY BROKEN. R & R MID FLAP IAW MM.SDR SWAA2016033050423Glowstrip · wornRIGHT PHOTO LUMINESCENT STRIP WORN AT ROW 6. R & R STRIP IAW AMM.SDR SWAA2016032950335Bracket · out of positionR2 DOOR EMER EVAC SLIDE GIRT BAR BRACKET OUT OF POSITION. REPOSITIONED BRACKET IAW SIP.SDR SWAA2016040150508Strap · crackedE & E COMPARTMENT MAIN DECK STABILIZER STRAP CRACKED AT BS 312, LBL 12. REPAIRED STRAP IAW SRM.SDR SWAA2016033050439Strap · brokenRIGHT OVERWING ESCAPE HATCH BODY CUT OUT, EXIT HATCH ESCAPE STRAP BROKEN. R & R STRAP IAW AMM.SDR SWAA2016033050426Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT ROW 1. RELAMPED LIGHT IAW MM.SDR SWAA2016032950372Lens · unsecureLEFT EMER EXIT SIGN LENS FELL OUT. INSTALLED LENS IAW MM.SDR SWAA2016032950370Lens · unsecureRIGHT EMER EXIT SIGN LENS FELL OUT. INSTALLED LENS IAW MM.SDR SWAA2016032950334Frame · corrodedAFT CARGO BAY, FRAME CORRODED AT BS 927, BETWEEN STRINGER 18R - 20R. REPAIRED FRAME IAW SRM.SDR SWAA2016032950333Retaining Clip · looseL1 DOOR GIRT BAR LOOSE. SECURED CLIPS IAW SIP.SDR SWAA2016032850308Light · inoperativeL1 DOOR EMER EXIT LIGHT INOPERATIVE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2016032850265Slide · out of positionR2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2016032850199Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2016041851059Crease Beam · crackedL1 DOOR CREASE BEAM INNER CHORD VERTICAL FLANGE CRACKED AT BS 351.2. R & R CREASE BEAM IAW SRM & DWG.SDR SWAA2016040850709Strap · crackedBELOW FLOOR STRAP CRACKED AT BS 312, LBL 54. R & R STRAP IAW SRM.SDR SWAA2016032950373Stringer · corrodedSTRINGER CORRODED AT BS 902, STRINGER 23R. R & R STRINGER IAW SRM.SDR SWAA2016032850200Control Panel · faultyDIVERSION AT CRUISE, FIRE WARNING LIGHT ILLUMINATED & BELL SOUNDED FOR APPROX 5 SECONDS. ALL LIGHTS & INDICATIONS ON THE FIRE PANEL WERE ILLUMINATED DURING THE WARNING AS IF THE LAMP TEST BUTTON HAD BEEN PUSHED. R & R CARGO FIRE PANEL.SDR SWAA2016051351763Spar · crackedLEFT WING UPPER REAR SPAR CHORD CRACKED AT RSS 221. REPAIRED CHORD IAW EA.SDR SWAA2016051251745Spar · crackedRIGHT WING UPPER REAR SPAR CHORD CRACKED AT RSS 221. REPAIRED CHORD IAW EA.SDR SWAA2016050251490Pressure Deck · crackedMAIN LANDING GEAR PRESS DECK, UPPER SURFACE CRACKED, AT BS 665, LBL 39. REPAIRED DECK IAW EA.SDR SWAA2016041150786Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4R. R & R SPLICE IAW EA.SDR SWAA2016041150785Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 5L. R & R SPLICE IAW EA.SDR SWAA2016040850708Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 980, STRINGER 4L. R & R SPLICE IAW EA.SDR SWAA2016050451542Retaining Clip · looseR1 DOOR ESCAPE SLIDE COVER FWD GIRT BAR RETAINING CLIP LOOSE. R & R CLIP IAW SRM.SDR SWAA2016042051125Crease Beam · corrodedRIGHT CREASE BEAM WEB CORRODED, BETWEEN BS 500 - 500A. R & R WEB IAW SRM & DWG.SDR SWAA2016041450926Rib · crackedLEFT WING INSPAR RIB WEB CRACKED ON RIB WEB ON WBL 198.60, AT LEVEL OF S 5 FUEL TANK. REPAIRED WEB IAW EA.SDR SWAA2016040750677Sign · brokenL2 DOOR EMER EXIT SIGN MOUNTED ON AFT LAVATORY LENS LOCKING TAB BROKEN. R & R SIGN IAW AMM.SDR SWAA2016040550605Tie Clip · crackedSTRINGER TIE CLIP CRACKED AT BS 907, STRINGER 4L. R & R CLIP IAW SRM & DWG.SDR SWAA2016032850254Cover · looseCENTER CABIN EMER EXIT LIGHT COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2016032850198Panel · damagedAIR TURN BACK INSPECTION PANEL RT WING PEELED OFF. R & R PANEL 5348 IAW SIP.SDR SWAA2016041350841Tie Clip · crackedTIE CLIP CRACKED AT BS 907, STRINGER 8L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2016041150787Mount · damagedR2 DOOR SLIDE UPPER MOUNTS DAMAGED. R & R MOUNTS IAW SRM.SDR SWAA2016040550604Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 10R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2016040150527Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727D, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2016033050437Battery Pack · dischargedLEFT EMER EXIT PATHWAY LIGHTING INOPERATIVE, BETWEEN ROW 2 - 6. R & R BATTERY PACK IAW MM.SDR SWAA2016033050436Battery Pack · dischargedFORWARD ENTRY DOOR EMER EXIT LIGHT INOPERATIVE. CHARGED BATTERY PACK IAW MM.SDR SWAA2016033050419Battery Pack · dischargedRIGHT EMER EXIT PATHWAY LIGHTING INOPERATIVE, BETWEEN ROW 20 - 24. R & R BATTERY PACK IAW MM.SDR SWAA2016032850272Stiffener · crackedLEFT WING AILERON STIFFENER CRACKED AT NR 2 HINGE FROM INBD. R & R STIFFENER IAW SRM.SDR SWAA2016032850295Wire · disconnectedL2 DOOR EMER EXIT LIGHT INOPERATIVE. CONNECTED WIRE IAW AMM.SDR SWAA2016032850290Battery · dischargedAFT GALLEY EMER EXIT LIGHT INOPERATIVE AT M1197. REPLACED BATTERY IAW AMM.
Back to Boeing 737-3H4