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 SWAA2014021024968Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360, STRINGER 15L. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2014021024966Fitting · crackedFRAME CLIP CRACKED UNDER Z CHANNEL AT BS 947.5, STRINGER 25R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014021024965Web · crackedFWD ENTRY DOOR SURROUND STRUCTURE WEB CRACKED AT BS 348.2, STRINGER 16L. R & R WEB IAW SRM & DRAWING.SDR SWAA2014020624915Skin · crackedRT BS 460+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED BETWEEN HOLES 2 & 3. REPAIRED SKIN IAW SB.SDR SWAA2014020624914Skin · crackedLT BS 400+10 LOWER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE 8. REPAIRED SKIN IAW EA.SDR SWAA2014020324768Angle · crackedFWD ENTRY DOOR SURROUND STRUCTURE ANGLE CRACKED BETWEEN BS 294.5 TO BS 303.9, STRINGER 16L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014013124720Strap · crackedSTRAP CRACKED AT BS 328, LBL. R & R STRAP IAW SRM & DRAWING.SDR SWAA2014013024684Stiffener · crackedRT MLG WW CTR WING SECTION, REAR SPAR VERTICAL STIFFENER CRACKED AT BS 663.75 RBL 6.15. REPAIRED STIFFENER IAW SWA EA.SDR SWAA2014013024683Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380 STRINGER 8L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014012724615Door Frame · crackedR1 DOOR LOWER EDGE FRAME CRACKED AT AFT CORNER. R & R DOOR IAW MM.SDR SWAA2014012724591Flap · delaminatedRT WING AFT FLAP DELAMINATED. R & R AFT FLAP IAW MM.SDR SWAA2014012724573Skin · delaminatedRT WING OTBD FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014012424517Lens · looseRT OVERWING OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2014031926218Frame · damagedFRAME DAMAGED AT BS 767, LBL 2. REPAIRED FRAME IAW SRM.SDR SWAA2014022125371Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 665.5, RBL 39. REPAIRED WEB IAW EO & EA.SDR SWAA2014021225078Support Angle · crackedLT SIDE PYLON NR 1 ENG STRUT TORQUE BOX ACCESS PANEL 5757L SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021024960Fairing · crackedWW FAIRING LOWER CHORD CRACKED AT BS 680, RBL 60. R & R CHORD IAW SRM & DRAWING.SDR SWAA2014020324767Skin Panel · crackedLT WING FIXED LE LOWER SKIN PANEL CRACKED AT WBL 183.4. REPAIRED SKIN IAW EA.SDR SWAA2014012924663Light · inoperativeLT INTERIOR EMERGENCY EXIT LIGHTS INOPERATIVE. RELAMPED LIGHTS IAW AMM.SDR SWAA2014012924659Light · inoperativeRT INTERIOR EMERGENCY EXIT LIGHTS INOPERATIVE. RELAMPED LIGHTS IAW AMM.SDR SWAA2014012724614Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400 STRINGER 9L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014012724578Angle · crackedFWD CARGO DOOR LOWER AFT CORNER MODIFICATION ANGLE CRACKED AT FASTENER. R & R DOOR IAW MM.SDR SWAA2014012424512Lens · missingLT OVERWING EMERGENCY EXIT LENS MISSING. INSTALLED LENS IAW SIP.SDR SWAA2014012424531Casting · crackedLT WING INBD GND SPOILER ACTUATOR INBD CASTING CRACKED AT UPPER BOLT HOLE. R & R CASTING IAW SRM.SDR SWAA2014012424495Overheat Loop · faultyDIVERT, DECLARED EMERGENCY INTERMITTENT FAULT LIGHT ASSOCIATED WITH NR 2 ENG OVERHEAT LIGHT & OCCASIONAL BELL WITHOUT FIRE WARNING. R & R FAN LT UPPER LOOP & CORE AFT LOOP IAW AMM 24-11-11.SDR SWAA2014012324456Gusset · crackedR1 DOOR GUSSET CRACKED. R & R R1 DOOR IAW AMM.SDR SWAA2014012324455Spoiler · delaminatedLT WING INBD NR 4 GND SPOILER DELAMINATED. R & R SPOILER IAW AMM.SDR SWAA2014012324453Flap · out of adjustRT WING INBD AFT FLAP OUT OF ADJUSTMENT. ADJUSTED AFT FLAP IAW AMM.SDR SWAA2014022125370Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2014022125369Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A LT. REPAIRED CHORD IAW EO & EA.SDR SWAA2014022125368Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 666, RBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2014022025338Floor Support · crackedLONGITUDINAL FLOOR BEAM CRACKED AT BS 667, LBL 24.5. REPAIRED BEAM IAW EO & EA.SDR SWAA2014022025337Floor Support · crackedLONGITUDINAL FLOOR BEAM CRACKED AT BS 667, LBL 24.5. REPAIRED BEAM IAW EO & EA.SDR SWAA2014022025336Floor Support · crackedLONGITUDINAL FLOOR BEAM CRACKED AT BS 669, LBL 24.5. REPAIRED BEAM IAW EO & EA.SDR SWAA2014022025335Skin Panel · crackedWW LOWER AREA LOWER SKIN PANEL CRACKED AT BS 685, LBL 4. R & R PANEL IAW SRM & EA.SDR SWAA2014011925310Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 709, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021925309Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 708, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021925308Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 707, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021825267Skin · crackedSKIN CRACKED AT BS 380, STRINGER 14L. REPAIRED SKIN IAW SRM.SDR SWAA2014021024959Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD IAW EA.SDR SWAA2014021024958Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 727B, LBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2014012724577Structure · crackedCHORD CRACKED AT BS 348.2 STRINGER 17L. R & R CHORD IAW SRM & DRAWING.SDR SWAA2014012724575Frame · crackedFRAME CRACKED AT BS 500B BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW SRM.SDR SWAA2014012724574Structure · delaminatedRT ELEVATOR DELAMINATED AT TE. R & R ELEVATOR IAW AMM.SDR SWAA2014012324492Skin · crackedLT WING NR 2 SLAT LOWER SURFACE LE CRACKED. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2014012224424Coalescer Bag · dirtyAIR TURN BACK, DECLARED EMERGENCY AFTER TAKEOFF. AT APPROXIMATELY 4000 FEET FWD LAVATORY SMOKE ALARM WAS ON WITH AN ACRID SMELL. RETURNED TO MIDWAY. R & R COALESCENT BAGS IAW MM.SDR SWAA2014012224423Fairing · damagedRT WING NR 8 FLAP TRACK AFT FAIRING INBD HINGE RELIEF HOLE DAMAGED. REPAIRED FAIRING IAW EA.SDR SWAA2014012224420Flap · delaminatedRT WING OTBD FORE FLAP OTBD END DELAMINATED. R & R FORE FLAP IAW AMM.SDR SWAA2014012224419Fairing · crackedLT ELEVATOR TAB UPPER FAIRING CRACKED. R & R FAIRING IAW DRAWING & SRM.SDR SWAA2014012224418Skin · delaminatedLT WING NR 0 SPOILER UPPER SURFACE DELAMINATED. R & R NR 0 SPOILER IAW AMM.
Back to Boeing 737-3H4