JASC 5330
Service difficulty reports · 79,365
Reports filed under 5330 · Fuselage Main, Plate/Skin, newest first.
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 jasc_code = '5330' 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 jasc_code = '5330' 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 SWAA2012100108143Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108142Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787 +10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108141Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108140Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108139Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108138Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 440 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108137Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108136Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108135Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108132Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108131Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108130Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 420 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012100108129Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108127Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012100108126Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360 +10 LOWER AFT WINDOW CORNER CUTOUT. EPAIRED SKIN IAW EA.SDR SWAA2012100108125Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR UALA2012090605011Skin · corrodedEXTERIOR FUSELAGE SKIN CORROSION AT STA 1564 DRAIN PLUG AREA. MAJOR REPAIR ACCOMPLISHED: MAINT TEXT: CUT OUT DAMAGED SKIN AND FABRICATED A REPAIR DOUBLER-TRIPLER, FILLER, AND REPLACED SHEAR TIE AND INSTALLED PER REO G15296, REV D AND UA EC-RA 5360-01221.SDR SWAA2012092608023Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608022Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608021Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608020Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092608019Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608018Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608017Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807 +10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608016Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 480 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608015Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 420 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608014Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608013Skin · crackedLEFT FUSELAGE SKIN CRACKED BS 500C +10 UPPER FORWARD WINDOW CORNER CTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608012Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500B +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608011Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500A +10 UPPER FORWARD WINDOW CORNER CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2012092608010Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608009Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608008Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608007Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608006Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012092608005Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608004Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 440 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC SB.SDR SWAA2012092608003Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012092608002Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380 +10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608001Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092608000Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092907942Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507952Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507951Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507950Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767 +10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507949Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507948Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460 +10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507947Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012092507946Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012092507945Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.
Back to JASC 5330