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 SWAA090681Skin · crackedDURING SCHEDULED 12Y CHECK, FOUND RADIO ALTIMETER ANTENNA SKIN CUTOUT CRACKED AT BS 413, RBL 3. REPAIRED SKIN PER SWA EA.SDR SWAA090680Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND AFT CARGO SKIN REVEAL CRACKED AT BS 847. REPAIRED SKIN PER SRM.SDR SWAA090672Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 173 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090671Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 175 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090670Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 179 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090669Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 180 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090668Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 184 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090667Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 186 LT SIDE. REPAIRED SKIN PER ER.SDR UPS09154635Skin · misrepairedINSPECTION TYPE:1C3C REPAIR SEQUENCE 143-F1-05 REPAIR DOUBLER AT RT FUSELAGE SKIN PLATE FR83-84 AND STR 33R- 35R IS MISSING 1 ROW OF FASTENERS OUTSIDE OF STR 35R, REF EO A300-5100-30824 APPX C. REMOVED EXISTING REPAIR, FABRICATED, AND INSTALLED REPAIR DOUBLERSDR UPS09154615Skin · misrepairedINSPECTION TYPE:1C REPAIR SEQ 143-F1-05 REPAIR DOUBLER AT RT FUSELAGE SKIN PLATE FR 83 TO 84 AND STR 33R TO 35R IS MISSING 1 ROW OF FASTENERS OUTSIDE OF STR 35R. REMOVED, FABBED AND INSTALLED REPAIR DOUBLER IAW A300-600 SRM 51-40-21, PARA 6 AND 53-10-12, FIG SDR QXEA2009020200076Skin · damagedPDX - C2 - 2 LIGHTENING ABOVE STR 1R BETWEEN FS 321 AND FS 323.5. STRIPPED PAINT AND REMOVED RIVET PER CRJ 700 SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DAMAGE REMASDR QXEA2009020200075Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET STR 1L AND FS 368. STRIPPED PAINT AND REMOVED RIVET PER CRJ 700 SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DAMAGE REMAINING. HFESDR QXEA2009020200074Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET FS 409 BETWEEN STR 1L AND 2L. STRIPPED PAINT AND REMOVED RIVET PER SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DAMAGE REMAINING. SDR QXEA2009020200073Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET FS 476.5 BETWEEN STR 1L AND 2L. STRIPPED PAINT AND REMOVED RIVET PER SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DAMAGE REMAINING.SDR QXEA2009020200072Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET FS535 BETWEEN STR 1L AND 2L. STRIPPED PAINT AND REMOVED RIVET PER SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DAMAGE REMAINING. BSDR QXEA2009020200071Skin · damagedPDX - C2 - 4 LIGHTENING BURNS AT RIVETS ALONG STR 1R BETWEEN FS285 AND FS290. STRIPPED PAINT AND REMOVED RIVET PER SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DAMAGE SDR QXEA2009020200070Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET AT STR 0 AND FS 335. STRIPPED PAINT AND REMOVED RIVET PER SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DAMAGE REMAINING. HFEC INSPSDR QXEA2009020200069Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET STR 1L AND FS 354. STRIPPED PAINT AND REMOVED RIVET PER CRJ 700 SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DAMAGE REMAINING. HFESDR SWAA090698Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND ANTENNA DOUBLER BELLY SKIN CRACKED BETWEEN BS 727E TO BS 727E. REPAIRED SKIN PER SWA EA.SDR SWAA090696Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 970, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA090695Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 500C, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA090692Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 267, STR 15R. REPAIRED SKIN PER SWA EA.SDR CALA2009020200078Skin · damagedDRILL DAMAGE LOCATED ON FUSELAGE SKIN, CROWN AREA, BETWEEN STATION 460 TO 480, STRINGERS S-2R AND S3-R. REPAIRED FUSELAGE SKIN BETWEEN STATION 460 TO 480, S-2R AND S3-R, PER B757 SRM 53-00-01, REPAIR 3.SDR AALA2009020900040Skin · crackedAFT SERVICE DOOR SKIN CRACKED AT HOLD OPEN HOOK CUTOUT. INSTALLED DOUBLER ON AFT SERVICE DOOR IN ACCORDANCE WITH SRM 52 05 00 FIGURE 54 SHEET 1.SDR FDEA200901300403Skin · misrepairedEXISTING DOUBLER REPAIR ON RT FUSELAGE STA 1093, LONGERON 38-39. EXISTING DOUBLER REPAIR ON THE RT FUSELAGE STA 1093, LONGERON 38-39 EVALUATED AND FOUND NOT CARRIED OUT IN ACCORDANCE WITH ANY REPAIR SCHEME. EXISTING DOUBLER REPAIR ON THE RT FUSELAGE STA 1093SDR DL757090127Skin · damagedFUSELAGE SKIN WAS DAMAGED AT STA 680 TO 700 ABOVE S-26L. CUTOUT THE DAMAGED SKIN AND INSTALLED AN EXTERNAL REPAIR DOUBLER.SDR DL757090125Skin · damagedTHE FUSELAGE SKIN WAS DAMAGED DURING INSTALLATION OF THE WI-FI ANTENNA AT STA 508 TO STA 520, S-28L TO S-28R. CUTOUT DAMAGED SKIN AND INSTALLED AN EXTERNAL REPAIR DOUBLER.SDR SWAA090715Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 500B, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA090714Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 480, STR 25R. REPAIRED SKIN PER SRM.SDR QXEA2009020200068Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET FS437 BETWEEN STR 1L AND 2L. STRIPPED PAINT AND REMOVED RIVET PER CRJ 700 SRM 51-42-06. MAPPED AREA FOR ENGINEERING. ENLARGED COUNTERSINK TO .305 INCH TO TRY TO REMOVE DAMAGE PER ENGINEERING REQUEST, DAMAGE REMAINS IN SKISDR QXEA2009020200067Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET FS449 AND STR 1L. STRIPPED PAINT AND REMOVED RIVET PER CRJ 700 SRM 51-42-06. MAPPED AREA FOR ENGINEERING. ENLARGED COUNTERSINK TO .306 INCH TO TRY TO REMOVE DAMAGE PER ENGINEERING REQUEST, DAMAGE REMAINS IN SKIN. RE MAPPSDR QXEA2009020200066Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET F S501 BETWEEN SRT 1L AND 2L. STRIPPED PAINT AND REMOVED RIVET AS PER CRJ 700 SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DAMAGE RSDR QXEA2009020200065Skin · damagedPDX -C2 - LIGHTENING BURN AT RIVET FS 597 BETWEEN STR 1L AND 2L. STRIPPED PAINT AND REMOVED RIVET FROM AFFECTED AREA IAW SRM 51-42-06. MAPPED FOR ENGINEERING. ENLARGED COUNTERSINK TO FIT A -5 426 RIVET TO REMOVE DAMAGE PER ENGINEERING REQUEST AND FOUND NO DSDR QXEA2009020200064Skin · corrodedPDX - C2 - CORROSION ON LOWER SKIN AROUND LOWER TCAS ANTENNA CONNECTOR HOLE. BLENDED AREA OF CORROSION TO REMOVE DAMAGE IAW SRM 53-00-01 AND FOUND BLENDS TO BE OUTSIDE ALLOWABLE LIMITS IAW SRM 53-21-01. HFEC IAW CRJ 700 NDTM PART 1, 51-20-006, NO CRACKS NOTESDR SWIA200921618Skin · crackedC-CHECK, SKIN CRACKED BETWEEN FS 1144 AND FS 1154. REPAIRED PER REO.SDR SWAA090712Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 480, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA090711Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 420, STR 22L. REPAIRED SKIN PER SRM.SDR ZZDA2009030Doubler · crackedRT VENT BOX INTERNAL DOUBLER & EXISTING OUTER STIFFENER CRACKED. INSTALLED NEW INTERNAL DOUBLER & OUTER STIFFENER PER SRM 51-40-02.SDR USAA2009013090232Skin · crackedCLT - C1 - MAJOR REPAIR - CRACK ON FUSELAGE SKIN AT BS 951, S15L FORWARD OF L2 DOOR LOWER HINGE. REPAIRED FUSELAGE SKIN AT BS 951, S15L FORWARD OF L2 DOOR LOWER HINGE IAW US AIRWAYS TYPICAL REPAIR 53-60-10 & US AIRWAYS EA 100865.SDR QXEA20090200057Skin · damagedPDX - C2 - LIGHTENING BURN AT RIVET FS 549 BETWEEN STR 1L AND 2L. STRIPPED PAINT AND REMOVED RIVET IAW SRM 51-42-00. FOUND BURN MARK TO BE ON THE RIVET HEAD ONLY. ALODINED AND PRIMED AREA AS PER SRM 51-42-06 AND PAINTED AFFECTED AREA IAW SRM 51-25-01.SDR SWAA090657Skin · corrodedDURING SCHEDULED BRDG CHECK, FOUND LOWER SKIN CORRODED AT BS 227, BETWEEN RBL 8 TO LBL 6. REPAIRED SKIN PER SWA EA.SDR SWAA090656Skin · corrodedDURING SCHEDULED 24Y CHECK, FOUND SKIN CORRODED AT BS 887, BETWEEN STR 27R TO STR 27L. REPAIRED SKIN PER SRM.SDR SWAA090646Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 303, WL 258. REPAIRED SKIN PER AAR EA.SDR SWAA090645Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 303, WL 261. REPAIRED SKIN PER AAR EA.SDR SWAA090633Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 259, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA090632Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 923, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA090631Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA090630Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA090629Skin · crackedDURING SCHEDULED SC CHECK, FOUND SKIN CRACKED AT BS 517, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA090628Skin · crackedDURING SCHEDULED SC CHECK, FOUND SKIN CRACKED AT BS 727E, BETWEEN STR 19R TO STR 20R. REPAIRED SKIN PER SWA EA.
Back to JASC 5330