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 2012FA0000518Skin · dentedFUSELAGE SKIN DENTED AT BS 1898.45 ON UPPER LEFT SURFACE. REPAIRED IAW SRM 53-00-01 FIG 201.SDR USAA2012073000011Skin · crackedC3 CHECK - CRACK IN FUSELAGE SKIN AT BS 947, S24L. REPAIRED FUSELAGE SKIN BETWEEN BS 927 TO BS 947 & BETWEEN S23L TO S27L IAW EA 140390.SDR Q2SA2012072875813Skin · failedDURING POST-FLIGHT, FOUND A HOLE AND CRACK DAMGE AT SECTION 48 LH SIDE BETWEEN STATION 2638 AND 2658 AND S-11L AND S-13L. STRINGER (P/N 65B 02976-1) CHORD (P/N 65B02515-113) AND ANGLE (P/N 65B02712-139) ASSEMBLIES WERE FOUND TO BE DAMAGED BEYOND ALLOWABLE LIMISDR AALA20120728010Skin · crackedFUSELAGE SKIN CRACKED AT STATION 1309 ABOVE LONGERON 7 LEFT. INSTALLED DOUBLER PER SRM 53-04-03 FIGURE 3.SDR AALA20120728009Skin · damagedDENT WITH GOUGE AT STATION 390 BETWEEN LONGERONS 26 AND 27 LEFT. INSTALLED INTERNAL DOUBLER PER SRM 53-04-02 FIGURE 2.SDR KCSA201207281136Skin · damagedFUSELAGE SKIN DAMAGED AT STA 1620 STR 2L.SDR SWAA2012082006833Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006832Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006831Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006830Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006829Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 480+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006828Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012082006827Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012081706775Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081606729Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081606728Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR FDEA201207272715Skin · misrepairedAGING AIRCRAFT - EXISTING REPAIR AT RT FUSELAGE SKIN AT STA 1830 BETWEEN LONGERONS 37 AND 38 MISREPAIRED. REPAIRED IAW EA 1-5330-160992. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 115.SDR SWAA2012081506714Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081506713Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081306660Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR UALA2012073004100Skin · corrodedFUSELAGE SKIN CORRODED AT BS 1393, BETWEEN S29 - 30L, ACCOMPLISHED SKIN REPAIR BS 1393-1401 STR 28L AND 29R PER REO-G15092 REV A AND UA ECRA 5360-01214.SDR SWAA2012080806605Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080806604Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706552Skin · crackedFUSELAGE SKIN CRACKED AT FWD LEFT CORNER OF CONDITION AIR DOOR CUTOUT. REPAIRED SKIN IAW SRM.SDR SWAA2012080706551Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727C+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706550Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706549Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706548Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706547Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706546Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706545Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706543Skin · crackedFUSELAGE SKIN CRACKED AT BS 931, STR 25R. REMOVED AND REPLACED SKIN IAW SRM.SDR SWAA2012080706541Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706540Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706539Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706538Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706537Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727E+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706536Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727A+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706535Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706534Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706533Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706532Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706531Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706530Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706529Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706528Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 747+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706527Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727E+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706526Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706525Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080706524Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727D+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.
Back to JASC 5330