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 SWAA2013062517527Web · crackedWEB CRACKED BETWEEN BS 178 - BS 188, RBL 30. R&R WEB IAW SRM & DRAWING.SDR SWAA2013060316675Lug · brokenLEFT WING INBD GROUND SPOILER CENTER INBD LUG BROKEN. R & R SPOILER IAW AMM.SDR SWAA2013070117797Seat Track · corrodedSEAT TRACK CORRODED BETWEEN BS 344 TO BS 480, LBL 25. R&R SEAT TRACK PER SRM.SDR SWAA2013062817740Crease Beam · crackedCREASE BEAM WEB CRACKED AT BS 638, LBL 65. R&R WEB IAW SRM.SDR SWAA2013061817313Attach Bracket · crackedSTUB BEAM ATTACH BRACKET CRACKED AT BS 638, LBL 45. R&R BRACKET IAW SRM.SDR SWAA2013061217120Pressure Deck · crackedMLG BAY UPPER PRESSURE DECK CRACKED AT BS 672, LBL 31. REPAIRED WEB IAW SRM.SDR SWAA0110060117027Attach Bracket · crackedLONGITUDINAL FLOOR STUB BEAM ATTACH BRACKET CRACKED AT BS 638, RBL 45. R & R BRACKET IAW SRM & DWG.SDR SWAA2013070117796Skin · crackedFWD GALLEY DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED CUTOUT IAW SRM.SDR SWAA2013070117795Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 460 TO BS 480, STR 17R. R&R WEB IAW SRM.SDR SWAA2013070117794Sill · corrodedR2 DOOR CUT OUT SILL WEB CORRODED BETWEEN BS 947 TO BS 986, RBL 50. R&R WEB IAW SRM AND DWG.SDR SWAA2013062817739Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 727B - BS 727C, STRINGER 17L. R&R WEB IAW SRM & DRAWING.SDR SWAA2013062617628Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 767 - 787, STRINGER 17L. R& R WEB IAW SRM & DRAWING.SDR SWAA2013062517519Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 360, STRINGER 8R. R&R CLIP IAW SRM.SDR SWAA2013062517548Sill · corrodedR1 DOOR CUTOUT SILL WEB CORRODED BETWEEN BS 986 - BS 993, RBL 50. R&R SILL WEB IAW SRM.SDR SWAA2013062517520Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 907, STRINGER 8L. R&R CLIP IAW SRM.SDR SWAA2013061917415Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 887 TO BS 907, STR 17L. R & R WEB IAW SRM.SDR SWAA2013061917414Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 847 TO BS 867, STR 17L. R & R WEB IAW SRM.SDR SWAA2013061917413Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 727D TO BS 727E, STR 17L. R & R WEB IAW SRM.SDR SWAA2013061917412Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 727C TO BS 727D, STR 17L. R & R WEB IAW SRM.SDR SWAA2013061917411Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 727A TO BS 727B, STR 17L. REPAIRED WEB IAW SRM.SDR SWAA2013061917410Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 360 TO 380, STR 17R. REPAIRED WEB IAW SRM.SDR SWAA2013061917409Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907, STR 4L. R & R SPLICE IAW SRM AND DWG.SDR SWAA2013061917408Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 727A, STR 4L. R & R CLIP IAW SRM.SDR SWAA2013061917407Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 616, STR 5R. R & R CLIP IAW SRM.SDR SWAA2013061917406Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 578, STR 11L. R & R CLIP IAW SRM.SDR SWAA2013061917405Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STR 8L. R & R CLIP IAW SRM.SDR SWAA2013061817312Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 747 TO 767, STR 17L. R&R WEB PER SRM.SDR SWAA2013061817311Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 460 TO BS 480, STR 17R. R&R WEB PER SRM.SDR SWAA2013061017013Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 639, STR 4R. R & R CLIP IAW DWG AND SRM.SDR SWAA2013060316676Spoiler · crackedRIGHT WING INBD GROUND SPOILER NR 5 INBD CRACKED. R & R SPOILER IAW MM.SDR SWAA2013070818001Bottle · low pressureL2 DOOR EMERGENCY EVAC SLIDE BOTTLE PRESSURE LOW. R&R SLIDE IAW AMM.SDR SWAA2013070818000Intercostal · corrodedINTERCOSTAL CORRODED BETWEEN BS 196.3 - BS 203.8, RBL 6. R&R INTERCOSTAL IAW EA & EO.SDR SWAA2013070517949Skin · delaminatedRT WING NR 5 SLAT DELAMINATED ON UPPER SURFACE AT INBD EDGE. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2013070117785Slat · crackedLT WING NR 1 SLAT LEADING EDGE CRACKED. REPAIRED NR 1 SLAT IAW SRM.SDR SWAA2013070117793Support Bracket · corrodedL1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR ATTACH SUPPORT BRACKET CORRODED. REMOVED & REPLACED BRACKET PER SRM.SDR SWAA2013062817738Strap · crackedFLOOR BEAM TENSION STRAP CRACKED AT BS 328, LBL 11. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013062817737Support Angle · crackedRT WING UPPER T/E SUPPORT ANGLE CRACKED. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013062817736Floorbeam · corrodedFLOOR BEAM UPPER FLANGE CORRODED AT BS 986.5, BETWEEN LBL 40 - RBL 45. REPAIRED FLOOR BEAM IAW ER & EA.SDR SWAA2013062817730Slat · crackedLT WING NR 1 SLAT LEADING EDGE CRACKED. REPAIRED NR 1 SLAT IAW SRM.SDR SWAA2013062817729Slat · crackedLT WING NR 2 SLAT LEADING EDGE CRACKED. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2013062817728Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17L. REPAIRED FRAME IAW SRM.SDR SWAA2013062717671Skin · delaminatedRT WING I/B FORE FLAP UPPER SURFACE DELAMINATED 36-INCH I/B OF O/B END. REPAIRED FORE FLAP IAW ATS J/N 46300.SDR SWAA2013062717669Frame · corrodedFRAME CORRODED AT BS 993, BETWEEN STRINGER 16R - STRINGER 17R. REPAIRED FRAME IAW ER & EA.SDR SWAA2013062617627Support Bracket · corrodedL1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR ATTACH SUPPORT BRACKET CORRODED. R&R BRACKET IAW SRM.SDR SWAA2013062617626Channel · corrodedFWD ENTRY DOOR THRESHOLD SUPPORT Z CHANNEL CORRODED AT BS 332, LBL 63. R&R ZEE CHORD IAW SRM & DRAWING. .SDR SWAA2013062617625Support Angle · crackedRT WING AILERON I/B CENTER HINGE FITTING I/B SUPPORT ANGLE CRACKED. R&R ANGLE IAW SRM.SDR SWAA2013062517598Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17R. REPAIRED FRAME IAW SRM.SDR SWAA2013062517518Attach Angle · crackedFWD OF R1 DOOR CUTOUT INTERCOSTAL OUTBOARD ATTACH ANGLE CRACKED AT BS 291, WL 240. R&R ANGLE IAW SRM.SDR SWAA2013062517517Support Angle · crackedRT WING RSS545 WIPER WEB SUPPORT ANGLE CRACKED. R&R ANGLE IAW SRM.SDR SWAA2013062517516Support Angle · crackedLT WING I/B SIDE, UPPER AFT T/E PANEL SUPPORT ANGLE CRACKED. R&R ANGLE IAW SRM & DRAWING.
Back to Boeing 737-3H4