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 SWAA2013062017435Window Post · crackedTHE SECOND LOWER CORNER FASTENER HOLE ALONG THE E-F POST ON THE LEFT NR 3 FLIGHT DECK WINDOW FRAME CRACKED. REPAIRED POST IAW MOD-53EO-00840.SDR SWAA2013062017434Window Post · crackedTHE SECOND LOWER CORNER FASTENER HOLE ALONG THE E-F POST ON THE RT NR 3 FLIGHT DECK WINDOW FRAME CRACKED. REPAIRED POST IAW MOD-53EO-00845.SDR UALA2013060303855Skin · damagedCLASS "B" REPAIR INSTALLED FUS STA 1707 BETWEEN STR 22L & 23L. REPAIR INSTALLED IAW SRM 53-00-01, FIG 201 REP 3.SDR DALA13026995642Skin · damagedFUSELAGE SKIN DAMAGED. BS 600 - 615, S16-17L. REPAIRED IAW ERA 515520-14, REV ORIGINALSDR DALA13026986818Skin · corrodedCORROSION TO THE FUSELAGE BILGE SKIN, COMMON TO THE SERVICE LINE FEED THROUGH HOLES FOR THE MID LAV SERVICE PANEL. DAMAGE IS COMMON TO TWO (2) OF THREE (3) SERVICE LINE FEED HOLES LOCATED AS FOLLOWS: ONE (1) RT FWD HOLE AT STA 1202.25, RBL 2, BETWEEN S29 - 30SDR UALA2013060303829Skin · damagedSKIN DAMAGED BS 430, S15-16L. REPAIRED IAW SRM 53-00-01, TABLE 5. MAJOR REPAIR.SDR IPXA13M79158Skin · gougedINSPECTION TYPE: 2C, SKIN GOUGED BETWEEN BS 879 -1119 L26L. REPAIRED LT SIDE SKIN IAW EA 011-5330-01-A4713, REV IR AND EO MD11-5300-51324-A.SDR USAA2013061700042Skin · crackedQ4 CHECK -CRACK ON FUSELAGE SKIN AT BS1138, S12L. REPAIRED FUSELAGE SKIN AT BS1138, S12L IAW SRM 53-00-01-2R-22, FIG 201.SDR UALA2013060303828Skin · dentedEXTERNAL SKIN HAS A DENT AT BS 430, S15-16L. EVALUATED DENTS AND FOUND OUT OF LIMITS. REPAIRED IAW SRM 53-00-01, REPAIR 2, FIG 201. PERFORMED NDT INSP HOLE AND CUTOUT REF NTM 51- 00-19 AND 51-00-16. NO DEFECTS NOTED.SDR DALA1314390682Skin · dentedTWO PROTRUDING DENTS ON FUSELAGE BS 680-700 BETWEEN S24 - 25R. ACCOMPLISHED SRM REPAIR IAW SRM 53-00-01. REPAIR NR 3.SDR SWAA2013070117796Skin · crackedFWD GALLEY DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED CUTOUT IAW SRM.SDR UALA2013060303832Skin · dentedLOWER AFT SKIN DENTED BS 1707 BETWEEN S22-23L. INSTALLED REPAIR DOUBLER IAW SRM 53-00-10 FIG 201 REPAIR 3. MAJOR REPAIR.SDR UALA2013060303826Skin · damagedEXTERNAL SKIN HAS INDICATION OF LIGHTNING STRIKES AT BS 480, STR 25R. REPAIRED SKIN IAW SRM 53-00-01, FIG 201.SDR SWAA2013061016988Skin · crackedFUSELAGE SKIN CRACKED AT STA 218, LONG 7L. REPAIRED SKIN IAW SRM.SDR ABXA20130531454Skin · gougedFORWARD UPPER TCAS ANTENNA MOUNTING AREA HAS SCRATCHES AND GOUGES IN THE FUSELAGE. R & R DOUBLER IAW REA B653-60557-MR, ACFT WAS GROUNDED.SDR SWAA2013060616868Skin · crackedAFT CARGO PIT DOOR CUT OUT, AFT LOWER CORNER, FAIRING COMPOUND CRACKED. REPAIRED CUTOUT IAW AMM.SDR SWAA2013060316697Skin · crackedEXTERNAL POWER DOOR CUTOUT CRACKED. REPAIRED CUTOUT IAW ER AND EA.SDR FDEA201305311154Skin · misrepairedFUSELAGE SKIN BS 395-418 BETWEEN S2-4L MISREPAIRED. REPAIRED IAW EA F-5330-T0300578. MAJOR REPAIRSDR UALA2013053103802Skin · dentedSKIN BS 590 TO 600, S14-19L HAS MULTIPLE DENTS. INSTALLED NEW DOUBLER BARN DOOR REPAIR IAW ECRA 5330-04604. NR 37274. MAJOR REPAIR.SDR SWAA2013062417501Skin · crackedRT BS 887+10 UPPER AFT SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW EA.SDR UALA2013053103812Skin · damagedLIGHTNING STRIKE AT BS 211 EIGHT INCHES LEFT OF BL 0. REPAIRED SKIN IAW SRM 53-00-01, FIG 201.SDR UALA2013053103804Skin · damagedLIGHTNING STRIKE AT BS 208, 8.5" LEFT OF BL 0. REPAIRED SKIN IAW SRM 53-00-01, FIG 2, 01.SDR UALA2013053103803Skin · damagedLIGHTNING STRIKE AT BS 220 7.5" LT OF BL 0. REPAIRED SKIN IAW SRM 53-00-01, FIG 201.SDR SWAA2013061817285Skin · crackedLEFT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3, 4, 5. REPAIRED SKIN IAW EA.SDR SWAA2013061817286Skin · crackedLEFT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,6. REPAIRED SKIN IAW EA.SDR SWAA2013061217083Skin · corrodedFUSELAGE EXTERNAL SKIN CORRODED BETWEEN STA 851 TO 870, BETWEEN LONG 28L TO 30. REPAIRED SKIN IAW SRM.SDR SWAA2013061217077Skin · crackedRIGHT BS 887+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061217076Skin · crackedRIGHT BS 847+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061217075Skin · crackedRIGHT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013061217074Skin · crackedRIGHT BS 847+10 UPPER AFT WINDOW SKIN CUTOUT SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061217063Skin · corrodedLEFT AFT WING TO BODY LOWER SKIN SURFACE CORRODED AROUND NUTPLATE HOLES FS 851, LONG 28L. REPAIRED SKIN IAW SRM.SDR SWAA2013061016989Skin · corrodedLEFT AFT WING TO BODY LOWER SKIN CORRODED AROUND NUT PLATE HOLES AT FS 851, LONG 28L. REPAIRED DOUBLER IAW SRM.SDR SWAA2013061016968Skin · crackedRT BS 787+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016967Skin · crackedRIGHT BS 767+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016966Skin · crackedRIGHT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016965Skin · crackedRT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016958Skin · crackedLEFT BS 887+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3 AND NR 9. REPAIRED SKIN IAW SB.SDR SWAA2013061016957Skin · crackedLEFT BS 827+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013061016956Skin · crackedLT BS 787+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,6,7. REPAIRED SKIN IAW SB.SDR SWAA2013061016955Skin · crackedLEFT BS 767+10 LOWER FORWARD WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3. REPAIRED SKIN IAW SB.SDR SWAA2013061016954Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,9. REPAIRED SKIN IAW SB.SDR SWAA2013061016953Skin · crackedLT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1,2,3. REPAIRED SKIN IAW SB.SDR SWAA2013060716888Skin · crackedLEFT BS 847+10 LWR FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 3. REPAIRED SKIN IAW SB.SDR SWAA2013060716887Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 3, 5. REPAIRED SKIN IAW SB.SDR SWAA2013060416750Skin · corrodedFUSELAGE EXTERNAL SKIN CORRODED BETWEEN STA 851 TO STA 870, LONG. 28R TO 30R. REPAIRED SKIN IAW SRM.SDR AALA20130531052Skin · damagedFOUND FRESH SCRATCHES, GOUGES WITH RAISED METAL ON FUSELAGE SKIN, LOCATED AFT OF THE FWD CARGO DOOR CUTOUT AT LOWER CORNER. BLENDED AND TREATED IAW SRM 53-00-01-1A.SDR FDEA201305301142Skin · corrodedREAR FUSELAGE SKIN LOWER HORIZONTAL STAB CUTOUT BETWEEN FR 87-89, S27-31R FOUND CORRODED. COMPLED WITH EA6-5330-168201.SDR FDEA201305301141Skin · corrodedREAR FUSELAGE SKIN LOWER HORIZONTAL STAB CUTOUT BETWEEN FR 87-89, S27-31 LT FOUND CORRODED. COMPLIED WITH EA6-5330-168201.SDR FDEA201305301139Skin · corrodedFUSELAGE EXTERIOR SKIN LT SIDE CORRODED BS 704, 1 INCH ABOVE STR 25L. REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 16, REV 108. REPAIR IS CAT B, MAJOR.SDR 2013FA0000295Skin · crackedAIRCRAFT BROUGHT IN FOR REFURBISHMENT, ON REMOVAL OF FUSELAGE FABRIC, REAR TAIL SECTION WAS FOUND CRACKED IN THREE PLACES. (REF:CE-13-14) FUSELAGE REPAIRED STC SA4051NM.
Back to JASC 5330