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 SWAA120730Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT LOWER CORNER. REPAIRED SKIN IAW SRM.SDR SWAA120559Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 500B+14 TO BS 500B+18, STR 1L. REPAIRED SKIN IAW ER.SDR FDEA201201250334Skin · corrodedCORROSION FOUND ON FUSELAGE SKIN AT STA 1119. REPAIRED SKIN IAW SRM 53-20-00, FIG 6 SHEET 5 AND 6. MAJOR REPAIR.SDR AALA20120125TUL02Skin · dentedACCIDENTAL IMPACT TO FUSELAGE SKIN AT STATION 229 LONGERON 18 LEFT. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-04-05 AND EA MD80-53-021414.SDR A6WA201240235Skin · chafedLEFT FUSELAGE SKIN BEHIND LT STAB FAIRING IS CHAFED FOUND AREA TO BE OUT OF LIMITS IAW REO 601R-53-41-341. BLENDED CHAFED AREA ON LT SKIN BEHIND LT STUB FAIRING. REPAIR AREA LT FUSELAGE SKIN BEHIND LT STUB FAIRING IAW REO 601R-53-41-341, REV C.SDR FOTR0301201233119Skin · dentedEXTERNAL FUSELAGE SKIN HAS 2 DENTS AT STA 1630 STR 18L AND STA 1650 STR 19L.SDR SWAA2012021301355Skin · crackedCRACK ON EXTERNAL FUSELAGE WINDOW SKIN AT BS 211.8, STR 9L. REPAIRED SKIN IAW SRM.SDR SWAA1201182Skin · crackedCRACK ON FUSELAGE SKIN AFT OF PILOT'S NR 3 WINDOW APPROX BS 262 RIGHT ABOVE STRINGER 10L. REMOVED AND REPLACED SKIN IAW SRM AND BAC DWG.SDR SWAA1201181Skin · crackedCRACK ON FUSELAGE SKIN AFT OF CO-PILOT'S NR 3 WINDOW. REPAIRED SKIN IAW SRM AND BAC DWG.SDR SWAA1201180Skin · crackedFUSELAGE SKIN CRACKED AFT OF PILOT'S NR 1 WINDOW. REPAIRED SKIN PER SRM AND BAC DWG.SDR NSVA2011420Skin · misrepairedPREVIOUS REPAIR TO LT FUSELAGE AT STA 630.112 TO 640 SL 1524-1526 NOT DONE IAW PRINCIPLES OF SRM OR SAAB STATEMENT 340SDS011466. UPSIZED PERIPHERY STRUCTURE ROWS AND INSTALLED FIELD RIVETS. COMPLETED TD 340-53-11-32 AND JC 51-00-00S.SDR SWIA201229388Skin · damagedDAMAGE TO FUSELAGE SKINS ON RIGHT AFT OF THE LOW AIR PRESSURE ACCESS DOOR. (SERVICE) REPAIRED FUSELAGE SKIN ON THE RIGHT AFT OF THE LOW AIR PRESSURE ACCESS DOOR.SDR SIMA201202501Skin · damagedON FLIGHT 3376 THE CREW REPORTED A LIGHTING STRIKE. THE CREW DIVERTED TO LIT AND LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS REMOVED FROM SERVICE. PERFORMED LIGHTNING STRIKE INSPECTION IAW WC 05-200-00. PERFORMED PERMANENT REPAIR TO 12 EACH LIGHTNING STRIKE SDR AALA20120124TUL03Skin · dentedDENT WITH GOUGE RIGHT SIDE FUSELAGE BETWEEN 500C AND 500D BELOW STRINGER 22 RIGHT. INSTALLED EXTERNAL REPAIR DOUBLER PER SRM 53-00-01-2R REPAIR 3.SDR DALA1203490139Skin · crackedM/D L1 DOOR AFT CUTOUT LWR CORNER SKIN CRACKED. THE SKIN REPAIR AS PER B767-300 SRM 53-10-01 REPAIR 1 FIG 201 CAT B REPAIR.SDR DALA1203179210Skin · crackedDURING PSV VISIT FOUND CRACK FROM FASTENER HOLE ON SKIN AT STATION 1475 LBL 10. REPAIR DOUBLER ACCOMPLISHED PER ERA 499457-14.SDR SWAA120549Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 328 TO BS 360, BETWEEN STR 14L TO STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA120545Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 747+12, STR 21L. REPAIRED SKIN IAW EA.SDR A6WA201240220Skin · crackedCRACK IN NLG CUT OUT REQUIRED REO 601R-53-11-048, REV C.SDR SWAA2012021401450Skin · crackedSKIN CRACKED AT BS 473, STR 16R. REPAIRED SKIN PER ER AND EA.SDR QXEA2012012600087Skin · corrodedINTERIOR SKIN DOUBLER AND ASSOCIATED PIECES ARE CORRODED BETWEEN STA 19.4-32.4 AND STR 33-32S. ACFT IS DOWN FOR C-CHECK. REMOVED FWD LAV DOUBLER AND NUTPLATES IAW SRM 51-42-05-02-01. INSTALLED SKIN DOUBLER AND NUT ASSEMBLIES IAW SRM 51-42-05-02-01. PRIMED,SDR RYNA201201230007Skin · corrodedAFT CARGO COMPARTMENT, STA 1130 BL 0.0 SKIN CORROSION. REMOVED AREA OF CORROSION AT STA 1100 PER AMM 51-10-02, TYPICAL EXTERNAL DOUBLER REPAIR REQUIRED. CARRIED OUT EXTERNAL DOUBLER REPAIR IAW 767 SRM 53-00-01. APPLIED DECORATIVE FINISH ON EXTERNAL REPAIR DSDR AALA20120123TUL12Skin · scratchedDEEP SCRATCHES ON FUSELAGE SKIN FROM STATIONS 864 AND 869, BETWEEN STRINGERS 26 LEFT AND RIGHT. INSTALLED DOUBLER REPAIR PER EA B737-53-021431.SDR SWAA120537Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 312 TO BS 337, BETWEEN STR 15R TO STR 18R. REPAIRED SKIN IAW SRM.SDR SWAA120532Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED AT BS 379, STR 28L. REPAIRED SKIN IAW EA.SDR SWAA120526Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND LT FUSELAGE SKIN CRACKED AT BS 213.8 WINDSHIELD UPPER AREA. REPAIRED SKIN IAW EA.SDR SWAA120525Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED AT BS 961, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA120519Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 947.5 TO BS 969, BETWEEN STR 15L TO STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA120505Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 947.5 TO BS 980, BETWEEN STR 15R TO STR 19R. REPAIRED SKIN IAW SRM.SDR SWAA120504Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 420+10, UPPER FWD CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120503Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 500A+10, LOWER AFT CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120502Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 420+10, LOWER AFT CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120501Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 400+10, LOWER AFT CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120500Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CRACKED AT BS 440+10, UPPER FWD CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120499Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 500B+10, LOWER AFT CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120498Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 500A+10, LOWER AFT CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120497Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 500+10, LOWER AFT CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120496Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 480+10, LOWER AFT CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120495Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 460+10, LOWER AFT CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120494Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 420+10, LOWER AFT CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120493Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 500B+10, UPPER FWD CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA120492Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 400+10, UPPER FWD CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR AALA20120123TUL01Skin · damagedDENT AT STATION 249 LONGERON 20 RIGHT. INSTALLED REPAIR DOUBLER PER SRM 53-04-02.SDR AALA20120123AFW01Skin · damagedACCIDENTAL IMPACT FROM STATIONS 788 TO 804 STRINGER 35 TO 36 RIGHT. INSTALLED DOUBLER REPAIR PER SRM 53-00-01.SDR SWAA120473Skin · crackedDURING SCHEDULED OTS CHECK, FOUND R1 DOOR FUSELAGE SKIN CRACKED AT BS 302.5, STR 7R UPPER FWD CORNER. REPAIRED SKIN IAW ER AND EA.SDR ABXR2012012300011Skin · corrodedDURING INSP FOUND INTERNAL FUSELAGE SKIN CORRODED AT STA 960, S19R. REPAIRED IAW REA 46963REA06 AND 46963REA09.SDR ABXR2012012300010Skin · corrodedDURING C-CHECK FOUND SKIN CORRODED AFT OF FAILSFE COMMON TO TRIM OUT. REPAIRED CORROSION IAW REA 46963REA04 AND 46963REA08.SDR A6WA201240225Skin · damagedTEMPOARY REPAIR TO FUSELAGE SKIN BETWEEN FS 589 & 605 BETWEEN STR 21R-26R MULTIPLE DAMAGE CAUSED BY GROUND AIR DOOR. REPAIRED IAW REO 601R-53-61-4359, REV A.SDR PCSA2012012201Skin · damagedFUSELAGE SKIN DAMAGE AT BS 1373 BETWEEN S19 AND 20 LEFT.SDR R61A20120047Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE WASTE SERVICE PANEL HAS CORROSION LEFT FORWARD EDGE. MAINTENANCE REMOVED AND REPLACED CORRODED DOUBLER ON FORWARD EDGE OF WASTE SERVICE BOX IAW EMB SRM 51-43-04, 51-23-05, AND 51-23-06. THE AIRCRAFT IS
Back to JASC 5330