Boeing 737-4Q8
Service difficulty reports · 6,250
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 = '7374Q8' 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 = '7374Q8' 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 ASAA0640629Skin · damagedFOUND SCRIBE MARKS ON SKIN. BLENDED AND TREATED PER EA 5330 02097.SDR ASAA0640628Skin · corrodedFOUND CORROSION ON SKIN. BLENDED AND INSTALLED DOUBLER PER EA 5330 02097.SDR ASAA0640627Skin · damagedFOUND FUSELAGE SKIN HAS SCRIBE MARKS AT WING TO BODY FARINGS. BLENDED AND INSTALLED DOUBLER PER EA 5330 02097.SDR ASAA0640626Tee Fitting · corrodedFOUND T CHORD CORRODED. REMOVED AND REPLACED PER SRM 51 40 02 AND 51 70 12.SDR ASAA0640625Floorbeam · gougedFOUND FLOORBEAM GOUGED. REPAIRED FLOORBEAM PER EA 5310 02628.SDR ASAA0640623Frame · gougedFOUND GOUGE IN FRAME. BLENDED OUT DAMAGE AND INSTALLED REPAIR STRAP IAW EA 5310 02630.SDR ASAA0640622Frame · crackedFOUND FRAME CRACKED. REPAIRED BY CUTTING OUT DAMAGED AREA AND INSTALLING DOUBLER IAW EA 5310 02627.SDR ASAA0640621Frame · crackedFOUND CRACKED FRAME. REMOVED EXISTING REPAIR TRIMMED OUT CRACK AND INSTALLED NEW REPAIR IAW EA 5310 02626.SDR ASAA0640620Floorbeam · gougedFOUND FLOORBEAM GOUGED. REPAIRED FLOORBEAM IAW EA 531 02628.SDR ASAA0640619Floorbeam · gougedFOUND FLOORBEAM GOUGED. REPAIRED FLOORBEAM PER EA 5310 02628.SDR ASAA0640617Rib · crackedFOUND LEFT WING RIB CRACKED. REPAIRED WING RIB PER EA 5310 02629 AND ER06 1899.SDR ASAA0640615Shear Tie · corrodedFOUND CORRODED SHEAR TIE. FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE PER SRM 51 40 02.SDR ASAA0640616Shear Tie · corrodedFOUND CORRODED SHEAR TIE. CUTOUT DAMAGE AND REPAIRED PER SRM 53 00 07.SDR ASAA0640604Stop Fitting · damagedFOUND MECHANICAL DAMAGE ON DOOR STOP FITTING. REPLACED STOP FITTING PER SRM 51 40 02.SDR ASAA0640603Sill · corrodedFOUND CORROSION ON MOPSILL. INSTALLED NEW MOPSILL PER SRM 53 60 15.SDR ASAA0640602Frame · damagedFOUND OVERSIZED FLOOR TO SIDEWALL SUPPORT PLATE ATTACH HOLE. REPAIRED DAMAGED FLOOR TO SIDEWALL SUPPORT ATTACH HOLE ON FRAME.SDR ASAA0640599Frame · corrodedFOUND CORROSION ON FRAME. CORRODED OUT OF LIMITS REMOVED FABRICATED AND INSTALLED FRAME CAP PER SRM 53 00 07.SDR ASAA0640598Frame · corrodedFOUND CORROSION ON FRAME. CUT OUT DAMAGE AND INSTALLED REPAIR PER SRM 53 60 07.SDR ASAA0640597Frame · corrodedFOUND CORROSION ON FRAME. CUT OUT DAMAGED AREA AND INSTALLED REPAIR PER SRM 51 70 11.SDR ASAA0640601Sill · corrodedFOUND CORROSION ON MOPSILL CORROSION ON MOPSILL FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED MOPSILL PER SRM 53 10 15.SDR ASAA0640600Shear Tie · corrodedFOUND CORRODED SHEAR TIE. REMOVED CORRODED SHEAR TIE OUT OF LIMITS. REPLACED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640595Shear Tie · corrodedFOUND CORRODED SHEAR TIE. CUT OUT DAMAGE AND INSTALLED REPAIR PER SRM 53 00 07.SDR ASAA0640594Shear Tie · corrodedFOUND CORROSION ON ACB SHEAR TIE. REMOVED AND REPLACED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640592Shear Tie · corrodedFOUND SHEAR TIE CORRODED. FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE PER SRM 53 00 07.SDR ASAA0640591Shear Tie · corrodedFOUND SHEAR TIE CORRODED. FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE PER SRM 53 00 07.SDR ASAA0640590Frame · corrodedFOUND CORROSION ON FRAME. INSTALLED REPAIR DOUBLER PER SRM 51 70 11.SDR ASAA0640578Frame · corrodedFOUND AFT CARGO FRAME HAS CORROSION. FABRICATED AND INSTALLED REPLACEMENT FRAME PER SRM 51 40 02.SDR ASAA0640583Stringer Clip · crackedFOUND STRINGER CLIP CRACKED. REPLACED STRINGER CLIP PER SRM 51 40 02.SDR ASAA0640582Stringer Clip · crackedFOUND STRINGER CLIP CRACKED. REPLACED STRINGER CLIP PER SRM 51 40 02.SDR ASAA0640581Shear Tie · corrodedFOUND SHEAR TIE CORRODED. FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE PER SRM 53 00 07.SDR ASAA0640580Shear Tie · corrodedFOUND SHEAR TIE CORRODED. FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE PER SRM 53 00 07.SDR ASAA0640579Shear Tie · corrodedFOUND CORRODED SHEAR TIE. CUT OUT AND REPAIRED PER SRM 53 00 07.SDR ASAA0640577Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED CORROSION ON SHEAR TIE OUT OF LIMITS AND REPAIRED PER SRM 53 00 07 REPAIR 10.SDR ASAA0640576Shear Tie · corrodedFOUND CORROSION ON FRAME SHEAR TIE. REMOVED AND REPLACED FRAME SHEAR TIE PER SRM 53 00 07.SDR ASAA0640575Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED AND REPLACED FRAME.SDR ASAA0640574Frame · gougedFOUND DEEP GOUGE ON RADIUS OF FRAME. REMOVED AND REPLACED FRAME PER SRM 51 40 02.SDR ASAA0640573Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640572Shear Tie · corrodedFOUND CORROSION ON AFT CARGO BAY SHEAR TIE. REPAIRED PER SRM 53 00 07.SDR ASAA0640571Shear Tie · corrodedFOUND CORROSION SHEAR TIE. CUTOUT AND REPAIRED PER SRM 53 00 07.SDR ASAA0640570Shear Tie · corrodedFOUND CORRODED SHEAR TIE. CUTOUT AND REPAIRED PER SRM 53 00 07.SDR ASAA0640569Shear Tie · corrodedFOUND CORRODED SHEAR TIE. CUTOUT AND REPAIRED PER SRM 53 00 07.SDR ASAA0640568Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE OUT OF LIMITS. CUT OUT DAMAGED INSTALLED REPAIR PER SRM 53 00 07.SDR ASAA0640567Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. CUT OUT CORROSION AND REPAIRED SHEAR TIE PER SRM 53 00 07.SDR ASAA0640560Shear Tie · crackedFOUND CRACKED SHEAR TIE. CUT OUT DAMAGED SHEAR TIE AND REPLACED WITH NEW SHEAR TIE PER SRM 53 00 07.SDR ASAA0640559Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. FABRICATED AND INSTALLED REPLACEMENT STRINGER TIE PER SRM 51 40 02.SDR ASAA0640558Stringer Clip · crackedFOUND STRINGER CLIP CRACKED. REMOVED AND REPLACED STRINGER CLIP PER SRM 51 40 02.SDR ASAA0640557Strap · corrodedAFT CARGO THRESHOLD IB UPPER STRAP CORRODED. REMOVED AND REPLACED STRAP PER SRM 51 40 02.SDR ASAA0640555Shear Tie · crackedFOUND CRACKED SHEAR TIE. CUTOUT SHEAR TIE AND REPLACED PER SRM 53 00 07.SDR ASAA0640554Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED AND REPLACED SHEAR TIE PER SRM 53 00 07 51 40 02 51 21 19.SDR ASAA0640556Web · corrodedFOUND AFT CARGO THRESHOLD WEB CORRODED. INSTALLED NEW THRESHOLD WEB PER SRM 53 60 15.
Back to Boeing 737-4Q8