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 SWAA2014070929820Frame · crackedFORWARD FACE FRAME WEB CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR SWAA2014070929819Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STRINGER 27R TO 26R. REPAIRED FRAME IAW SRM.SDR SWAA2014070829724Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 957, STRINGER 25L. R &R ANGLE IAW SRM & DWG.SDR SWAA2014070729640Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 947.5, STRINGER 25L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014070729639Door Frame · crackedFORWARD CARGO DOOR CUT OUT FRAME WEB CRACKED AT BS 492, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR SWAA2014070729638Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+9", LBL 24.50+15". REPAIRED WEB IAW EO & EA.SDR SWAA2014070729637Pressure Deck · crackedWHEEL WELL PRESS DECK WEB CRACKED AT BS 663.75+2", LBL 24.50+14.5". REPAIRED WEB IAW EO & EA.SDR SWAA2014070229603Support Angle · crackedSUPPORT ANGLE CRACKED AT STATION 962, STRINGER 25L. R & R ANGLE IAW SRM.SDR SWAA2014070129549Shear Tie · corrodedFUSELAGE SHEAR TIE CORRODED AT STATION 1006, STRINGER 27L TO 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014070129548Frame · crackedFUSELAGE FRAME CRACKED AT STATION 787, STRINGER 25R. REPAIRED FRAME IAW SRM.SDR SWAA2014062729461Stringer · corrodedSTRINGER 27L CORRODED AT STATION 1006. REPAIRED STRINGER IAW SRM.SDR SWAA2014062729459Intercostal · crackedINTERCOSTAL CRACKED AT STATION 787, STRINGER 25R. R & R INTERCOSTAL IAW SRM.SDR SWAA2014062429343Plate · crackedACCESS PANEL 9508R PLATE CRACKED. R & R PLATE IAW SRM & DWG.SDR SWAA2014062429342Access Panel · crackedRIGHT HORIZONTAL STABILIZER ACCESS PANEL 9223R CRACKED. R & R PLATE IAW SRM & DWG.SDR SWAA2014062329296Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 26L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014062329295Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 967, STRINGER 3L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014061629083Attach Bracket · crackedL1 DOOR LOWER SWEEPER SEAL ATTACH BRACKET CRACKED ON BOTH SIDES OF FASTENER. R & R DOOR ASSEMBLY IAW MM.SDR SWAA2014070829723Skin · crackedSKIN CRACKED AT BS 520+2, STRINGER 28R. REPAIRED SKIN IAW EO.SDR SWAA2014070229601Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 667, LBL 24.5. REPAIRED BEAM IAW EA.SDR SWAA2014070229599Skin · crackedFUSELAGE SKIN CRACKED AT STATION 400, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014070229598Skin · crackedFUSELAGE SKIN CRACKED AT STATION 380, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014070229597Charger · inoperativeFORWARD ENTRY EMER LIGHT BATTERY CHARGER M1674 INOPERATIVE. R & R CHARGER IAW MM.SDR SWAA2014070229595Stringer · damagedFUSELAGE STRINGER DAMAGED AT STATION 967, STRINGER 6L. REPAIRED STRINGER IAW EA.SDR SWAA2014061929200Plate · crackedLEFT WING TO BODY FAIRING ACCESS PANEL 3578L PLATE CRACKED. R & R PLATE IAW SRM.SDR SWAA2014061729120Strap · crackedBUTT SPLICE STRAP CRACKED AT BS 359.5, STRINGER 4R. R & R STRAP IAW SRM & DWG.SDR SWAA2014061629063Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED AT BS 850. REPAIRED WEB IAW SRM & DWG.SDR SWAA2014070729656Structure · crackedRIGHT CHORD CRACKED AT BS 727, STRINGER 18A, FWD LOWER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014070729636Structure · crackedLEFT CHORD CRACKED AT BS 727, STRINGER 18A, FWD LOWER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014070129550Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 500C, BETWEEN STRINGER 28L & 28R. REPAIRED FRAME IAW SRM.SDR SWAA2014061929208Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 27R TO 28R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014061729119Stringer · crackedSTRINGER CRACKED AT BS 376, STRINGER 4R. R & R STRINGER IAW SRM & DWG.SDR SWAA2014061128942Light · inoperativeL1 DOOR OVERHEAD EMER EXIT LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR SWAA2014060728924Light · inoperativeRIGHT OVERWING EMER EXIT SIDEWALL LIGHT INOPERATIVE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014060728922Lens · looseRIGHT OVERWING EMER EXIT LIGHT LENS LOOSE. R & R LENS IAW AMM.SDR SWAA2014070229594Skin · crackedFUSELAGE SKIN CRACKED AT STATION 380, STRINGER 14L. REPAIRED SKIN IAW EA.SDR SWAA2014062629428Stiffener · crackedAFT PRESS BULKHEAD STIFFENER CRACKED AT STATION 1066, BETWEEN STRINGER 15R & 21R. REPAIRED STIFFENER IAW EA.SDR SWAA2014061929207Skin · crackedRIGHT WING LE SKIN AT KRUEGER FLAP CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2014060728923Girt Bar · looseR2 DOOR EMER EVAC SLIDE GIRT LOOSE. SECURED GIRT BAR IAW MT.SDR SWAA2014062429352Rib · crackedRIGHT WING LOWER RIB CHORD CRACKED AT WBL 135.5, BETWEEN STRINGER 2 TO 3. REPAIRED CHORD IAW EA.SDR SWAA2014062429351Skin · crackedLEFT WING NR 3 SLAT SKIN CRACKED ON EXTERNAL LOWER SURFACE AT SLAT STATION 90.5. REPAIRED SKIN IAW SRM.SDR SWAA2014061829167Bracket · crackedBRACKET CRACKED AT BS 670, RBL 32. R & R BRACKET IAW SRM & DWG.SDR SWAA2014061128958Actuator · leakingRIGHT WING NR 6 SLAT ACTUATOR LEAKED. R & R ACTUATOR IAW AMM.SDR SWAA2014061028888Controller · faultyDIVERSION, DECLARED EMER LOST PRESSURIZATION AT FL360, EMER DESCENT. SYS WORKED IN STANDBY, NORMAL. R & R CABIN PRESS CONTROLLER, RT ENG PRE COOLER CONTROL VLV & AFT OUTFLOW VLV IAW MM.SDR SWAA2014070229590Skin · crackedRIGHT WING LE SKIN CRACKED AT NR 6 SLAT CUT OUT. REPAIRED SKIN IAW SRM & EA.SDR SWAA2014070129547Skin · crackedRIGHT WING LE SLAT AT NR 6 ACTUATOR LOWER SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014062329322Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED AT BS 1016, RBL 4. REPAIRED WEB IAW SRM.SDR SWAA2014061729118Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STRINGER 5R TO 6R. REPAIRED SKIN IAW EA.SDR SWAA2014061629080Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED AT BS 1016, LBL 5. REPAIRED WEB IAW SRM.SDR SWAA2014061629079Fitting · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE CLIP CRACKED BETWEEN BS 348.2 TO 351.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014061629078Strap · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE STRAP CRACKED AT BS 351.2, STRINGER 16L. R & R STRAP IAW SRM & DWG.
Back to Boeing 737-3H4