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 QXEA200600296Skin · nickedYYC - C3 FUSELAGE EXTERIOR HAS NICK ON SKIN AT STATION 685 AND STRINGER 15L. REPAIRED IAW CRH700 SRM 53-00-01-991-803 AND 51-25-01-001-001-A01.SDR UPS06246069Skin · damagedINSPECTION TYPE:C&SI FUSELAGE SKIN DAMAGE BETWEEN BS 1148 AND 1166 AND BETWEEN S11-13 LT. REPAIR CARRIED OUT IAW MM 51-20-01 AND SRM 53-30-03.SDR ABXA060045Spar Cap · corrodedWING CENTER SECTION UPPER SURFACE HAD TWO AREAS OF CORROSION WITH PITTING BS 851, RIGHT BUTT LINE 12, BS 851, RIGHT BUTT LINE 17. CUT OUT DAMAGED AREA AND REPAIRED WITH NEW PART IAW DC8 SRM 53-2-5. ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED IAW DC8 SSDR EIA2006009Skin · ground damageDAMAGE FROM IMPACT BY GROUND EQUIPMENT AT BS 160-220, STR 23L-34L. DAMAGE REMOVED, COMPONENTS FABRICATED AND INSTALLED TO REPAIR PER ECRA 482-53-213-2, RVSM INSPECTION COMPLIED WITH PER EO 53=747-1453-96, REV A.SDR EIA2006008Skin · misdrilledMISDRILLED FASTENER HOLE IN EXTERNAL FUSELAGE SKIN AT STR 36L, BS 180. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR PER ECRA 482-53-213-2.SDR SWAA060182Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA060156Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 761, STR 19R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060154Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 733D, STR 14L. REPAIRED SKIN PER SWA EA.SDR SIMA200602328Skin · damagedTHE FUSELAGE SKIN WAS FOUND TO HAVE A DENT BETWEEN FRAMES 64-65 AND STRINGERS 19L AND 20L. REMOVED THE DAMAGED SKIN BY MAKING A CUT OUT. FABRICATED FILLER AND DOUBLER. REPAIR DONE IAW SRM. (K)SDR UPS06246100Skin · corrodedINSPECTION TYPE:C EVIDENCE OF FRETTING FOUND AT BS 1080 TO 1139.5 FROM STR 24L TO STR 26 L ON THE SKIN. SKIN REPLACMENT REQUIRED AT THIS LOCATION, CARRIED OUT IAW AAAE EO NR 2006-003-001 - UPS REF NR B727-5330-23687-A.SDR 06FDEA0182Skin · corrodedUPPER CROWN SKIN HAS SURFACE CORROSION ON INNER SIDE, BS 740-BS 870, STR 1 - STR 4R.SDR MWEA060006Doubler · gougedSKIN GOUGED AT FORWARD OF AIRSTAIR DOOR. FABRICATED AND INSTALLED DOUBLER.SDR 06FDEA0157Skin · crackedEXTERIOR FUSELAGE SKIN HAS A CRACK AT BS 352, LBL 18, WL 145. *S/D* REPAIRED SKIN IAW SRM 53-30-3.SDR 0600369873Skin · crackedDURING LINE CHECK FOUND CRACKS IN FUSELAGE SKIN FROM BS 1292-1314 IN RIVET LINE ABOVE S16R. REPAIRED PER EA 98-205703 AND ESTABLISHED MONITOR AT 3000 CYCLES.SDR ABXA060042Skin · corrodedDEFOLIATED SKIN ON BELLY OF PLANE JUST AFT OF SKIN DOUBLER AT APPROXIMATELY STA 1420, LONGERON 36. REPAIRED AREA IAW ABX REA D853-51398-MR.SDR 06FDEA0155Skin · dentedDENT IN EXTERNAL FUSELAGE SKIN AT BS 1163, STR 9L. *S/D* DENT IN FUSELAGE SKIN AT BS 1163, STR 9L REPAIRED IAW SRM 53-30-3.SDR SWAA060172Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA060171Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA060170Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 21L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060169Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT NR 2 RADIO ALTIMETER ANTENNA CUTOUT, BS 410, BL 0. REPAIRED SKIN PER SWA EA.SDR SWAA060166Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 529, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA060153Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 504A, STR 17R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060152Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 394, STR 17R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060151Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 376, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA060150Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 751, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA060148Skin · crackedDURING OTS, FOUND FUSELAGE SKIN CRACKED AT BS 452, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA060147Skin · crackedDURING OTS, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA060146Skin · crackedFUSELAGE SKIN CRACKED AT BS 800, STR 19L. REPAIRED SKIN PER SWA EA.SDR 06FDEA0158Skin · crackedEXTERIOR FUSELAGE SKIN HAS A CRACK AT BS 352, LBL 18, WL 145.SDR 06FDEA0156Skin · crackedEXTERIOR SKIN HAS A CRACK AT FASTENER HOLE AT BS 352, RBL 18, WL 145. REPAIRED CRACK PER ER 06-1285 AND FED EX EA 7-5330-96592.SDR PIDA06004Skin · crackedCRACK IN FUSELAGE SKIN AT BS 380 ABOVE STR 4 RT SKIN LAP JOINT. REPAIRED DAMAGE PER SRM 53-00-01.SDR QXEA200600304Skin · chafedYYC - C3 FUSELAGE EXTERIOR, LOWER SKIN HAS CHAFE DAMAGE FROM THE FAIRING STIFFENER AT FUSELAGE STATION 974 AND BLO. REPAIRED IAW REO 67053-00-014 REV (STEP 1, 2 AND 4).SDR MALA060027Skin · dentedDURING 4K2Y BRIDGE CHECK VISIT, A DENT ON THE LEFT HAND FORWARD FUSELAGE BELOW WINDOW NR 2 FROM STA 350L TO STA 362L AND STRINGER SL 1622 SL 1636 WAS FOUND AND REPAIRED IAW MESABA EO S53035 ON MM409 262804.SDR UPS06846003Doubler · mismanufacturedINSPECTION TYPE:C3 FUSELAGE EXTERNAL SKIN DOUBLER REPAIR SEVERAL FASTENERS HAVE SHORT EDGE DISTANCE STA 215 L22R-L23R PER DC8- 5330-12800 REPAIR REF: NR 718-2R-11. REMOVED EXISTING REPAIR DOUBLER IAW SRM 51-1-21 FABRICATED AND INSTALLED REPAIR 2EA FINGER DOUBSDR AWXA200600048Skin · dentedPHX - FUSELAGE DENT REPORTED ON PHASE 9 CHECK AT EMPENNAGE BODY STATION 3731, UPPER STR/SPAR 1. MAINTENANCE REMOVED DAMAGED SKIN ON AFT FUSELAGE TAIL SKIN. FABRICATED REPAIR DOUBLER IAW AMERICA WEST AIRLINES ER 26-5358-06011-RA2. INSTALLED FABRICATED REPAIRSDR 06FDEA0148Skin · corrodedWHILE INSPECTING LT LOWER NOSE CHORD INSTALLATION FOUND SKIN DISBONDED AND CORRODED AT BS 297, LBL 20, WL 148.SDR 06FDEA0145Skin · damagedFOUND BELLY SKIN AND RIB ANGLE DAMAGED AND WRINKLED AFT OF AIR STAIRS AT BS 1345. REMOVED AND FABBED NEW BELLY SKIN STRAP AND SHIM IAW SRM 51-10-1, INSTALLED BELLY SKIN AND SHIM IAW SRM 51-30-2 AND RIB FOUND NO DAMAGE AFTER FURTHER EVALUATION.SDR ASAA0670007Doubler · crackedPAE - FOUND DURING CHECK, EXT PWR DOOR CUT OUT DOUBLER DAMAGED. REPAIRED IAW SRM 51-40-02. (M)SDR DHL2006752521Skin · unknownFOUND NR 111056; ACCOMPLISH IDENTIFICATION OF EXISTING FLUSH FUSELAGE SKIN REPAIR AT BS 499 & BETWEEN STR 19R-20R. ACCOMPLISHED IDENTIFICATION OF EXISTING FLUSH FUSELAGE SKIN REPAIR AT BS 499 & BETWEEN STR 19R-20R. INSTALLATION PERFORMED IAW B727 SRM 53-30-3SDR QXEA200600171Skin · corrodedPDX: AFT CARGO BAY LOWER DECK SKIN PANEL HAS CORROSION AROUND SCREW HOLE AT FSX 780. MAINTENANCE REPAIRED IAW Q400 SRM 51--21-00-350-801, SRM 51-14-00-350-804, NDTM PART 6, 51-00-02, SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600170Skin Panel · corrodedPDX: AFT CARGO BAY LOWER DECK SKIN PANEL HAS CORROSION AROUND SCREW HOLE AT FSX 755. MAINTENANCE REPAIRED IAW Q400 SRM 51-21-00-350-801, SRM 51-14-00-350-801, NDTM PART 6, 51-00-02, SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600169Skin · corrodedPDX: AFT CARGO BAY LOWER DECK SKIN PANEL HAS CORROSION AROUND SCREW HOLE AT FS X740. MAINTENANCE REPAIRED IAW SRM TASK 51-21-00-350-801, SRM 51-14-00-350-804, NDTM PART 6, 51-00-02, SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600168Skin · corrodedPDX: AFT CARGO BAY LOWER DECK SKIN TOPSIDE HAS CORROSION AROUND SCREW HOLT AT FSX 755, Z100 AND Y21 LT. MAINTENANCE REPAIRED IAW SRM TASK 51-21-00-350-801, SRM 551-14-00-350-804, NDTM PART 6, 51-00-02, SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600167Skin · corrodedPDX: AFT CARGO BAY LOWER DECK SKIN TOPSIDE HAS CORROSION AROUND 4 INCH PANEL APERTURE AT FSX 779, Z100 AND Y22 LT. MAINTENANCE REPAIRED IAW SRM TASK 51-21-00-350-801, SRM 51-14-00-350-804, NDTM PART 6, 51-00-02, SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600166Skin · corrodedPDX: AFT CARGO BAY LOWER DECK SKIN HAS CORROSION AROUND NUT PLATE UNDERSIDE AT FSX 783, Z100 AND Y20 LT. MAINTENANCE REPAIRED IAW Q400 SRM TASK 51-21-00-350-801, SRM 51-14-00-350-803, NDTM PART 6, 51-00-02, SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600160Skin · corrodedPDX: LT FUSELAGE SKIN HAS FRETTING CORROSION AROUND MOUNTING SCREW HOLES FOR LT STRAKE AT FSX 624. MAINTENANCE REPAIRED IAW RD 8/4-53-666, NDTM PART 6, 51-00-02, NDTM PART 6, 51-00-04, Q400 SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600159Skin · corrodedPDX: RT FUSELAGE SKIN HAS LIGHT FRETTING CORROSION AROUND MOUNTING SCREW HOLES (2) FOR RT STRAKE AT FSX 624. MAINTENANCE REPAIRED IAW RD 8/4-53-666, NDTM PART 1, 51-00-04, Q400 SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600153Unknown · unknownPDX: NDTM PART 6, 51-00-02, NDTM PART 1, 51-00-04. Q400 SRM 51-14-00, SRM 51-21-10 AND SRM 51-25-15.SDR QXEA200600144Skin · corrodedPDX: FOUND RT FUSELAGE SKIN HAS FRETTING CORROSION AROUND MOUNTING SCREW HOLES (2) FOR RT STRAKE AT FS X479. MAINTENANCE REPAIRED IAW RD 8/4-53-666, NDTM PART 6, 51-00-04, Q400 SRM 51-21-10 AND SRM 51-25-10.SDR QXEA200600143Skin · corrodedPDX: FOUND RT FUSELAGE SKIN HAS LIGHT FRETTING CORROSION AROUND MOUNTING SCREW HOLE (UPPER) FOR RT STRAKE AT FS X489. MAINTENANCE REPAIRED IAW RD 8/4-53-666, NDTM PART 6, 51-00-04, Q400 SRM 51-21-10 AND SRM 51-25-10.
Back to JASC 5330