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 SWAA2016011147890Skin · crackedRIGHT WING UPPER SKIN HOLE AT REAR SPAR, CRACKED AT APPROX RSS 254, AFT ROW. REPAIRED SKIN IAW ER & EA.SDR SWAA2016011147889Skin · crackedRIGHT WING UPPER SKIN HOLE AT REAR SPAR, CRACKED AT APPROX RSS 250, AFT ROW. REPAIRED SKIN IAW ER & EA.SDR SWAA2016011147888Skin · crackedRIGHT WING UPPER SKIN HOLE AT REAR SPAR CRACKED AT APPROX RSS 239, AFT ROW. REPAIRED SKIN IAW ER & EA.SDR SWAA2016011147887Skin · crackedRIGHT WING UPPER SKIN HOLE AT REAR SPAR CRACKED AT APPROX RSS 217, FWD ROW. REPAIRED SKIN IAW ER & EA.SDR SWAA2016011147860Spar · crackedLEFT WING AFT SPAR WEB CRACKED AT RSS 224, COMMON TO UPPER CHORD. REPAIRED AFT SPAR IAW EA.SDR SWAA2016010747777Intercostal · crackedFORWARD GALLEY AREA, INTERCOSTAL CRACKED, BETWEEN BS 332 - 344, STRINGER 8R. REPAIRED TEE BRACKET IAW EA.SDR SWAA2016010747755Fitting · crackedLEFT FWD MLG BEAM FITTING CRACKED. REPAIRED FITTING IAW ER & EA.SDR SWAA2016010747746Stiffener · crackedLEFT WING REAR SPAR, STIFFENER CRACKED AT RSS 194.04. REPAIRED STIFFENER IAW EA.SDR SWAA2016010747758Angle · crackedRIGHT WING UPPER SKIN HOLE AT REAR SPAR, CRACKED AT APPROX RSS 249, AFT ROW. R & R ANGLE IAW SRM & ACO.SDR SWAA2016010747757Fitting · crackedRIGHT WING AFT MLG BEAM, FITTING CRACKED. REPAIRED FITTING IAW ER & EA.SDR SWAA2016010747756Fitting · crackedLEFT AFT MLG BEAM, FITTING CRACKED. REPAIRED FITTING IAW ER & EA.SDR SWAA2016010447638Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 420, BETWEEN STRINGER 23R & 24R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2015121547152Tab · delaminatedLEFT WING AILERON TAB DELAMINATED AT INBD CORNER ON TE. REPAIRED TAB IAW WO.SDR SWAA2015120746775Attach Angle · crackedVERTICAL ATTACH ANGLE CRACKED AT BS 328, LBL 46. REPAIRED ANGLE IAW SRM & DWG.SDR SWAA2016012848436Skin · corrodedEXTERIOR SKIN CORRODED, BETWEEN BS 727D - 727E, BL 0. R & R SKIN IAW ER & EA.SDR SWAA2016011247913Spar · crackedRIGHT WING NR 5 HOLE ONLY IN REAR SPAR AT RSS 222, CRACKED IN CHORD. REPAIRED CHORD IAW EA.SDR SWAA2016011247912Spar · crackedLEFT WING REAR SPAR RSS 222, CRACKED CHORD. REPAIRED CHORD IAW EA.SDR SWAA2016010747783Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986.50, BL 0. REPAIRED FLOORBEAM IAW EA.SDR SWAA2016010647678Angle · crackedFORWARD OF L1 DOOR UPPER HINGE CUT OUT INTERCOSTAL LT ANGLE CRACKED, BETWEEN BS 303 - 294.5, STRINGER 9L. R & R LT ANGLE IAW SRM & DWG.SDR SWAA2015123147549Spar · crackedRIGHT WING UPPER REAR SPAR, CHORD CRACKED AT RSS 224.14. REPAIRED SPAR IAW EA.SDR SWAA2015121146979Beam · corrodedFLOORBEAM STUB BEAM STRAP CORRODED AT BS 967, RBL 5. REPAIRED STUB BEAM IAW SRM.SDR SWAA2015120346669Lanyard · looseLEFT EMER HATCH DOOR ESCAPE LANYARD LOOSE. SECURED LANYARD IAW AMM.SDR SWAA2015113046518Battery · dischargedL1 DOOR EMER FLASHLIGHT INOPERATIVE. R & R BATTERY IAW AMM.SDR SWAA2015113046513Battery Pack · dischargedRIGHT EMER LIGHT INOPERATIVE AT ROW 1. R & R BATTERY PACK IAW AMM.SDR SWAA2016011948112Attach Angle · crackedLEFT WING OTBD FIXED TE, UPPER SURFACE PANEL ATTACH ANGLE CRACKED. R & R ANGLE IAW DWG.SDR SWAA2016010747754Attach Fitting · crackedRIGHT WING NR 6 FLAP TRACK FAIRING, TAIL CONE ATTACH FITTING CRACKED AT OTBD END. R & R FITTING IAW SRM & DWG.SDR SWAA2015123047503Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 986 - 948. REPAIRED BEAM IAW SRM.SDR SWAA2015123047502Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 291 - 328. REPAIRED BEAM IAW SRM.SDR SWAA2015121647197Glowstrip · brokenAFT CABIN PHOTO LUMINESCENT FLOOR PROXIMITY LIGHTING STRIP BROKEN. R & R STRIP IAW AMM.SDR SWAA2015121647196Bracket · crackedLEFT WING BRACKET, COMMON TO UPPER SPAR CHORD, CRACKED AT RSS 235. R & R CHORD IAW DWG & EA.SDR SWAA2015113046579Battery Pack · dischargedRIGHT BULLNOSE EMER LIGHTS INOPERATIVE, BETWEEN BS 650 - 727B. R & R BATTERY PACK IAW AMM.SDR SWAA2016010447631Panel · crackedFUSELAGE KEEL BEAM STRESS PANEL CRACKED AT STATION 699, RBL 6. REPAIRED PANEL IAW SRM.SDR SWAA2015123047501Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 420 - 440. REPAIRED BEAM IAW SRM.SDR SWAA2015121547151Crease Beam · corrodedFLOOR STRUCTURE CREASE BEAM WEB CORRODED AT BETWEEN BS 827 - 847, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2015121447076Crease Beam · corrodedFLOOR STRUCTURE CREASE BEAM WEB CORRODED, BETWEEN BS 887 - 907, STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2015120846857Frame · corrodedFORWARD CARGO PIT FRAME, CORRODED AT 500A, BETWEEN STRINGER 27R - 28R. REPAIRED FRAME IAW SRM.SDR SWAA2015120746774Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED, BETWEEN BS 867 - 847, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015121147020Stringer · crackedSTRINGER CRACKED, BETWEEN BS 500 - 500B, STRINGER 8L. REPAIRED STRINGER IAW SRM.SDR SWAA2015113046492Slat · delaminatedLEFT WING NR 3 SLAT DELAMINATED AT AFT INBD CORNER. R & R NR 3 SLAT IAW MM.SDR SWAA2015121547147Attach Fitting · crackedINTERCOSTAL ATTACH CLIP CRACKED AT BS 291, STRINGER 8R. R & R CLIP IAW SRM.SDR SWAA2015121447068Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 277, STRINGER 10R. REPAIRED CLIP IAW ER & EA.SDR SWAA2015121147019Stringer · crackedSTRINGER CRACKED AT BS 500B, STRINGER 8R. REPAIRED STRINGER IAW SRM.SDR SWAA2015120746767Lens · brokenFORWARD LAVATORY EMER EXIT LIGHT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2015112546468Switch · dirtyAFTER EXTENDING LG, 3 RED & 3 GREEN LG LIGHT ILLUMINATED. RAN CHECKLIST AFTER SECOND GEAR EXTENSION, ONLY 3 GREEN LIGHT ILLUMINATED. CLEANED LG LEVER SWITCH IAW AMM.SDR SWAA2016010847804Gusset · crackedMAIN CABIN PRESS DECK GUSSET CRACKED, BETWEEN BS 540 - 549, LBL 57. R & R GUSSET IAW SRM & DWG.SDR SWAA2015122347371Support Channel · corrodedNUMBER 3 VHF LOWER ANTENNA SUPPORT U-CHANNEL CORRODED AT STATION 727D+7, LBL 2. R & R CHANNEL IAW EA.SDR SWAA2015122247319Frame · crackedFUSELAGE FRAME CRACKED AT STATION 360, STRINGER 20R. REPAIRED FRAME IAW EA.SDR SWAA2015121547146Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 5R. R & R SPLICE IAW ER & EA.SDR SWAA2015121447067Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360+2, STRINGER 4R. R & R SPLICE IAW ER & EA.SDR SWAA2015121146969Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 907, STRINGER 10R. R & R CLIP IAW SRM.
Back to Boeing 737-3H4