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 SWAA2013110521996Slide · low pressureL2 DOOR EMERGENCY EVAC SLIDE PRESSURE LOW. R & R SLIDE IAW SWA MT.SDR SWAA2013110521967Slide · low pressureR2 DOOR EMERGENCY EVAC SLIDE GAUGE PRESSURE LOW. R & R SLIDE IAW MT.SDR SWAA2013111322314Plate · crackedVERTICAL STABILIZER ACCESS PANEL 9507 PLATE CRACKED. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013111122109Splice · crackedSPLICE CRACKED AT BS 908, STRINGER 4L. R & R SPLICE IAW BAC DRAWING.SDR SWAA2013110521966Skin · crackedFUSELAGE SKIN CRACKED AT BS 727E+ 5, STRINGER 4R. REPAIRED SKIN IAW EA.SDR SWAA2013110521965Skin · crackedFUSELAGE SKIN CRACKED AT BS 727A+11, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2013110421846Lens · brokenR2 DOOR AFT GALLEY EMERGENCY LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2013110421845Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2013110421844Lens · missingAFT EMERGENCY EXIT LENS COVER MISSING. INSTALLED COVER IAW SIP.SDR SWAA2013120322927Pressure Deck · crackedMAIN WW PRESSURE DECK ON CENTER SECTION CRACKED AT BS 673.75, LBL 24.8+15. REPAIRED DECK IAW EO & EA.SDR SWAA2013120322926Pressure Deck · crackedMAIN WW PRESSURE DECK ON CENTER SECTION CRACKED AT BS 665.75, LBL 24.8+17. REPAIRED DECK IAW EO & EA.SDR SWAA2013120322925Floorbeam · crackedFLOOR BEAM UPPER CHORD CRACKED AT BS 947.5, LBL 53.5. REPAIRED CHORD IAW EA & EO.SDR SWAA2013120322924Floor Support · crackedLONGITUDINAL FLOOR BEAM CRACKED BETWEEN STATION 667 TO STATION 671, LBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2013111822505Stringer · crackedSTRINGER CRACKED AT BS 727+3, STRINGER 19R. REPAIRED STRINGER IAW SRM.SDR SWAA2013111822429Doubler · crackedNLG WW LT SIDE CRACKED AT BS 259.3. REPAIRED DOUBLER IAW SRM.SDR SWAA2013111422380Strap · crackedINTERNAL STRAP CRACKED AT BS 727+4, STRINGER 19R. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013111322326Plate · crackedVERTICAL STABILIZER ACCESS PANEL 9508 PLATE CRACKED. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013110722013Angle · crackedLT WING TE ANGLE CRACKED AT LEVEL WBL 183.40. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110521914Girt Bar · looseL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR LOOSE. SECURED GIRT BAR IAW MM.SDR SWAA2013110421812Fitting · missingAFT CARGO DOOR FWD, 2ND FROM BOTTOM STOP PIN MISSING LOCK CLIP & OUT OF ADJUSTMENT. INSTALLED LOCK CLIP IAW AMM.SDR SWAA2013120222836Angle · crackedFWD CARGO COMPARTMENT ANGLE CRACKED AT BS 540, LBL 1. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013112622760Frame · corrodedFUSELAGE FRAME CORRODED AT BS 500C, STRINGER 28L TO STRINGER 28R. REPAIRED FRAME IAW SRM.SDR SWAA2013111222256Bracket · crackedLT WING FLAP TRACK TRANSMISSION BRACKET CRACKED. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2013110521958Computer · faultyDECLARED EMERGENCY SMOKE EMANATING FROM CAPTAINS RADIO ALTIMETER. R & R B FCC IAW AMM.SDR SWAA2013110521957Angle · crackedEE COMPARTMENT ANGLE CRACKED AT BS 336, STRINGER 21L. R & R ANGLE IAW SRM & DRAWING. .SDR SWAA2013110521956Angle · crackedEE COMPARTMENT ANGLE CRACKED AT BS 328, STRINGER 21L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110521955Angle · crackedEE COMPARTMENT ANGLE CRACKED AT BS 320, STRINGER 21L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110521925Coalescer Bag · dirtyFOUL BURNT ODOR AT MID-CABIN. R & R WATER SEPARATOR BAGS IAW MM.SDR SWAA2013110521913Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B +6, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2013120222840Skin · crackedFUSELAGE SKIN CRACKED AT BS 951+8.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013112622766Skin · crackedFUSELAGE SKIN CRACKED AT BS 951+10.250, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013112622765Skin · crackedFUSELAGE SKIN CRACKED AT BS 951+8.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013112222723Skin · crackedFUSELAGE SKIN STRAP CRACKED AT BS 951+10.250 TO BS 951+3.250, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013112222722Pressure Panel · crackedMLG WW PRESSURE WEB CRACKED AT BS 665.75, LBL 32. REPAIRED WEB IAW SWA EA.SDR SWAA2013112122648Frame · crackedSTUD FRAME CRACKED AT BS 951 + 20, STRINGER 17L. R & R STUD FRAME IAW SRM & DRAWING.SDR SWAA2013111822515Bulkhead · crackedBULKHEAD DOME CAP CRACKED AT BS 1016, STRINGER 6L INBD SIDE. REPAIRED CAP IAW SRM.SDR SWAA2013111822513Attach Fitting · crackedL1 DOOR ATTACH CLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013111822532Stringer · crackedSTRINGER CRACKED AT STATION 569, STRINGER 6R. REPAIRED STRINGER IAW EA.SDR SWAA2013111322297Channel · crackedMAIN WW ANGLE CRACKED BETWEEN BS 663 TO BS 675, RBL 36. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2013111322296Intercostal · crackedINTERCOSTAL CRACKED AT BS 348.2, STRINGER 16L. R & R INTERCOSTAL IAW SRM & DRAWING.SDR SWAA2013111122144Flap · delaminatedRT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2013111122143Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360+7, STRINGER 27L. R & R SPLICE IAW SRM & DRAWING.SDR SWAA2013111122142Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5, STRINGER 23L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013111122129Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 727D, STRINGER 27R. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2013110722012Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 344, LBL 45. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013110722011Angle · crackedSUPPORT STRUCTURE ANGLE CRACKED BETWEEN BS 294.5 TO BS 312, LBL 24.5. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013110521912Flap Track · corrodedLT WING NR 2 FLAP TRACK CORRODED ON TOP SIDE NEAR REAR SPAR ATTACH POINT JUST AFT OF TAPERED SHIM. R & R NR 2 FLAP TRACK IAW AMM.SDR SWAA2013110521865Mount Bracket · crackedLT MAIN WW FIRE BOTTLE MOUNTING BRACKET CRACKED NEAR FWD RT MOUNT FASTENER. R & R BRACKET IAW SRM.SDR SWAA2013110421810Angle · crackedANGLE CRACKED AT ON RACK E2-4 EE COMPARTMENT. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013112622783Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R CLIP IAW SRM C
Back to Boeing 737-3H4