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 USAA2014062600013Doubler · corrodedC3 CHECK LEVEL 2 GALVANIC CORROSION ON ANTENNA DOUBLER BETWEEN FRAME 21 TO 22 & BETWEEN STRINGER 27R TO 28R. REPAIRED ANTENNA DOUBLER BETWEEN FRAME 21 TO 22 & BETWEEN STRINGER 27R TO 28R SRM 53-10-01, 51-40-02 & 51-41-02.SDR ASAA2014061008327Skin · crackedFUSELAGE SKIN IS CRACKED AT R1 DOOR LOWER HINGE CUTOUT. ACFT GROUNDED. REPAIRED DAMAGE TO SKIN IAW EA AD 20140521-400-53-105.SDR SWAA2014061329036Skin · corrodedC2 DOOR CUT OUT SKIN EXTERNAL SURFACE CORRODED AT AFT LOWER CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2014061329035Skin · corrodedC2 DOOR CUT OUT SKIN EXTERNAL SURFACE CORRODED AT FWD LOWER CORNER. REPAIRED SKIN IAW SRM.SDR DALA14034595808Skin · damagedLIGHTNING STRIKE DAMAGE ON CROWN SKIN BS 780+80, STRINGER 4R. REPAIRED IAW ER/A 516342-14, REV A.SDR DALA14034585808Skin · damagedMAINTENANCE FOUND LIGHTNING STRIKE DAMAGE IN SEVERAL LOCATIONS ON THE CROWN SKIN OF FUSELAGE SEC 41 AND 42, REPAIRED IAW IAW ERA 516345-14.SDR DALA14034570666Skin · damagedFUSELAGE SKIN & BUTT SPLICE STRAP, BS 660 & S-28R, SHEARED FASTENER HEAD & CORROSION. REF ERA ER/A 516096-14, REV A.SDR DALA14034510665Skin · scratchedTWO SCRATCHES APPROXIMATELY 6 INCHES LONG, BELOW AFT LT SERVICE DOOR, CENTER OF DOOR BELOW SCUFF PLATE. BLENDED DAMAGE. SCRATCH REPAIR AREA .005 DEEP. WITHIN PERMANENT REPAIR LIMITS IAW SRM 53-00-01.SDR SWAA2014070229594Skin · crackedFUSELAGE SKIN CRACKED AT STATION 380, STRINGER 14L. REPAIRED SKIN IAW EA.SDR DALA2014062503770Skin · corrodedCORROSION ON WING TO FUSELAGE FAIRINGS RUB STRIP SETTLEMENT AREA RT FROM BS 1085 - 1134 BETWEEN LONGERONS 28-30R. ANCHOR NUTS WERE REMOVED. CORROSION REMOVED AND FOUND WITHIN LIMITS IAW SRM 53-4, PAR 57 B (2)(A) AND DWG 5936033.SDR DALA2014062503769Skin · corrodedCORROSION ON WING TO FUSELAGE FAIRINGS RUB STRIP SETTLEMENT AREA RT FROM BS 788-802 BETWEEN LONGERONS 28-29. ANOHER NUT AND FASTENERS WERE REMOVED, CORROSION REMOVED AND FOUND WITHIN LIMITS IAW SRM 53-4, PAR 57 B 2, A AND DWG 5936046, REV "A".SDR VGCA20140609001Skin · dentedFUSELAGE SKIN DENTED BETWEEN STATIONS 344 & 351 LT ABOVE STRINGER 19L.SDR SWAA2014061729135Doubler · crackedLEFT BULKHEAD CHORDS SKIN DOUBLER CRACKED AT BS 540, STRINGER 22L. REPAIRED DOUBLER IAW EA.SDR V0XD201406080130Skin · damagedDAMAGE TO SKIN & UNDERLYING STRUCTURE AROUND NLG BAY. ACCOMPLISHED REO 670-53-11-949 REV DATED 2014-06-08.SDR SWIA201438232Skin · crackedLEFT AFT LATCH CUT OUT IN THE TRU SKIN WAS FOUND CRACKED. C-CHECK, R & R LT FWD TRU BAY SKIN, DOOR LAND IAW SRM.SDR SWAA2014061729134Doubler · crackedRIGHT LOWER CHORD SKIN DOUBLER CRACKED AT BS 540. REPAIRED DOUBLER IAW EA.SDR SWAA2014061729133Doubler · crackedRIGHT LOWER CHORD SKIN DOUBLER CRACKED AT BS 540, STRINGER 22R. REPAIRED DOUBLER IAW EA.SDR CALA2014060991247Skin · dentedDENT IN EXTERNAL FUSELAGE SKIN AT BS 570 BETWEEN STRINGER 23L & 24L. REPAIRED EXTERNAL FUSELAGE SKIN AT BS 570 BETWEEN STRINGER 23L& 24L IAW SRM 53-00-01 FIG 201 REPAIR 3. MF4198 CREATED TO MONITOR. THIS A CAT B REPAIR ZONE A WITH MIN SKIN THICKNESS OF.040SDR REXA2014060300466Skin · damagedFOUND AN EXISTING BLEND TO THE FUSELAGE SKIN AT APPROXIMATELY FS 268 & STRINGER 23R MEASURING 1.295” X 0.935” X 0.008” DEEP. REPAIRED IAW EA CRJ253-02639.SDR ASOA20140608110Skin Splice · corrodedDURING C-CHECK, SKIN SPLICE CORRODED, BETWEEN FRAMES 13-14 STRINGERS 20R-20L. MAINTENANCE PERFORMED REPAIR ON SKIN SPLICE IAW SRM 53-00-02, FIG 201. ACFT APPROVED FOR RETURN TO SERVICE.SDR SWAA2014071029868Skin · crackedSKIN CRACKED AT BS 360, STRINGER 5R. REPAIRED SKIN IAW SRM.SDR SWAA2014071029867Skin · crackedSKIN CRACKED AT BS 360, STRINGER 7R. REPAIRED SKIN IAW SRM.SDR SWAA2014061729118Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STRINGER 5R TO 6R. REPAIRED SKIN IAW EA.SDR ASOA20140607109Skin · corrodedDURING C-CHECK THE FORWARD FUSELAGE II SKIN WAS FOUND TO BE CORRODED BETWEEN FRAMES 11-12 AND STRINGERS 20-21R. MAINTENANCE R & R THE SKIN IAW SRM 51-20-01. ACFT APPROVED FOR RETURN TO SERVICE.SDR FOTR20140806004Skin · damagedLOWER FUSELAGE AT AFT OF LT WING TO BODY FAIRING TOOL DAMAGE. REPAIRED ON FAS WO N455KA-01-01, NR 64096.SDR SWAA2014071029866Skin · crackedSKIN CRACKED AT BS 908+6, STRINGER 10L. REPAIRED SKIN IAW EO & EA.SDR SWAA2014070729665Skin · crackedSKIN CRACKED AT BS 328+3, STRINGER 4L. REPAIRED SKIN IAW SRM.SDR SWAA2014070729664Skin · crackedSKIN CRACKED AT BS 277+10, STRINGER 4L. REPAIRED SKIN IAW SRM.SDR SWAA2014070729663Skin · crackedSKIN CRACKED AT BS 277+2, STRINGER 4L. REPAIRED SKIN IAW SRM.SDR SWAA2014070729668Skin · crackedR2 DOOR SKIN CUT OUT CRACKED AT FWD LOWER CORNER FROM FASTENER HOLE. REPAIRED SKIN IAW EA.SDR SWAA2014070229588Skin · crackedFUSELAGE SKIN CRACKED AT STATION 947.5+14, STRINGER 17R. REPAIRED SKIN IAW EA.SDR U2RA201406060012Skin · crackedDURING HFEC OPEN HOLE INSPECTION ON AFT CARGO DOOR CUT OUT UPPER FWD CORNER AT HINGE AREA LOWER HOLE NR 1 SKIN FOUND CRACKED. CRACK LENGTH 1 INCH. INSPECTION CARRIED OUT IAW AD 2003-10-06, SB 747-53A2448 REVISION 1 DATED 4/4/2002.SDR FDEA201406061323Skin · damagedEXTERNAL LOWER SKIN BETWEEN BS 1306 - 1310, STRINGERS 29 - 30R HAD THREE NICKS WITH PREVIOUS BLEND. BLENDED IAW EA F-5330-T0308052.SDR DALA14034273710Skin · damagedDURING INSPECTION, FOUND DAMAGE BETWEEN BS 440 - 500H, S24-26L. MAINTENANCE REPAIRED IAW ERA 515868.SDR DALA14034163230Skin · dentedDURING INSPECTION, FOUND DENT ON EXTERNAL SKIN FRAME 78+12" AND BETWEEN S1-2L UPPER FUSELAGE TAIL CONE. REPAIRED IAW SRM A32053-51-11, FIG 203.SDR DALA14034125808Skin · damagedLIGHTNING STRIKE DAMAGE. REPAIRES IAW ER/A 516343-14.SDR DALA14034115808Skin · damagedMAINTENANCE FOUND SEVERAL LIGHTNING STRIKE DAMAGE LOCATIONS ON THE CROWN OF THE FUSELAGE SECTION 41 & 43. REF ER/A 516339-14, REV A.SDR DALA14034105808Skin · damagedMAINTENANCE FOUND SEVERAL LIGHTNING STRIKE DAMAGE LOCATIONS ON THE CROWN SKIN OF FUSELAGE SECTION 41-43. REF ERA ER/A 516344-14, REV A. REFER TO LOGPAGE 1472527 FOR ALL FOLLOW ON ACTION.SDR AALA20140606020Skin · corrodedCORROSION ON INNER SKIN AT STATION 1090 BETWEEN STRINGERS 38 & 39 LT. INNER SKIN WAS REPAIRED IAW EA B767-53-035186.SDR SWAA2014070829747Skin · crackedSKIN CRACKED AT BS 787+16, STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2014070829734Skin · crackedSKIN CRACKED AT BS 787+2.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2014070829704Skin · crackedSKIN CRACKED AT BS 787+16.5, STRINGER 20L. REPAIRED SKIN IAW EA.SDR SWAA2014070729662Skin · crackedSKIN CRACKED AT BS 360+15, STRINGER 8L. REPAIRED SKIN IAW EA.SDR SWAA2014070729661Skin · crackedSKIN CRACKED AT BS 344+2, STRINGER 2L. REPAIRED SKIN IAW EA.SDR SWAA2014070729660Skin · crackedSKIN CRACKED AT BS 827+4, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2014070329608Skin · crackedFUSELAGE SKIN CRACKED AT STATION 787+16, STRINGER 22R. REPAIRED SKIN IAW SRM.SDR SWAA2014070329607Skin · crackedFUSELAGE SKIN CRACKED AT STATION 847+15, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR VGCA20140605001Skin · damagedSUSPECTED LIGHTNING STRIKE ON RIVET AT STATION 680, STRINGER 3L RESULTING IN FUSELAGE SKIN DAMAGE.SDR SWIA201438242Skin · dentedDENT FOUND LT SIDE OF ACFT SKIN, AFT AND BELOW BAGGAGE DOOR, BS 589, S22-23L. C-CHECK, REPAIRED IAW SRM.SDR SWIA201438241Skin · dentedDENT FOUND LT SIDE OF ACFT SKIN BS 682, S19-20L, C-CHECK, REPAIRED IAW EA.
Back to JASC 5330