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 SWAA070551Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 492, STR 27R. REPAIRED SKIN PER ER.SDR SWAA070533Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA070543Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 540, STR 16R. REPAIRED SKIN PER SRM.SDR IXXA07SMN067SDoubler · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND EXISTING INTERNAL DOUBLER CORRODED FROM STATION FS 1640.000 TO STATION FS 1660.000 AND FROM LONGERON 29 RIGHT TO LONGERON 33 RIGHT. REMOVED FASTENERS AS NEEDED TO PERFORM REPAIR. REMOVED CORROSION. FOUND OUT OF LIMITSDR IXXA07SMN055SSkin · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND A NON STANDARD REPAIR AT STATION FS12.000 LONGERON 27 RIGHT. REMOVED EXISTING NON STANDARD REPAIR. REMOVED DAMAGED AREA. PERFORMED NDT INSPECTION. NO CRACK OR CORROSION FOUND. AFTER DAMAGE REMOVED. FABRICATED REPAISDR IXXA07SMN054SSkin · crackedDURING ROUTINE C CHECK INSPECTION, FOUND EXTERNAL FUSELAGE SKIN CRACKED AT STATION FS1400.00 LONGERON 33 RIGHT. REMOVED DAMAGED AREA. PERFORMED NDT INSPECTION. NO CRACKS OR CORROSION FOUND, AFTER DAMAGE REMOVED. FABRICATED REPAIR PARTS. CLEANED, TREATED ASDR IXXA07SMN052SSkin · misrepairedDURING ROUTINE C CHECK INSPECTION FOUND A IMPROPER REPAIR AT STATION FS1762, LONGERON 34 LEFT. REMOVED DAMAGED SKIN PANEL CLEANED TREATED AND PRIMED AREA AND NEW SKIN PANEL. APPLIED SEALANT TO FAYING SURFACES. INSTALLED NEW SKIN PANEL FROM STATION 1696 TO SSDR IXXA07SMN050SSkin · damagedDURING ROUTINE C CHECK INSPECTION, FOUND LOWER FUSELAGE SKIN HAS SCRATCHES AND SMALL DENT AT STATION FS1870 LONGERON 36. REMOVED DAMAGED SKIN PANEL. CLEANED TREATED AND PRIMED AREA AND NEW SKIN PANEL. APPLIED SEALANT TO FAYING SURFACES INSTALLED NEW SKIN PASDR IXXA07SMN051SSkin · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND AN IMPROPER REPAIR AT STATION FS367, LONGERON 20 LEFT. REMOVED EXISTING REPAIR DOUBLER. REMOVED DAMAGED AREA. FABRICATED REPAIR PARTS. CLEANED, TREATED AND PRIMED AREA AND REPAIR PARTS. APPLIED SEALANT TO FAYING SUSDR 2007UALA00340Skin · puncturedSKIN PUNCTURED 1 X 2 INCHES JUST FORWARD OF FWD LAV SERVICE PANEL CAUSED BY LAV TRUCK. MAJOR REPAIR, INSTALLED REPAIR PARTS REF SRM 53-10-01 RPR 11 DETAIL V AND DETAIL VII.SDR UPS07449117Skin · puncturedINSPECTION TYPE:C FX- BS 203 RBL 3" EXTERIOR SKIN FOUND PUNCTURED, CRACK LENGTH 1/2". FX EXTERIOR SKIN REPAIRED AS PER SRM 53-30-03 FIG 1, JUST BETWEEN BS 195 AND 208 STR -1L AND STR -1R.SDR ASAA0791430Skin · ground damageRAMP HIT AIRCRAFT WITH BELT LOADER AT FWD CARGO DOOR AFT EDGE DAMAGED AT BS 450 AND WL 155. REPAIRED IAW SRM 53-00-01 REPAIR 25.SDR ASAA0791429Skin · ground damageRAMP HIT AIRCRAFT WITH BELT LOADER AT FWD CARGO DOOR AFT EDGE DAMAGED AT BS 450 AND WL 155. REPAIRED IAW SRM 53-00-01 REPAIR 25.SDR UIEA200700051Skin · damagedFUSELAGE BS 2300 S-23 EXISTING DOUBLER FOUND DAMAGED. REPAIRED ACCOMPLISHED AS PER BOEING SR ID NR 1-274437619.SDR ZZDA070123115Skin · dentedDENT APPROX 6 INCHES UP FROM L18 AND 8 INCHES AFT OF STA 218. INSTALLED DOUBLER REPAIR STA 218 TO STA 246 AS PER B717 SRM 53-00-01 REPAIR NR 6.SDR ZZDA070123114Skin · dentedDENT ON RIGHT SIDE OF FUSELAGE AFT OF R1 DOOR STA 212 53-00-01 REPAIR 2. INSTALLED DOUBLER REPAIR AT RIGHT SIDE OF FUSELAGE AFT OF R1 DOOR STA 212 AS PER B717 SRM.SDR SWAA070501Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA070498Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT R2 DOOR LOWER HINGE CUTOUT LOWER AFT CORNER CRACKED. REPAIRED SKIN PER SWA EA.SDR SWAA070500Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730E, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA070484Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 304, STR 10L. REPAIRED SKIN PER ER.SDR SWAA070483Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 514D, STR 12R. REPAIRED SKIN PER ER.SDR UPS07M49574Doubler · corrodedINSPECTION TYPE:C CTR CARGO STA 1721-1741 STR 51R TO 52R BILGE AREA DOUBLER FOUND WITH CORROSION AS MARKED. CTR CARGO DRUM MUST REMOVED PER AMM20-50-02 R55. CORROSION REMOVED PER SRM 51-31-01 V2 R38. CORROSION REMOVED FOUND EXCEED LIMIT PER SRM 51-21-01 V2 SDR UPS07549202Skin · dentedINSPECTION TYPE:C3 EXTERIOR FUSELAGE SKIN HAS A DENT AT STR 7R, BS 751. REPAIRED DENT IN EXTERIOR FUSE SKIN BS 751, STR 7R, IAW SRM 53-00-01-2 -2R.SDR ZZDA070130136Skin · dentedDENT ON RT SIDE AFT OF R1 DOOR STA 212 BETWEEN LONG 15 AND 16 RT. INSTALLED FLUSH REPAIR PER B717 SRM 53-00-01 FIG 204 REPAIR 2.SDR ZZDA070123116Skin · dentedDENT FOUND ON LWR FUSELAGE RIGHT SIDE AFT OF FWD DRAIN MAST. INSTALLED DOUBLER REPAIR AT RIGHT SIDE AFT OF FWD DRAIN MAST AS PER B717 SRM 53-00-01 FIG 204.SDR MALA070020Skin · dentedTHE LT FORWARD FUSELAGE, JUST AFT OF THE RADOME AND BETWEEN THE TWO RADOME LATCHES IS DENTED. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO NR S53344. REF: EAMS WORK ORDER 215422 TASK 1502.SDR SWAA070468Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 967, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA070470Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 560, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA070469Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 731D, STR 18R. REPAIRED SKIN PER SWA EA.SDR ASAA0741425Skin · damagedFOUND DAMAGE TO EXISTING REPAIR DOUBLER. REMOVED EXISTING REPAIR PIECES TRIMMED OUT UPPER SKIN AREA WITH SHORT ED. FABRICATED AND INSTALLED FILLERS DOUBLERS AND TRIPLER IAW ASA EA 5330 02176.SDR ASAA0741424Skin · dentedFOUND DENT IN FUSELAGE SKIN. REMOVED DAMAGED SECTION OF SKIN FABRICATED AND INSTALLED FILLERS AND DOUBLER IAW ASA EA 5330 02175.SDR UPS07M49197Skin · damagedINSPECTION TYPE:2C CENTER CARGO DOOR CUTOUT SKIN LOWER LEFT AFT CORNER CHIPPED, DENTED, & GOUGED. CUT OUT DAMAGED AREA, FABRICATED, AND INSTALLED REPAIR IAW MD-11 SRM 53-50-00.SDR 2007UALA00253Skin · damagedEXT FUSELAGE SKIN BENT & DAMAGED AT AFT GALLEY DOOR LOWER HINGE CUTOUT. MAJOR REPAIR: FABRICATED AND INSTALLED DOUBLER AND FILLER REPAIR PER SRM 53-60-01 REPAIR NR 7.SDR DL757070065Skin · crackedFATIGUE CRACK IN BEAR STRAP AT UPPER FORWARD CORNER OF L-1 DOOR CUTOUT, FS 340, S-7L. CUT OUT DAMAGE IN BEAR STRAP AND SKIN AND INSTALLED DOUBLER STACKUP.SDR SWAA070464Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 16L. REPAIRED SKIN PER SWA EA.SDR 07FDEA00196Skin · corrodedLT EXT FUSE SKIN IS FRETTED AT FILLET FRG PANEL INTERFACE BS 720D 10 TO 720D 15, STR 19L REMOVED LEADING EDGE FOR ACCESS TO REPAIR, INSTALLED EXTERNAL REPAIR AT LAP SPLICE REF SRM 53-30-3 PG 20. REINSTALLED LEADING EDGE AND LEAKED CHECKED HYD LINES REF MM 27-SDR 07FDEA00195Skin · corrodedRT EXT FUSE SKIN AT FILLET FRG PANEL INTERFACE IS FRETTED BS 720D 10 TO 720E, STR 19R TO 4" ABOVE STR 18R REMOVED LEADING EDGE FOR ACCESS TO REPAIR. INSTALLED EXTERNAL REPAIR AT LAP SPLICE REF SRM 53-30-3 PG 20. REINSTALLED LEADING EDGE AND LEAKED CHECKED HYSDR ABXA070026Skin · crackedDURING INSPECTION OF FUSELAGE SKIN AT LONGERON 22, FOUND SKIN CRACKED AT LOWER AFT CORNER OF AIR STAIR DOOR, STA 200. REPAIRED CRACK IAW ABX EA 5300001-003-2.SDR DU4R2007053Splice · corrodedCORROSION ON SKIN SPLICE AT BS 1400 S-29L TO 30 IN AFT CARGO COMPARTMENT. FABRICATED AND INSTALLED SKIN SPLICE 36.0" BY 4.0" FROM 7075-T6 .071" IAW B757 SRM 51-40-02 AND BAC146N8522.SDR DLM88070066Skin · dentedFOUND AIRCRAFT FUSELAGE DAMAGED AT APPROX STA 530 BETWEEN LONGERON 26R AND 27R. REMOVED DAMAGE. FABRICATED REPAIR PER SRM 53-04 FIG 12B CLASS I REPAIR. OK TO TREAT AND PAINT AREA AND REPAIR PIECE QC1509. TREATED AND PAINTED AREA AND REPAIR PER SRM 53-04 FISDR AWXA200700225Skin · crackedMCN - FOUND FUSELAGE SKIN CRACKED, BS 967, S17R. REPAIRED FUSELAGE SKIN, BS 967, S17R IAW B737-300 SRM 53-60-01-2R3.SDR SWIA200717777Skin · crackedFUSELAGE SKIN CRACKED AT MID FUSELAGE STATION BETWEEN FRAMES 21 LEFT AND 21 RIGHT, DISCOVERED DURING C-CHECK INSPECTION. FABRICATED AND INSTALLED DOUBLER FILLER PER EMBRAER AUTHORIZED REPAIR 1C 2007-120/00663 DATED 1/28/07 AND RII 53-800-1000.SDR SWAA070443Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 738E, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA070442Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 748, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA070441Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, BL 0. REPAIRED SKIN PER SB AND EA.SDR AWXA200700316Skin · crackedMCN - FOUND CRACKED FUSELAGE SKIN, BS 407, S28L - S28R. REPAIRED FUSELAGE SKIN, BS 407, S28L - S28R IAW AWA EO 5331-01024 AND AWA TASK CARD M2A53002.SDR 2007UALA00219Skin · crackedLOWER FUSELAGE SKIN EXTERIOR SKIN CRACKED AT STA 947 STR 24L. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED DOUBLER, TRIPLER, AND FILLER PER SRM 53-00-01 REPAIR 31 DETAIL VIII.SDR SWAA070425Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR 07FDEA00185Skin · corrodedCTR CARGO COMPT BILGE FOUND CORROSION WITH EXFOLIATION ON SKIN BTWN STA 1521 AND STA 1541 FROM LONG NR 45 RT TO LONG NR 42 LT. TRIMMED OUT DAMAGED SKIN AND REPAIRED IAW SRM 53-20-00 VOL 2 FIG 6 SHT 15. FABRICATED PARTS IAW ETAIL PARTS TRAVELER I026602/N01602SDR 07FDEA00176Skin · dentedLOWER EXT FUSELAGE FOUND DEEP DENT 13" BY 4" MAX DEPTH .200" LOWER SKIN AT STA 899 FROM LONG NR 50 RT TO LONG NR 52 C/L. REMOVE DOUBLER AAU7010-3 AND DOOR ADA8067-1 IAW SRM 51-30-00 VOL 2. TRIMMED OUT DAMAGED AREA AND REMOVED EXISTING REPAIR AT STA 899 LONG
Back to JASC 5330