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 ASOA2014040410294Skin · damagedLIGHTNING STRIKE AFT OF BS 589 S25L. REPAIRED IAW REO 601R-53-00-567, REPAIR I. MAJOR REPAIR.SDR ASOA2014040410293Skin · damagedLIGHTNING STRIKE AT BS 349 S25L. REPAIRED IAW REO 601R-53-00-567, REPAIR D. MAJOR REPAIR.SDR ASOA2014040410292Skin · damagedLIGHTNING STRIKE BETWEEN BS 265 AND 280, BETWEEN S25-26L. COMPLIED WITH REO 601R-53-00-267. MAJOR REPAIR.SDR ASOA2014040410291Skin · damagedLIGHTNING DAMAGE AT LOCATION BETWEEN BS 250 AND 265, S26L. COMPLIED WITH REO 601R-53-00-267. MAJOR REPAIR.SDR ASOA2014040410290Skin · damagedLIGHTNING STRIKE AT BS 169.5 TO LT CENTERLINE. COMPLIED WITH REO 601R-53-00-567. MAJOR REPAIR.SDR AALA20140401002Skin · damagedFUSELAGE SKIN DAMAGED FROM BS 1390 - 1480 BETWEEN STRINGERS 27 & 28 RT. INSTALLED EXTERNAL REPAIR IAW EA B767-53-034141.SDR DALA14020243149Skin · dentedDURING MAJOR CHECK, TWO DENTS WERE FOUND ON OUTER SKIN PANEL BETWEEN FRAMES 21-24 AND STRINGERS 22 - 25 LT. DAMAGED AREA TRIMMED AND REPAIR ACCOMPLISHED IAW ERA 524166-14, SECTION.SDR FDEA201404010609Skin · corrodedFOUND CORROSION RUNNING UNDER THE LAP SEAM AT STRINGER 19L & TOOL DAMAGE FROM BS 737 - 769. SKIN REPAIRED BS 720 - 780, IAW EA 57-5331-16-F 4458.SDR DALA2017041102985Filler · corrodedCORROSION AT AFT LAV SERVICE PANEL FWD EDGE ONLY FILLER CORRODED AND REPLACED. ALSO REPLACED LEFT HINGE ATTACHED TO SERVICE DOOR ACTUATOR.SDR SWAA2014042127254Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED SKIN IAW ER.SDR SWAA2014041727196Post · crackedLEFT NR 3 WINDOW FRAME AT E F POST 2ND FASTENER FROM BOTTOM CRACKED. REPAIRED POST IAW MM & ACO.SDR SWAA2014040726862Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 482B+3.5' TO BS 482B+7, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2014040726861Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 482A+14.5' TO BS 482A+16, STRINGER 8L. REPAIRED SKIN IAW EA.SDR CALA2014040390760Skin · dentedREF PREVIOUSLY ARCHIVED DENT CF9088, DAMAGED SKIN CUT OUT & A DOUBLER REPAIR INSTALLED IAW SRM 53-00-01, RPR 3 IAW SRM TABLE V, THIS IS A CAT B REPAIR IN ZONE A WHERE THINNEST ORIGINAL SKIN THICKNESS IS .049.SDR DALA14020200656Skin · damagedDAMAGED SKIN, BS 1805, S26L. INSTALLED REPAIR IAW SRM 53-00-01.SDR AALA20140331005Skin · damagedAIRCRAFT DAMAGED BELOW STRINGER 4 RT STATION 1113. INSTALLED DOUBLER WITH BLIND FASTENERS IAW EA B737-53-034237.SDR DALA14020111804Skin · crackedCRACK FOUND IN SKIN AT BS 1654.5, APPROXIMATELY TWO INCHES BELOW S3R. REMOVED DAMAGED SKIN IAW SRM 53-80-01. REPAIR 4, COMPLIED WITH HFEC INSPECTION IAW SRM 53-80-01, REPAIR 4, NO CRACKS FOUND. FABRICATRED AND INSTALLED REPAIR IAW SRM 53-80-01, REPAIR 4, FIGSDR DALA14020101804Skin · crackedCRACK FOUND ON SKIN AT BS 1654.5, APPROXIMATELY TWO INCHES BELOW STR 3L. REMOVED DAMAGE IAW SRM 53-80-01, REPAIR 4 PG 203(399410) HFEC INSPECTION IAW SRM 53-80-01 REPAIR 4, NO CRACKS FOUND. REPAIRED IAW SRM 53-80-01, REPAIR 4, FIG 201.SDR P5CA2014040100011Skin · crackedBS 983, STR 38L, AT DRAG SPLICE FITTING AREA FOUND ONE FASTENER HOLE, FOUND A CRACK IN SKIN. SKIN REPAIRED IAW SRM 53-20-01-2R2 REPAIR 2, FIG 201.SDR CALA2014033190730Skin · dentedDENT IN EXTERNAL FUSELAGE SKIN REPAIR BS 1689, STRINGER 20L. EVALUATED DENT, A - Y MEASURED 66 & IS OUT OF LIMITS IAW SRM 53000-01 FIG 101. REPAIRED AREA IAW ECRA 5361-01 071. THE BS 1675 - 1705, STRINGER 19L - 22L.SDR SPUY201403310031Skin · corrodedLOWER FUSELAGE INNER SKIN SHOWS CORROSION BETWEEN BS 680-700, STRINGER 28 LT.SDR IPXA2014090284111Skin · damagedINSPECTION 3C, BELLY SKIN BS 1309 BETWEEN L48-49R HAS NINE LIGHTNING STRIKE DISCHARGE DAMAGE AREAS. REPAIRED IAW EA011-5330-01-A5297, REV I/R AND UPS EO 5330-54784-A.SDR SIMA20140330023Skin · damagedMULTIPLE HAIL DAMAGE EVENT, REPLACE CTR FUSELAGE SKIN. R & R LT CTR FUSELAGE SKIN IAW SRM 51-40-02 & ETN-EM-53-262.SDR SIMA20140330022Skin · damagedMULTIPLE HAIL DAMAGE EVENT, REPLACE RT CTR FUSELAGE SKIN. R & R RT CTR FUSELAGE SKIN IAW SRM 51-40-02 & ETN-EM-53-262.SDR SWAA2014042827381Skin · crackedSKIN CRACKED AT BS 328.1, STRINGER 17R. REPAIRED SKIN IAW SRM & EA.SDR SIMA20140330009Skin · damagedMULTIPLE HAIL DAMAGE EVENT REPLACE LT FWD FUSELAGE I SKIN. R & R LT FWD FUSELAGE I SKIN IAW SRM 51-40-02 & AEA ETN-EM-53-235.SDR SIMA20140330017Skin · damagedMULTIPLE HAIL DAMAGE EVENT, REPLACE CTR FUSELAGE II TOP SKIN. R & R CTR FUSELAGE II TOP SKIN IAW SRM 51-40-02 & AEA ETN-EM-53-263.SDR SWAA2014041427093Skin · crackedL1 DOOR SKIN CUT OUT LOWER AFT CORNER UNDER THRESHOLD PLATE CRACKED AT BS 348. REPAIRED SKIN IAW EA & SWA EA.SDR CALA2014040100417Skin · dentedEXTERNAL SKIN DOUBLER BETWEEN BS 592 & 612, BETWEEN STRINGERS 16 & 17L HAS SEVERAL DENTS. REPLACED DOUBLER IAW ECRA 5331-01847.SDR ASOA20140330052Skin · crackedDURING MAINTENANCE INSPECTION, THE TEE POST BETWEEN THE F/O'S WINDSHIELD AND DV WINDOW WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED THE DAMAGE AND PERFORMED A DOUBLER/FILLER REPAIR IAW DISPOSITION ETD2014-145-026772 AND THE ACFT WAS APPROVED FOR RETURN TO SERSDR CALA2014033190732Skin · dentedFUSELAGE HAS DENT APPROXIMATELY 4FT FWD OF OUTFLOW VLV. =1 & Y=.047 & DENT IS IN MIDDLE OF BAY NOT AFFECTING INTERNAL STRUCTURE & SMOOTH. CUT OUT DAMAGED SKIN AT BS 1585 LT, BETWEEN STRINGER 22L TO STRINGER 23L. FABRICATED & INSTALLED A REPAIR DOUBLER IAW SSDR SWAA2014040726863Skin · crackedFUSELAGE SKIN CRACKED AT BS 400, STRINGER 14R. REPAIRED SKIN IAW EA.SDR CALA2014040100415Skin · gougedEXTERNAL SKIN GOUGED AT BS 758 STRINGER 16L. DOUBLER INSTALLED IAW ECRA 5331-01846.SDR CALA2014040100413Skin · dentedDENT IN LOWER LT FUSELAGE BETWEEN STRINGERS 26 - 27L BS 510. FOUND TO BE WITHIN SRM 53-00-01 LIMITS. ACCOMPLISHED DOUBLER REPAIR BETWEEN BS 503 - 513 & STRINGERS 26 - 28L IAW ECRA 5331-01843.SDR DALA14020305805Skin · dentedLEFT EXTERIOR FUSELAGE HAS A SHARP DENT AT BS 614 AND BETWEEN STRINGERS 16 - 17L. DENT TRIMMED OUT IAW SRM 53-00-01 FIG 201, REPAIR 3. REPAIRED IAW SRM 53-00-01.SDR REXA2014040200040Skin · corrodedCORROSION TO THE LOWER SKIN PANEL. REPAIRED IAW EA CRJ253-02383.SDR EE4Y201403290055Skin Panel · crackedLOWER FUSELAGE AT BS 540 BETWEEN STRINGER 22 RT & 23 RT EXTERNAL SKIN WITH TWO EACH CRACKS COMMON TO FASTENER HOLES. DETECTED WITH HFEC INSPECTION.SDR SWIA201437040Skin · corrodedAFT CARGO BAY, BELOW FLOOR 281KLF, SKIN CORRODED AROUND NUTPLATE, C-CHECK. REPAIRED CORRODED SKIN IAW REO.SDR DALA14020091814Skin · chafedLEFT HORIZONTAL STABILIZER LOWER SEAL, FORWARD FUSELAGE CUTOUT SKIN PLATE FOUND CHAFED WAS WORN AT BS 1738. REPAIRED IAW ARM 53-80-01, FIG 201, REPAIR 3.SDR DALA14019770680Skin · crackedWHILE PERFORMING NDT INSPECTION OF L1 DOOR CUTOUT IAW TC 5331-01232-02A, HFEC INSPECTION SHOWED TWO CRACKS IN THE BEARSTRAP LAYER. COMPLIED TC 5331-01232-02G. INSTALLED A DOUBLER AND TRIPLER.SDR DALA14019760680Skin · debondedSKIN AND BEARSTRAP DISBONDED AT L1 DOOR CUT-OUT. REPAIR IN AREA OF DAMAGE ROUT-OUT. C/W ERA 524559-14AD, REV ORIGINAL.SDR SWAA2014042827410Post · crackedRIGHT NR 3 FLIGHT DECK WINDOW E - F POST FOUND SECOND HOLE FROM THE BOTTOM CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014042827409Post · crackedLEFT NR 3 FLIGHT DECK WINDOW E - F POST FOUND SECOND HOLE FROM THE BOTTOM CRACKED. REPAIRED POST IAW ACO.SDR SWAA2014041427137Skin · crackedSKIN CRACKED AT BS 348, BETWEEN STRINGER 13L TO STRINGER 14L. REPAIRED SKIN IAW EA.SDR WX0A071894Skin · corrodedEXTERIOR FUSELAGE SKIN CORRODED AT STATION 826 LONGERON 29R. REMOVED DAMAGE AREA, FABRICATED REPAIR PARTS & INSTALLED IAW SRM 53-04 FIG 57.SDR DALA14019446308Skin · damagedDURING NON ROUTINE CHECK, HOLE IN FUSELAGE AT BS 330, STRINGER 25 LT. DAMAGE FOUND DURING WALK AROUND, APPLIED TEMPORARY REPAIR IAW SRM 53-10, FIG 10.SDR FDEA201403260582Skin · dentedRIGHT LOWER FUSELAGE SKIN DAMAGED. REPAIRED IAW SRM 53-00-01 REPAIR 1.SDR SWAA2014041427116Skin · crackedSKIN CRACKED AT BS 500C + 16, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014041427115Skin · crackedSKIN CRACKED AT BS 380, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014041427097Skin · crackedSKIN CRACKED AT BS 500D, STRINGER 14R. REPAIRED SKIN IAW EA.
Back to JASC 5330