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 SWAA2014040326806Skin · crackedLEFT BS 727D+10 UPPER AFT WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014040326785Angle · corrodedAFT ENTRY DOOR MOPSILL SPLICE ANGLE CORRODED BETWEEN BS 997 - 1016, RBL 45. R & R ANGLE IAW SRM.SDR SWAA2014040326784Angle · corrodedAFT ENTRY DOOR MOPSILL SPLICE ANGLE CORRODED BETWEEN BS 997 - 1016, LBL 45. R & R ANGLE IAW SRM.SDR SWAA2014040126734Forging · crackedRIGHT BS 847+10 LOWER FWD WINDOW CORNER FORGING CRACKED. REPAIRED FORGING IAW TC.SDR SWAA2014040126733Forging · crackedRIGHT BS 847+10 UPPER AFT WINDOW CORNER FORGING CRACKED. REPAIRED FORGING IAW TC.SDR SWAA2014040126732Skin · crackedRIGHT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014040126731Skin · crackedRIGHT BS 727E+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014040126730Skin · crackedLEFT BS 847+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014040126729Skin · crackedLEFT BS 767+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014040126728Skin · crackedLEFT BS 747+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014040126727Skin · crackedLEFT BS 767+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014033126662Skin · crackedRIGHT BS 807+10 UPPER AFT WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014033126685Skin · crackedRIGHT BS 807+10 LOWER FWD WINDOW CORNER CUT OUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014033126680Skin · crackedRIGHT BS 787+10 LOWER FWD WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014033126679Skin · crackedRIGHT BS 767+10 LOWER FWD WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014032426372Hinge Fitting · crackedLT WING NR 4 GND SPOILER HINGE FITTING CRACKED AT WBL 99.25. R & R FITTING IAW SRM & DWG.SDR SWAA2014031926233Light · brokenFORWARD ENTRY BOTTOM EMERGENCY EXIT SIGN LIGHT ASSEMBLY BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014032626525Flap · delaminatedRIGHT WING FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014031726096Light · inoperativeFWD ENTRY DOOR EMERGENCY EXIT INDICATOR LIGHT INOPERATIVE. R & R LIGHT ASSEMBLY IAW SIP.SDR SWAA2014031726075Lens · unsecureFORWARD ENTRY EMERGENCY EXIT LIGHT LENS COVER FELL OFF. R & R LENS ASSEMBLY IAW MM.SDR SWAA2014031726142Lens · brokenR1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014031726140Sign · looseL1 DOOR EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2014040826924Strap · crackedFLOORBEAM STABILIZER STRAP CRACKED AT BS 314, BL 0. R & R STRAP IAW SRM & DWG.SDR SWAA2014040126710Panel · crackedL1 DOOR CUT OUT COVE PANEL CRACKED AROUND PROXIMITY SENSOR BETWEEN STRINGER 8 - 9L. R & R PANEL IAW SRM & DWG.SDR SWAA2014033126636Fitting · crackedRIGHT WING PANEL 58710R ON UPPER WING AFT EDGE OF CUT OUT SURFACE OVER PYLON FITTING CRACKED. R & R FITTING IAW AMM.SDR SWAA2014033126635Web · crackedLONGITUDINAL FLOORBEAM VERTICAL WEB CRACKED BETWEEN BS 707 TO BS 708, RBL 25. REPAIRED WEB IAW EA.SDR SWAA2014033126634Strap · crackedFLOORBEAM STABILIZER STRAP CRACKED AT BS 314, RBL 31. R & R STRAP IAW SRM.SDR SWAA2014033126621Cover · crackedFORWARD ENTRY DOOR FWD CUT OUT PANEL COVER CRACKED BETWEEN STRINGER 14L TO STRINGER 16L. R & R COVER IAW SRM & DWG.SDR SWAA2014032726549Strap · crackedFLOORBEAM STABILIZER STRAP CRACKED AT BS 314, LBL 12. R & R STRAP IAW SRM.SDR SWAA2014032426388Pressure Panel · crackedVERTICAL UPPER PRESS PANEL CRACKED AT BS 663, BETWEEN RBL 45.5 TO RBL 60. R & R PANEL IAW SRM & DWG.SDR SWAA2014031726105Sign · damagedCTR AISLE EMERGENCY EXIT SIGN DAMAGED AT ROW 2. R & R SIGN IAW AMM.SDR SWAA2014031726097Skin · damagedFUSELAGE SKIN DAMAGED BETWEEN BS 855 TO BS 890, BETWEEN STRINGER 26R TO STRINGER 27R. REPAIRED SKIN IAW SRM.SDR SWAA2014031726141Slide · low pressureL2 DOOR EMERGENCY EVAC SLIDE PRESS GAUGE LOW. R & R SLIDE IAW MT.SDR SWAA2014031726139Light · inoperativeRT AFT WING TO BODY EMERGENCY LIGHT INOPERATIVE. RE LAMPED LIGHT IAW MM.SDR SWAA2014041427053Frame · corrodedFRAME CORRODED AT BS 344, BETWEEN STRINGER 26R TO STRINGER 27R. REPAIRED FRAME IAW EA.SDR SWAA2014040926950Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 947.5, LBL 53. REPAIRED CHORD IAW EA.SDR SWAA2014040726839Web · crackedL2 DOOR FWD WEB CRACKED. R & R WEB IAW SRM & DWG.SDR SWAA2014032426487Skin · crackedAFT CARGO DOOR, OUTER DOOR HANDLE SKIN CUT OUT, AFT UPPER CORNER SKIN CRACKED COMMON TO FASTENER HOLE. REPAIRED SKIN IAW EA.SDR SWAA2014032426441Sign · inoperativeINTERIOR EMERGENCY EXIT SIGN LIGHT INOPERATIVE. RELAMPED SIGN ASSEMBLY IAW AMM.SDR SWAA2014032426440Sign · inoperativeLEFT AFT EMERGENCY EXIT SIGN ASSEMBLY INOPERATIVE. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2014032426343Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 294.5, STRINGER 23L. R & R BRACKET IAW SRM & DWG.SDR SWAA2014032426342Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STRINGER 4R. R & R SPLICE IAW SRM & DWG.SDR SWAA2014032426341Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STRINGER 4L. R & R SPLICE IAW SRM & DWG.SDR SWAA2014032426340Angle · crackedANGLE CRACKED BETWEEN BS 927 TO BS 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032426339Angle · crackedANGLE CRACKED AT BS 907, BETWEEN STINGER 1 TO STRINGER 2L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032426338Angle · crackedANGLE CRACKED AT BS 887, BETWEEN STRINGER 1 TO STRINGER 2L. R & R ANGLE IAW SRM.SDR SWAA2014032426337Angle · crackedANGLE CRACKED AT BS 887, BETWEEN STRINGER 1 TO STRINGER 2R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032026249Charger · inoperativeEMERGENCY EXIT LIGHT OVERHEAD BIN INOPERATIVE AT ROW NR 1. R & R BATTERY CHARGER IAW AMM.SDR SWAA2014032026242Angle · crackedANGLE CRACKED AT BS 907, BETWEEN STRINGER 1 TO STRINGER 2R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032026267Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 767 TO BS 787, STRINGER 25R. R & R INTERCOSTAL IAW SRM & DWG.
Back to Boeing 737-3H4