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 SWAA2015081442850Skin · crackedFORWARD ENTRY DOOR, UPPER HINGE CUT OUT CRACKED AT BS 304, STRINGER 10L. REPAIRED CUT OUT IAW EA.SDR SWAA2015081142646Skin · delaminatedLEFT WING INBD FLAP, FORE FLAP TOP SURFACE DELAMINATED APPROX 36" INBD OF OTBD EDGE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015080442498Skin · crackedR1 DOOR JUST FORWARD OF LOWER DOOR HINGE CUT OUT CRACKED. REPAIRED CUT OUT IAW SRM.SDR SWAA2015080342458Frame · corrodedAFT GALLEY AREA FRAME INBOARD FLANGE CORRODED AT BS 1008, RBL 43. R & R FLANGE IAW SRM.SDR SWAA2015073142382Flap · delaminatedRIGHT WING INBOARD AFT FLAP DELAMINATED TRAILING EDGE. R & R AFT FLAP IAW AMM.SDR SWAA2015073142381Angle · crackedLEFT WING INBOARD FLAP, OUTBOARD TRACK, INBOARD CUT OUT LOWER ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2015073042350Lens · missingR1 DOOR EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS IAW MM.SDR SWAA2015081242777Angle · corrodedAFT CARGO PIT VERTICAL ANGLE CORRODED AT BS 794, RBL 7. R & R ANGLE IAW SRM.SDR SWAA2015080642587Intercostal · crackedINTERCOSTAL WEB CRACKED AT BS 348, STRINGER 16L. R & R WEB IAW SRM.SDR SWAA2015080642570Strap · crackedINTERCOSTAL STRAP CRACKED AT BS 348, STRINGER 16L. R & R STRAP IAW SRM.SDR SWAA2015080442501Fairing · crackedLEFT WING NR 2 FLAP TRACK, AFT CANOE FAIRING, AFT TAIL CONE CRACKED AT FASTENER HOLE. REPAIRED FAIRING IAW SRM.SDR SWAA2015080442492Panel · crackedRIGHT NOSE WHEEL WELL PANEL AT BS 239, JUST BELOW PANEL 3103R CRACKED. REPAIRED WEB IAW SRM.SDR SWAA2015080342456Bracket · crackedLEFT WING NR 1 FLAP TRACK BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2015073042326Lens · looseRIGHT SIDEWALL EXIT LIGHT LENS LOOSE. R & R LENS IAW MM.SDR SWAA2015072942285Skin · delaminatedRIGHT WING INBOARD AFT FLAP DELAMINATED ON TRAILING EDGE. R & R AFT FLAP IAW MM.SDR SWAA2015082143053Support Angle · crackedRIGHT WING SUPPORT ANGLE CRACKED ON TE INTERNAL AREA OTBD SIDE AT RSS 533+12. R & R ANGLE IAW SRM & DWG.SDR SWAA2015081342793Skin · crackedFUSELAGE SKIN CRACKED AT BS 908+1.5, STRINGER 4L. REPAIRED SKIN IAW EA.SDR SWAA2015081242770Angle · crackedELECTRONIC EQUIPMENT COMPARTMENT ANGLE CRACKED AT BS 320, WL 181.37. R & R ANGLE IAW SRM & DWG.SDR SWAA2015081142643Keelbeam · corrodedKEEL BEAM CORRODED AT BS 500D, LBL 6.5. R & R KEEL BEAM IAW SRM.SDR SWAA2015073042335Flap · delaminatedLEFT WING OUTBOARD FORE FLAP OUTBOARD END EDGE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2015073042333Wire · brokenAFT CABIN EXIT LOCATOR SIGN WIRE BROKEN AT BS 908. REPAIRED WIRE IAW AMM.SDR SWAA2015072942276Charger · inoperativeL2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R CHARGER IAW MM.SDR SWAA2015091043648Spar · crackedRIGHT WING REAR SPAR UPPER CHORD, CRACKED AT RSS 225.0. REPAIRED CHORD IAW EA.SDR SWAA2015091043644Support Fitting · crackedLEFT WING REAR SPAR AFT SUPPORT FITTING CRACKED AT RSS 222.5. REPAIRED FITTING IAW EA.SDR SWAA2015091043643Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 226. REPAIRED WEB IAW EA.SDR SWAA2015091043642Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 219.5. REPAIRED WEB IAW EA.SDR SWAA2015091043641Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 220.5. REPAIRED WEB IAW EA.SDR SWAA2015091043640Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT RSS 221.5. REPAIRED WEB IAW EA.SDR SWAA2015091043639Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT RSS 222.5. REPAIRED CHORD IAW EA.SDR SWAA2015091043637Spar · crackedRIGHT WING REAR SPAR WEB UPPER CHORD CRACKED AT RSS 225.0. REPAIRED CHORD IAW EA.SDR SWAA2015091043636Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT RSS 223.0. REPAIRED CHORD IAW EA.SDR SWAA2015091043635Spar · crackedRIGHT WING REAR SPAR WEB CRACKED AT RSS 223. REPAIRED WEB IAW EA.SDR SWAA2015091043634Support Fitting · crackedRIGHT WING AFT SUPPORT FITTING CRACKED AT RSS 223.0. REPAIRED FITTING IAW EA.SDR SWAA2015090243451Support · crackedRIGHT WING NR 5 SPOILER, INBD ACTUATOR SUPPORT STRUCTURE CRACKED. R & R SUPPORT IAW SRM. R & R SUPPORT IAW SRM & DWG.SDR SWAA2015083143356Skin · crackedFUSELAGE SKIN CRACKED AT BS 362, STRINGER 6R. REPAIRED SKIN IAW EA.SDR SWAA2015082743248Skin · crackedSKIN CRACKED BETWEEN BS 500+15 TO 500+16.5, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2015082743247Skin · crackedSKIN CRACKED AT BS 435, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2015082643231Plate · crackedAFT CARGO COMPARTMENT FRAME PLATE CRACKED AT BS 792, BETWEEN STRINGER 24R - 25R. R & R FRAME PLATE IAW SRM & DWG.SDR SWAA2015082543194Skin · crackedSKIN CRACKED AT BS 435, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2015082443094Skin · crackedFUSELAGE CROWN SKIN CRACKED AT BS 500+15, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2015082042993Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 453 - 454.5, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2015082043014Support Angle · crackedAFT CARGO COMPARTMENT SUPPORT ANGLE CRACKED AT BS 947.5, STRINGER 25L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015081842932Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24 IN FLANGE ATTACH HOLES. REPAIRED FLANGE IAW EA.SDR SWAA2015081842931Seat Track · crackedFLOORBEAM SEAT TRACK CRACKED CHORD AT BS 727B, RBL 24. REPAIRED CHORD IAW EA.SDR SWAA2015081742866Skin · crackedFUSELAGE EXTERIOR SKIN CRACKED AT BS 500+5, STRINGER 15L. REPAIRED SKIN IAW EA.SDR SWAA2015081242776Skin · crackedAFT GALLEY DOOR CUT OUT FWD LOWER CORNER CRACKED EXTENDING FROM FASTENER. REPAIRED CUT OUT IAW SRM.SDR SWAA2015081142743Stringer · crackedFORWARD CARGO STRINGER CRACKED BETWEEN BS 480 TO BS 500, STRINGER 27R. R & R STRINGER IAW EA.SDR SWAA2015080642593Mount · corrodedL1 DOOR SLIDE AFT GIRT BAR FITTING MOUNT TOP SURFACE CORRODED AT BS 344. R & R MOUNT IAW DWG.SDR SWAA2015080642586Crease Beam · corrodedCABIN CREASE BEAM WEB INNER CHORD CORRODED AROUND & UNDER NUTPLATES, JUST INBD OF AFT ENTRY DOORWAY THRESHOLD. R & R CREASE BEAM IAW DWG & SRM.SDR SWAA2015080642585Crease Beam · corrodedR2 DOOR CREASE BEAM WEB INNER CHORD CORRODED AT STRINGER 17R. R & R CREASE BEAM IAW DWG.
Back to Boeing 737-3H4