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 SWAA2014031926226Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328, STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031926225Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 323.7, STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031926219Web · crackedWEB CRACKED BETWEEN BS 294.5 TO BS 303.9, STRINGER 7L. R & R WEB IAW SRM & DWG.SDR SWAA2014031726093Plate · crackedLT HORIZONTAL STABILIZER ACCESS PANEL 9123 L PLATE CRACKED. R & R PLATE IAW SRM & DWG.SDR SWAA2014031326029Stringer Clip · damagedSTRINGER CLIP DAMAGED AT STATION 908, STRINGER 4L. R & R CLIP IAW SRM.SDR SWAA2014031326006Sign · looseEXIT SIGN NEAR L1 DOOR LOOSE. SECURED SIGN IAW MM.SDR SWAA2014041427045Skin · crackedR1 DOOR AFT LOWER SKIN CUT OUT CRACKED AT BS 328, BETWEEN STRINGER 16R TO STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014041026978Skin · crackedFUSELAGE SKIN CRACKED AT BS 328, BETWEEN STRINGER 16R TO STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014041026977Skin · crackedFUSELAGE SKIN CRACKED AT BS 328, BETWEEN STRINGER 16R TO STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014040826920Keelbeam · crackedRIGHT KEEL BEAM CRACKED AT BS 540. REPAIRED KEEL BEAM IAW SRM.SDR SWAA2014040726842Skin · crackedSKIN CRACKED AT BS 992.8-5, BETWEEN STRINGER 8R TO STRINGER 9R. REPAIRED SKIN IAW SRM.SDR SWAA2014040726841Web · corrodedWEB CORRODED BETWEEN BS 827 TO BS 847, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2014040326793Channel · crackedRIGHT WING NR 6 FLAP TRACK FAIRING CHANNEL CRACKED. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014040126722Angle · crackedRIGHT WING NR 6 LOWER POSITION FLAP TRACK FAIRING ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014040126721Frame · crackedFRAME CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR SWAA2014040126706Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 727A, BETWEEN STRINGER 25-26L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014032626524Cargo Track · crackedCARGO TRACK CRACKED AT BS 747, RBL 13.8. REPAIRED CARGO TRACK IAW SRM.SDR SWAA2014032426479Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS 540, RBL 1. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032426474Shear Tie · corrodedSHEAR TIE CORRODED AT BS 827, BETWEEN STRINGER 26R TO STRINGER 27R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014032426378Angle · crackedFORWARD CARGO COMPARTMENT ANGLE CRACKED AT BS 540, LBL 1. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032026248Skin · delaminatedLT WING INBD FORE FLAP UPPER SKIN DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014031726175Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 8R. R & R CLIP IAW SRM & DWG.SDR SWAA2014031326022Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 400, STRINGER 28L. R & R CLIP IAW SRM.SDR SWAA2014031326021Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 480, STRINGER 22L. R & R CLIP IAW SRM.SDR SWAA2014031225982Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727A, STRINGER 10L. R & R CLIP IAW SRM & EA.SDR SWAA2014031225981Skin · crackedSKIN CRACKED AT BS 727A+10, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2014031225979Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727B, STRINGER 10L. R & R CLIP IAW SRM & EA.SDR SWAA2014031225973Tie Clip · crackedTIE CLIP CRACKED AT BS 787, STRINGER 22R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014031225972Tie Clip · crackedTIE CLIP CRACKED AT BS 767, STRINGER 20R. R & R TIE CLIP IAW & DRAWING.SDR SWAA2014031225971Angle · crackedANGLE CRACKED BETWEEN BS 500D TO BS 520, BL 0. R & R ANGLE IAW SRM.SDR SWAA2014031125946Light · inoperativeLT OVERWING EMERGENCY EXIT LIGHT BULB INOPERATIVE. R & R BULB IAW MM.SDR SWAA2014041427050Angle · crackedWING TO BODY FAIRING INTERNAL AREA ANGLE CRACKED AT BS 540, STRINGER 22R. REPAIRED ANGLE IAW EA.SDR SWAA2014041026976Skin · crackedSKIN CRACKED AT BS 951+11, STRINGER 17L. REPAIRED SKIN IAW EA.SDR SWAA2014040926948Support Angle · crackedLEFT FWD WING TO BODY FAIRING SUPPORT ANGLE CRACKED AT BS 540. R & R ANGLE IAW SRM & DWG.SDR SWAA2014040826937Drag Angle · crackedWING TO BODY FAIRING INTERNAL AREA DRAG ANGLE CRACKED AT BS 540, STRINGER 22R. REPAIRED ANGLE IAW SRM.SDR SWAA2014040726868Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014033126648Stringer Clip · crackedCLIP CRACKED AT BS 360, STRINGER 9L. R & R CLIP IAW SRM & DWG.SDR SWAA2014032426471Fastener · missingFORWARD ENTRY DOOR CUT OUT AFT SIDE FRAME INNER CHORD FASTENER MISSING AT BS 348.2, STRINGER 15L. INSTALLED FASTENER IAW EA & EA.SDR SWAA2014032426377Web · crackedWEB CRACKED BETWEEN BS 348 TO BS 352, STRINGER 16L. R & R WEB IAW SRM & DWG.SDR SWAA2014032426376Intercostal · crackedINTERCOSTAL CRACKED AT BS 540, BETWEEN BL 0 & LBL 24.5. R & R INTERCOSTAL IAW SRM.SDR SWAA2014031726092Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 540, STRINGER 24L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031125951Tie Clip · crackedTIE CLIP CRACKED AT BS 500C, STRINGER 22L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014031125950Tie Clip · crackedTIE CLIP CRACKED AT BS 500A, STRINGER 22L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014031125949Angle · crackedANGLE CRACKED AT BS 500A, STRINGER 26L. R & R ANGLE IAW SRM.SDR SWAA2014031025900Light · inoperativeLT EMERGENCY LIGHTS INOPERATIVE AT ROW 2. RELAMPED LIGHT IAW MM.SDR SWAA2014031025899Light · inoperativeR1 DOOR EMERGENCY LIGHTS INOPERATIVE AT ROW 2. RELAMPED LIGHT IAW MM.SDR SWAA2014041127044Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT BS 663.75=5.5, LBL 46.5. REPAIRED WEB IAW EA.SDR SWAA2014041127043Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT BS 663.75+1, LBL 24.5+13. REPAIRED WEB IAW EA.SDR SWAA2014041127042Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT BS 663.75, LBL 24.5. REPAIRED WEB IAW EA.SDR SWAA2014041127041Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT BS 663.8, RBL 24.5. REPAIRED WEB IAW EA.
Back to Boeing 737-3H4