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 USAA2012083100011Skin · crackedB-CHECK - CRACK IN FUSELAGE SKIN AT BS 727E+8 INCHES, S23R. REPAIRED FUSELAGE SKIN AT BS 727E+8 INCHES, S23R IAW SRM 53-00-01-2R REPAIR 31.SDR UALA2012083004877Skin · wornEXTERIOR FUSELAGE HAS TWO SPOTS WITH EXCESSIVE WEAR AT FRAME 34, S43L AND 43R. REPAIRED PER SRM.SDR R61A201208280598Skin · dentedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, MAINTENANCE REPORTED A DENT. DAMAGE LOCATED AT STA X789.102-801.102 STGR 22-23. MAINTENANCE PERFORMED MAJOR REPAIR AT STA X789.102-801.102 STGR 22-23 IAW BOMBARDIER EO DASH8-Q400-53-100039A. FABRICATED A REPAIR DOUBLERSDR FDEA201208283187Skin · damagedEXTERIOR SKIN AT BS 1440 - 1460, STR 9- 10L HAS LIGHTING STRIKE DAMAGE. REPAIRED AS PER E.A. F-5330-163101 PART 1. REPAIR IS MAJOR.SDR FDEA201208283185Skin · scratchedEXTERIOR SKIN AT STA 310-324, STR 17L -18L SCRATCHED. REPAIRED IAW SRM 53-00-01 FIG.201, REPAIR 16, REV.106. REPAIR IS MAJOR.SDR CHQA20120828315Skin Splice · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE CIRCUMFERENTIAL SKIN SPLICE BETWEEN FRAMES 60 AND 61 AND STRINGERS 20R AND 21R. THE SKIN SPLICE WAS REPAIRED IN ACCORDANCE WITH ETD 2012-145-012305.SDR SWAA2012091007452Skin · crackedAFT CARGO DOOR BEAR STRAP FWD LOWER CORNER OF CUTOUT CRACKED BETWEEN BS 787 TO BS 814 AND BETWEEN STR 22R TO STR 26R. REPAIRED SKIN PER SRM.SDR AALA20120828004Skin · crackedCRACK IN SKIN ABOVE RIGHT AFT NOSE LANDING GEAR DOOR HINGE. INSTALLED REPAIR DOUBLER PER SRM 53-05-00.SDR IPXA12175999Skin Panel · dentedINSPECTION TYPE: 10YR, DEFERRED ITEM D-487012 DAMAGE TO FUSELAGE FWD PRESSURE BULKHEAD RT SIDE FUSELAGE LATERAL SKIN PANEL AT FR 0 DENTED. ACCOMPLISHED REPAIR ON RT SIDE FUSELAGE LATERAL SKIN PANEL DENT AT FR0 IAW EO A300-5330-48914-A, PARA 6A.SDR SWAA2012100108164Skin · crackedSKIN CRACKED AT BS 360+2, BETWEEN STR 5R TO STR 6R. REPAIRED SKIN IAW EA.SDR SWAA2012083107210Skin · crackedSKIN CRACKED AT BS 440 + 4, STR 1. REPAIRED SKIN PER EA.SDR USAA2012082800012Skin · crackedRON CHECK - CRACK IN FUSELAGE SKIN AT BS 927+6 INCHES, S25R. REPAIRED FUSELAGE SKIN AT BS 927+6 INCHES, S25R IAW B737 SRM 53-00-01-2R-31.SDR USAA2012082800006Skin · crackedRON CHECK - CRACK IN FUSELAGE SKIN AT BS 943, S25R. REPAIRED FUSELAGE SKIN AT BS 943, S25R IAW B737 SRM 53-00-01-2R-31.SDR USAA2012082800005Skin · corrodedRON CHECK - CRACK IN FUSELAGE SKIN AT BS 944, S24R. REPAIRED FUSELAGE SKIN AT BS 944, S24R IAW B737 SRM 53-00-01-2R-31.SDR USAA2012082800004Skin · crackedRON CHECK - CRACK IN FUSELAGE SKIN AT BS 941, S23R. REPAIRED FUSELAGE SKIN AT BS 941, S23R IAW B737 SRM 53-00-01-2R-31.SDR USAA2012082800001Skin · crackedRON CHECK - CRACK IN FUSELAGE SKIN AT BS 727E, S24R AT PREVIOUS REPAIR. REPAIRED FUSELAGE SKIN AT BS 727E, S24R IAW EA 104211.SDR SWAA2012100108163Skin · corrodedSKIN CORRODED BETWEEN BS 520 AND BS 540, BETWEEN STR 28L AND STR 28R. REPAIRED SKIN IAW EO AND EA.SDR AALA20120826004Skin · damagedLIGHTNING STRIKE TO FUSELAGE SKIN. INSTALLED DOUBLER PER SRM 53-04-02 FIGURE 2 SHEET 3 VIEW C.SDR AALA20120826003Skin · damagedLIGHTNING STRIKE TO FUSELAGE SKIN. INSTALLED DOUBLER PER SRM 53-04-02 FIGURE 2 SHEET 3 VIEW C.SDR AALA20120826002Skin · damagedLIGHTNING STRIKE TO FUSELAGE SKIN. INSTALLED DOUBLER PER SRM 53-04-02 FIGURE 2 SHEET 3 VIEW C.SDR SWAA2012090607392Skin · corrodedSKIN CORRODED AT BS 947.5, STR 26L. REPAIRED SKIN IAW SRM.SDR USAA2012082800003Skin · crackedRON CHECK - CRACK IN FUSELAGE SKIN AT BS 727C+6 INCHES, S23R. REPAIRED FUSELAGE SKIN AT BS 727C+6 INCHES, S23R IAW EA 104211.SDR USAA2012082800002Skin · crackedRON CHECK - CRACK IN FUSELAGE SKIN AT BS 727E, S24R. REPAIRED FUSELAGE SKIN AT BS 727E, S24R IAW EA 104211.SDR DALA1247209004Skin · crackedFUSELAGE CROWN SKIN STA 1418 LBL 10 CRACKED. REPAIRED PER ER/A 506417-14AD BY CUTOUT AND INSTALLATION OF TITANIUM DOUBLER.SDR DALA1247199004Skin · crackedFUSELAGE CROWN SKIN BS 1418 RBL 10 CRACKED. REPAIRED PER ER/A 506416-14AD BY CUTOUT AND INSTALLATION OF TITANIUM DOUBLER.SDR DALA1247180914Skin · crackedINDICATION OF CRACK AT FASTENER HOLE THRU SKIN BS 1416 INBOARD OF L2R. REPAIRED PER ERA 505959-14 ORIG.SDR DALA1247169004Doubler · corrodedAFT LAV SERVICE PANEL LOWER SERVICE PANEL PILLOWING CORROSION. CONTAINED CORROSION FOUND TO BE OUT OF LIMITS. INSTALLED REPAIR DOUBLER AND TRIPLER PER ER/A 506434-14.SDR AALA20130711002Skin · dentedDENT AT STATION 480 BETWEEN STRINGERS 25 & 26 RT. DAMAGE WAS REMOVED & DOUBLER INSTALLED IAW SRM 53-00-01-2R-3.SDR UALA2012090404936Skin · dentedSKIN DENTED 15 INCHES BELOW WATER DRAIN BELOW 2L. INSPECTED SKIN WITH HFEC IAW NDT 51-00-01. NO CRACKS FOUND. REPAIRED DENT IAW SRM 53-00-01 FIG 201 REPAIR 3. HFEC ACCOMPLISHED IAW NDT MANUAL PT 6 51-00-19 AND 51-00-16.SDR UALA2012082704776Structure · damagedEXTERIOR FUSELAGE BLEND OUT AT STA 324 & APPROX S-22R. REF SCAL LP 9979832. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLER. REF SRM 53-00-01 REPAIR 3.SDR UALA2012082704768Skin · damagedINSTALL REPAIR DOUBLER AT STA 1433 BETWEEN S- 30 AND S-29L. INSTALLED FUSELAGE REPAIR DOUBLER AT PREVIOUS AIRFONE ANTENNA LOCATION. REF SRM 53-00-01 REPAIR 3. ACCOMPLISH RII INSPECTION OF AMIS ITEM 2242054.SDR SWAA2012082707074Skin · crackedSKIN CRACKED AT BS 500+9, STR 10L. REPAIRED SKIN PER EA.SDR FDEA201208253166Skin · dentedDENT AT BS 418, BETWEEN S-15L TO S-16L, FOUND OUT OF LIMITS IAW-SRM-53-00-01, FIG 101, DET III. REPAIRED DENT IAW-SRM-53-00-01, FIG 201, R16, PG 201, MAJOR REPAIR. INSTALLED REPAIR DOUBLER IAW SRM-51-40-02.SDR ASOA20120825078Skin · crackedFUSELAGE SKIN HAS CRACKS AROUND RIVETS FR 79, STR 5L. REPAIRED SKIN IAW EC 5330-02501. ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR 7AHR20120825002Panel · crackedLOWER APU AIR INLET IS CRACKED AT AFT CORNER. REMOVED APU AIR INLET LOWER PANEL, CUT OUT AND REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR DOUBLER FROM 0.050 2024 T3 IAW SRM 51-70-04, PG 21.SDR USAA2012092400010Skin Panel · corroded2S CHECK - CORROSION ON SKIN PANEL BETWEEN FR63 TO FR64 & BETWEEN S41L TO S42L. REPAIRED SKIN PANEL BETWEEN FR63 TO FR64 & BETWEEN S41L TO S42L IAW EA 502245.SDR USAA2012092400009Skin Panel · corroded2S CHECK - CORROSION ON SKIN PANEL BETWEEN FR63 TO FR64 & BETWEEN S41R TO S42R. REPAIRED SKIN PANEL BETWEEN FR63 TO FR64 & BETWEEN S41R TO S42R IAW EA 502902.SDR SWAA2012092407922Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092107871Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 837, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA2012092107870Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727C+19, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA2012092007805Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007804Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007803Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007802Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007801Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007800Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007799Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012092007798Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012091907775Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPARIED SKIN IAW EA.SDR SWAA2012091907774Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.
Back to JASC 5330