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 SWAA2016032850247Skin · crackedLEFT WING UPPER SKIN CRACKED AT TE, BETWEEN RSS 254 - 269. REPAIRED SKIN IAW ER & EA.SDR SWAA2016030849763Lens · missingL1 DOOR BULKHEAD EMER EXIT SIGN LENS MISSING. INSTALLED LENS IAW EA.SDR SWAA2016030849745Cover · missingFORWARD ENTRY EXIT COVER MISSING. INSTALLED COVER IAW SIP.SDR SWAA2016042651356Skin · crackedL1 DOOR UPPER HINGE AREA CUT OUT CRACKED AT BS 304.5, WL 256.6. REPAIRED CUT OUT IAW SRM.SDR SWAA2016042651355Skin · crackedL1 DOOR UPPER HINGE AREA CUT OUT CRACKED AT BS 304.7, WL 258.2. REPAIRED CUT OUT IAW EA.SDR SWAA2016042651344Skin · crackedL1 DOOR UPPER HINGE AREA CUT OUT CRACKED AT BS 304.3, WL 239.4. REPAIRED CUT OUT IAW SRM.SDR SWAA2016042651341Skin · crackedL1 DOOR LOWER HINGE CUT OUT CRACKED AT BS 304.3, WL 237. REPAIRED CUT OUT IAW EA.SDR SWAA2016042651340Skin · crackedL1 DOOR LOWER HINGE AREA CUT OUT CRACKED AT BS 304.5, WL 238.1. REPAIRED CUT OUT IAW EA.SDR SWAA2016040150509Shear Tie · corrodedAFT CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 807, BETWEEN STRINGER 27R - 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016040150506Structure · crackedRIGHT WING LOWER CHORD WEB FLANGE CRACKED AT RSS 216. REPAIRED CHORD IAW ER & EA.SDR SWAA2016033050438Failsafe · corrodedAFT CARGO FAILSAFE CHORD CORRODED AT BS 747, BETWEEN STRINGER 26R - 27R. R & R FAILSAFE CHORD IAW SRM & DWG.SDR SWAA2016032850253Shear Web · corrodedAFT GALLEY & LAVATORY SHEAR WEB CORRODED AT BS 1016, BETWEEN STRINGER 26R - 27R. R & R SHEAR WEB IAW SRM & DWG.SDR SWAA2016032150023Angle · corrodedAFT CARGO RT Z ANGLE SPLICE CORRODED AT BS 727D+3. REPAIRED Z ANGLE IAW SRM.SDR SWAA2016032150013Door Frame · crackedR1 DOOR AFT FRAME T CHORD AT DOOR STOP CRACKED AT FWD TRIM RADIUS. REPAIRED T CHORD IAW EA.SDR SWAA2016032150005Angle · corrodedAFT CARGO LT Z ANGLE SPLICE CORRODED AT BS 727D+4. R & R Z ANGLE IAW DWG & SRM.SDR SWAA2016031149810Angle · crackedLEFT WING TE ANGLE CRACKED ON WS 537.806. R & R ANGLE IAW SRM & DWG.SDR SWAA2016041951091Frame · corrodedAFT CARGO BAY FRAME ATTACH ANGLE CORRODED AT BS 727E, STRINGER 27R. R & R FRAME IAW SRM & DWG.SDR SWAA2016041851062Shear Tie · corrodedAFT CARGO SHEAR TIE CORRODED AT BS 747, BETWEEN STRINGER 26L - 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016041851061Shear Tie · corrodedAFT CARGO BAY SHEAR TIE CORRODED AT BS 727E, BETWEEN STRINGER 26R - 27R. R & R FRAME IAW SRM.SDR SWAA2016041851060Shear Tie · corrodedAFT CARGO BAY SHEAR TIE CORRODED AT BS 727E, BETWEEN STRINGER 26L - 27L. R & R FRAME IAW SRM.SDR SWAA2016041851031Shear Tie · corrodedAFT CARGO BAY SHEAR TIE CORRODED AT BS 787, BETWEEN STRINGER 26R - 27R. R & R FRAME IAW SRM.SDR SWAA2016041851030Shear Tie · corrodedAFT CARGO SHEAR TIE CORRODED AT BS 787, BETWEEN STRINGER 26L - 27L. R & R FRAME IAW SRM 5.SDR SWAA2016041851029Shear Tie · corrodedAFT CARGO CTR SHEAR TIE CORRODED AT BS 747, BETWEEN STRINGER 27R - 27L. REPAIRED FRAME IAW SRM.SDR SWAA2016041851028Shear Tie · corrodedAFT CARGO BAY SHEAR TIE CORRODED, AT BS 747, BETWEEN STRINGER 26R - 27R. R & R FRAME IAW SRM.SDR SWAA2016041851026Glowstrip · brokenAFT CABIN PHOTO LUMINESCENT FLOOR PROXIMITY LIGHTING STRIP BROKEN. R & R STRIP IAW AMM.SDR SWAA2016041550953Shear Tie · corrodedSHEAR TIE CORRODED AT BS 787, BETWEEN STRINGER 27L - 27R. R & R FRAME IAW SRM & DWG.SDR SWAA2016041450922Seat Track · crackedSEAT TRACK AT LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.50, AT CTR WING BOX. REPAIRED SEAT TRACK IAW EA.SDR SWAA2016031749963Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 500A, BETWEEN STRINGER 28R & 28L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016031549927Shear Tie · corrodedFUSELAGE SHEAR TIE CORRODED AT STATION 500C, BETWEEN STRINGER 28R & 28L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016031549926Shear Tie · corrodedFUSELAGE SHEAR TIE CORRODED AT STATION 500B, BETWEEN STRINGER 28R & 28L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2016031449846Attach Angle · crackedRIGHT WING OTBD VERTICAL ATTACH ANGLE, CRACKED AT 2ND OTBD AILERON SWEEPER WEB. R & R ANGLE IAW SRM.SDR SWAA2016031149821Crease Beam · crackedLEFT CREASE BEAM WEB CRACKED, BETWEEN BS 616 - 639. R & R WEB IAW DWG & SRM.SDR SWAA2016031149822Structure · crackedLEFT STUB BEAM UPPER CHORD CRACKED AT STATION 639, LBL 63.5. R & R CHORD IAW DWG & SRM.SDR SWAA2016042951414Link · corrodedLEFT MLG SWING LINK CORRODED. R & R SWING LINK IAW EA.SDR SWAA2016041450896Spar · crackedLEFT WING UPPER REAR SPAR CHORD CRACKED AT RSS 223. REPAIRED CHORD IAW EA & ER.SDR SWAA2016041350843Seat Track · crackedSEAT TRACK AT LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 24.50, AT CTR WING BOX. REPAIRED SEAT TRACK IAW EA.SDR SWAA2016041150738Spar · crackedLEFT WING UPPER REAR SPAR CHORD CRACKED AT RSS 223. REPAIRED CHORD IAW EA.SDR SWAA2016041150736Spar · crackedRIGHT WING UPPER REAR SPAR CHORD CRACKED AT RSS 223. REPAIRED CHORD IAW ER & EA.SDR SWAA2016040750676Drag Link · corrodedVERTICAL STABILIZER LT AFT OTBD MOUNTING POINT, AFT DRAG LINK FITTING CORRODED PIT ON BOTTOM SURFACE. R & R DRAG LINK ASSEMBLY IAW DWG.SDR SWAA2016040450569Spar · crackedRIGHT WING UPPER SPAR CHORD CRACKED AT RSS 223. REPAIRED CHORD IAW ER & EA.SDR SWAA2016033050427Stiffener · crackedMAIN WW COMPARTMENT STIFFENER CRACKED, AT BS 663.75, LBL 6.15, ON FWD BULKHEAD. R & R STIFFENER IAW ACO.SDR SWAA2016032850275Stiffener · crackedSTIFFENER CRACKED AT BS 663.75, RBL 6.15. R & R STIFFENER IAW AC.SDR SWAA2016032350156Frame · crackedFUSELAGE FRAME CRACKED AT STATION 328, STRINGER 20R - 21R. REPAIRED FRAME IAW ACO.SDR SWAA2016032150043Angle · crackedLONGITUDINAL FLOORBEAM SUPPORT BRACKET ANGLE CRACKED AT BS 727B, BBL 0. REPAIRED ANGLE IAW SRM.SDR SWAA2016032150007Link · corrodedLEFT WING SUPPORT BEAM SWING LINK ASSEMBLY CORRODED. R & R SWING LINK ASSEMBLY EA.SDR SWAA2016031649954Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 490, STRINGER 24R. R & R CLIP IAW SRM.SDR SWAA2016031149809Floor Support · crackedCENTER WING BOX LONGITUDINAL FLOORBEAM WEB CRACKED, AT BS 705, LBL 0.07. REPAIRED WEB IAW EA.SDR SWAA2016030749715Coupling · disconnectedAIR TURN BACK, DURING CLIMB & THEN DESCENT, VISIBLE FUEL STREAM EMANATING FROM WINGS, NOTICEABLE EXCESSIVE FUEL BURN. CONNECTED COUPLINGS IAW AMM.SDR SWAA2016030749667Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 360, STRINGER 8R. R & R ANGLE IAW ARM.SDR SWAA2016033150457Fitting · crackedFORWARD RT MLG FITTING CRACKED AT APPROX RSS 221, 3RD FASTENER HOLE DOWN. REPAIRED FITTING IAW ER & EA.
Back to Boeing 737-3H4