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 SWAA2012031902357Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012031402178Skin · crackedLT BS 807+10 UPPER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2012031402177Skin · crackedLT BS 767+10 LOWER FORWARD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR DALA1209310925Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN STA Y=1103-1110 LONGERON 28RT REF MD88 SRM 53-04D FIG 53 FOR REPAIR. CORROSION WAS REMOVED AND ARE WITHIN LIMITS PER SRM53-04D.SDR DALA1209300925Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING STA Y=1084-1089 ON L29L, Y=1124-1133 BTW LONGERON 23-26L, Y=1115 BTW LONGERON 20-21L AND Y=1105 BTW LONGERON 19-20L REF MD88 SRM 53-04D FIG 53 FOR REPAIR. FUSELAGE SKIN WAS SDR DALA1209320925Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN UNDER WING TO FUSELAGE FILLET FAIRING STA Y=1043 AND Y=1060-1068 BTW LONGERON 18-19LT REF MD88 SRM 53-04D FIG 53. FUSELAGE WAS BLENDED OUT AND WITHIN LIMITS REF MD88 SRM 53-0 4D PARA 57.SDR DALA1209290925Skin · corrodedDURING HMV CORROSION WAS FOUND ON FUSELAGE SKIN STA Y=998-1041 BETWEEN LONGERONS 18-17LT. REF MD88 SRM 53-04D FIG 53 FOR REPAIR. FUSELAGE SKIN WAS BLENDED OUT AND WITH LIMITS REF MD88 M 53-04D PARA 57.SDR UALA2012022001017Fastener · faultyFUSELAGE CROWN STA 218.9 LBL 12.5 & STA 233.9 LBL 14.4 HAS 1 EACH BLIND FASTENER INSTALLED IN EACH LOCATION. BLIND FASTENERS REMOVED AND REPLACED WITH BLIND FASTENERS DUE TO NO ACCESS PER REO(EVA) G11456 AND UA-EVA-60126. CUT ACCESS HOLES IN DRIPSHIELD & INSSDR SWAA2012022201632Skin · crackedSKIN CRACKED AT BS 908 +2 TO 7, STR 4L. REPAIRED SKIN PER EA AND SRM.SDR SWAA2012022201631Skin · crackedSKIN CRACKED AT BS 360-13, STR 2L. REPAIRED SKIN IAW SRM.SDR SWAA2012022201630Skin · crackedSKIN CRACKED AT BS 360-18, STR 2L. REPAIRED SKIN IAW SRM.SDR SWAA2012022101604Skin · crackedFUSELAGE SKIN CRACKED AT BS 582, STR 10R. REPAIRED SKIN PER EA.SDR DALA1217930919Skin · damagedLIGHTNING STRIKE ON LT WINDOW BELT FRAME SKIN AT AFT LWR EDGE STA Y=518 AT FUSELAGE SKIN. BLENDOUT REWORK ACCOMPLISHED IAW ERA 501075-14 REV ORIG.SDR DALA1217910919Skin · damagedLIGHTNING STRIKES ON WINDOW BELT FRAME SKIN AT LWR AFT CORNER EDGE STA Y=479,888,742-745. LIGHTNING STRIKE TO WINDOW BELT STA 421, 479, 888, 742-745 BLENDOUT REWORK ACCOMPLISHED IAW ERA 501075-14 REV ORIG.SDR SWAA2012031902369Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500B+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO.SDR SWAA2012031902356Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012031902355Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012031902354Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012031902353Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012031902352Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012031902351Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012031902350Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012031902349Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012031902348Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012031902347Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012031902346Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012031902345Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500A+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA & REO.SDR SWAA2012031902344Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 480+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012031902343Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 380+10 FORWARD UPPER WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA & REO.SDR SWAA2012031902342Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 360+10 FORWARD UPPER WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA & REO.SDR SWAA2012031902341Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA & REO.SDR SWAA2012031902340Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA & REO.SDR SWAA2012031902339Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA & REO.SDR SWAA2012031902338Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB & EA.SDR SWAA2012031902337Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA & REO.SDR SWAA2012031902336Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB & EA.SDR SWAA2012031902335Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB & EA.SDR SWAA2012031902334Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012031902333Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB & EA.SDR SWAA2012031902332Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 500B+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012031902331Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012031902330Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 480+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012031902324Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012031902323Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 440+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012031902322Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012031902321Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012031902320Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD CORNER WINDOW CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012031602238Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FWD WINDOW CORNER. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012031602237Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 450+10 UPPER FWD WINDOW CORNER. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012031602236Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER. REPAIRED SKIN IAW REO AND EA.
Back to JASC 5330