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 SWAA2015030237037Skin · crackedFUSELAGE SKIN CRACKED AT BS 500+3, STRINGER 18R. REPAIRED SKIN IAW EA.SDR FDEA201502210567Skin · corrodedBS 1219, RBL 48 SKIN PANEL FWD OF CTR WING TANK HAS CORROSION. REPAIRED IAW EA 8-5710-T0315698.SDR VNAA2015022100017Skin · damaged1 RIVET HAS A MARK AT FS 235.0 AT RBL 26, REPAIRED IAW REO 670-53-11-1016.SDR DALA2015022201559Skin · corrodedCORROSION ON SEATING AREA OF RUBSTRIP ON STA Y= 1079 TO 1117 BETWEEN LONGERON 27LT TO 30. REWORKED AREA WAS TREATED AND PAINTED, CIC WAS APPLIED IAW SRM 51-30-5, 51-10-3, P 26, 21, 14, 38, 53-04 P.57 .SDR DALA2015022201554Skin · crackedCRACK ON SKIN STA 1638, AT S-14R. REPAIR COMPLETED IAW SRM 53-00-01, FIG 101.SDR SIMA20150220017Skin Panel · dentedREPLACE FWD FUSELAGE I RT SKIN PANEL. R & R RT FWD FUSELAGE I SKIN PN 54051-003 IAW SRM 51-40-02, 51-20-01, 51-40-03,51-40-06, 53-11-01-SI, ETN-EM-51-118 & ETN-EM-53-235.SDR SIMA20150220016Skin · damagedREPLACE FWD FUSELAGE II SKIN. R & R FWD FUSELAGE II WIPER PANEL IAW SRM 53-12-01SI, 51-40-02, 51-40-03, 51-20-01, 51-20-03, 51-40-06, ETN-EM-53-206 & ETN-EM-51-118.SDR SIMA20150220015Skin · damagedREPLACE CTR FUSELAGE I RT SKIN. R & R RT CTR FUSELAGE I SKIN IAW SRM 53-24-01-SI, 51-20-03, 51-20-01, 51-40--02, 51-40-03, 51-40-06, ETN-EM-51-118 & ETN-EM-53-262.SDR SWIA201540889Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS409.00+90 AT STR 25R. C-CHECK, LIGHTNING STRIKE ON FUSELAGE AT FS409.00+90 AT STR 25R IAW REO.SDR SWIA201540888Skin · damagedLIGHTING STRIKE ON FUSELAGE AT FS 409.00+65.5 AT STR23R. C-CHECK, REPAIRED LIGHTNING STRIKE ON FUSELAGE AT FS 409.00+65.5 AT STR 23R IAW REO.SDR SWIA201540887Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS 409.00+47.5 AT STR 17R. C-CHECK, REPAIRED LIGHTNING STRIKE ON FUSELAGE AT FS 409.00 +47.5 AT STR 17R IAW REO.SDR SWIA201540886Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS 409.00+29 AT STR18R. C-CHECK, REPAIRED LIGHTNING STRIKE ON FUSELAGE AT FS409.00+29 AT STR 18R IAW REO.SDR SWIA201540885Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS310.00 AT STR 26R. C-CHECK, REPAIRED LIGHTNING STRIKE ON FUSELAGE AT FS 310.00 AT STR 26R REO.SDR SWIA201540884Skin · damagedLIGHTING STRIKE ON FUSELAGE AT FS 286.00 AT STR 24R. C-CHECK, R & R RIVET WITH LIGHTING STRIKE ON FUSELAGE AT FS286.00 AT STR 24R IAW REO.SDR SWIA201540883Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS279.00 AT STR 24R. C-CHECK, R & R RIVET WITH LIGHTNING STRIKE ON FUSELAGE AT FS 279.00 AT STR 24R IAW REO.SDR SWIA201540882Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS 249.00 AT STR 26R. C-CHECK, REPAIRED LIGHTNING STRIKE ON FUSELAGE AT FS 249.00 AT STR 26R IAW REO.SDR SWIA201540876Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS259.00 AT STR 26R. C-CHECK, REPAIRED LIGHTNING STRIKE ON FUSELAGE AT FS 259.00 AND STRINGER 26R IAW REO.SDR SWIA201540864Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS 409.00+67 AT STR 23R. C-CHECK, BLENDED LIGHTNING STRIKE ON FUSELAGE AT FS 409.00+67 AT STR 23R AND REPLACED RIVET IAW REO.SDR SWIA201540863Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS 409.00+35 AT STR 23R. C-CHECK, BLENDED LIGHTNING STRIKE ON FUSELAGE AND REPLACED RIVET AT FS 409.00+35 AT STR 23R IAW REO.SDR SWIA201540862Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS409.00+8 AT STR23R. C-CHECK, BLENDED LIGHTNING STRIKE ON FUSELAGE AT FS 409.00+8 AND REPLACED RIVET AT STR 23R IAW REO.SDR SWIA201540861Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS 387.00 AT STR 24R. C-CHECK, BLENDED LIGHTNING STRIKE ON FUSELAGE AND REPLACED RIVET AT FS 387.00 AT STR 24R IAW REO.SDR SWIA201540860Skin · damagedLIGHTNING STRIKE ON FUSELAGE AT FS 310.00 AT STR24R. C-CHECK, R & R RIVET WITH LIGHTING STRIKE ON FUSELAGE AT FS310.00 AT STR 24R IAW REO.SDR SWIA201540830Skin · dentedDENT AT LT FUSELAGE SKIN PANEL FWD OF FS 394.0 AND WITHIN 0.047" CHEM-MILL POCKET AREA BETWEEN STR 20L AND STR 21L. C-CHECK, RO: 03/09/2015, REPAIRED DENT AT LT FUSELAGE SKIN PANEL FWD OF FS 394.0 AND BETWEEN STR 20L AND 21L IAW STS EA.SDR SWIA201540813Skin · chafedFUSELAGE CHAFED FROM FAIRING AT BS 977 AT STR 27. C-CHECK BLENDED OUT THE CHAFE ON FUSELAGE IN FS 977 AREA, STR 27 IAW REO.SDR SWAA2015031037300Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 913.5 TO 914, STRINGER 10L. REPAIRED SKIN IAW ER & EA.SDR SWAA2015031037299Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 790 TO 792, STRINGER 18L. REPAIRED SKIN IAW ER & EA.SDR SWAA2015030937220Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 810 TO 812, STRINGER 19L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2015030937219Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 831 TO 832, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2015030537133Skin · crackedSKIN CRACKED BETWEEN BS 820.5 TO 821.5, STRINGER 19L. REPAIRED SKIN IAW SRM.SDR FDEA201502200559Skin · dentedSKIN DENTED AT BS 1618 BETWEEN STRINGERS 17L & 18L. FOUND TO BE OUT OF LIMITS. REPAIRED AREA IAW EA F-5330-T0315612 REV PS P1. CUTOUT, FABRICATED, AND INSTALLED A REPAIR DOUBLER.SDR BJNA2015FA0000084Skin · dentedFOUND DAMAGE TO FUSELAGE SKIN FORWARD OF THE FWD LWR CARGO DOOR BELOW SKIN SPLICE.SDR DALA2015030201789Skin · damagedER/A 523500-14, REV A, FUSELAGE, SKIN AT FS 500-522, S-27L, TOS-27R, ATG4 FORWARD ANTENNA, EXISTING REPAIR, INTERFERENCE,SUPPLEMENTAL INSPECTIONS. ER/A 523500-14, REV A, AT OR PRIOR TO 44,352 TOTAL FLIGHT CYCLES AND REPETITIVELY EVERY 4,798 FLIGHT CYCLES THESDR SWAA2015030237002Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 749.5 TO 751, STRINGER 19L. REPAIRED SKIN IAW SRM.SDR SWAA2015030136977Skin · crackedLOWER BULKHEAD CHORD SKIN CRACKED AT BS 540, STRINGER 22L, ON UPPER AFT HOLE 1 INCH BELOW. REPAIRED SKIN IAW ACO.SDR SWAA2015030136976Skin · crackedLOWER BULKHEAD CHORD SKIN CRACKED AT BS 540, STRINGER 22L, ON AFT HOLE 3 INCHES BELOW. REPAIRED SKIN IAW ACO.SDR SWAA2015030136975Skin · crackedLOWER BULKHEAD CHORD SKIN CRACKED AT BS 540, STRINGER 22R, AFT HOLE 3 INCHES BELOW. REPAIRED SKIN IAW ACO.SDR SWAA2015030136978Skin · crackedLOWER BULKHEAD CHORD SKIN CRACKED AT BS 540, STRINGER 22L, ON UPPER FWD HOLE 1 INCH BELOW. REPAIRED SKIN IAW ACO.SDR DALA2015022701746Skin · corrodedAFT CARGO EXTERIOR SKIN AT STA 1470, RBL 6 HAS CORROSION AT ANTENNA LOCATION. CUT OUT DAMAGE, FABRICATED AND INSTALLED DOUBLER ON SKIN AT STA 1470, RBL 6 AT ANTENNA LOCATION IAW SRM.SDR DALA2015022601650Skin · crackedFUSELAGE SKIN, BS 1395-1376, LONGERON L10 - 11R CRACKED. REPAIRD IAW ERA 523447-14A.SDR DALA2015022301593Skin · corrodedDURING PSV-14, MAINTENANCE VISIT, AFTER REMOVING THE NATS AIRPHONE ANTENNA AT BS 757 & BL0, IAW EA 12-090911-14, REV C, CORROSION WAS DISCOVERED ON THE OUTER SURFACE OF THE SKIN PANEL, P/N 146A3231-19, AROUND THE COAX CUTOUT. MAINTENANCE REPAIRED IAW ERA 511SDR DALA2015022201560Skin · corrodedCORROSION ON SEATING AREA OF RUBSTRIP BETWEEN STA Y= 750 TO 826, LONG 25LT TO 30. FASTENERS WAS REMOVE CORROSION WAS REMOVE, MEASURE, APPLY ALODINE, PRIMER AND CIC IAW SRM 51-30-5, 51-10-3 PAR 26, 21, 14 AND 38, 53-04, PAR 57. JOB COMPLETED.SDR DALA2015022201555Skin · unknownREPAIR DOUBLER BENEATH RUBSTRIPS AT FILLET PANELS AREA FROM STAY= 758 TO 778 BETWEEN LONGERONS 29RT AND 27RT. REPAIR DOUBLER WAS REPLACED IAW ER/A 330196-14, REV "C".SDR DALA2015022101523Skin · corrodedPITTING CORROSION ON EXTERNAL FUSELAGE SKIN BENEATH RUBSTRIPS FILLET PANELS FROM STA Y=1079 TO Y=1136 BETWEEN LONGERON 24 AND 30 RT. AREA WAS BLENDED OUT, MEASURED, TREATED, AND PAINTED AND CIC WAS APPLIED IAW SRM 51-10-3 AND 53-04, PAR 57. MEASURE REWORKED SDR DALA2015022101521Skin · corrodedPITTING CORROSION ON EXTERNAL FUSELAGE SKIN REPAIR DOUBLER BENEATH RUBSTRIPS AT FILLET PANELS AREA FROM STA Y= 758 -778 BETWEEN LONGERONS 29RT AND 27RT. REPAIR DOUBLER WAS REPLACED IAW ER/A 330196, REV "C".SDR SIMA20150220001Skin · damagedHAIL DAMAGE EVENT, REPLACE REAR FUSELAGE I SKIN. R & R REAR FUSELAGE I SKIN IAW SRM 51-40-02, 51-40-06, 51-20-01, 51-20-03, 51-40-03, ETN-EM-51-118, ETN-EM-53-266 & 53-31-01-SI.SDR SIMA20150220002Skin · damagedHAIL DAMAGE EVENT, RT CFI NEW SKIN HAS HOLE DRILLED ON CHEM MILL EDGE. ACCOMPLISHED REPAIR IAW ERS-EM-53MR-1080.SDR SWAA2015022036777Skin · crackedSKIN CRACKED AT BS 1016, STRINGER 14L. REPAIRED SKIN IAW EA.SDR WVER0220201500004Skin · chafedFUSELAGE SKIN IS CHAFED AT STR 27, FS 909-927.SDR R61A201502190166Skin · dentedMAINTENANCE RE-EVALUATED EO 53-I00091, REPAIR OF THE NOSE SKIN AT FS X-39.00 RT SIDE. MAINTENANCE PERFORMED A MAJOR REPAIR OF THE NOSE SKIN AT FS X-39.00, RT SIDE IAW RD 8/4-53-6713. MATERIAL FABRICATED FROM .063 2024 T3. PN: SH063 2024T3 ON PO 4591, ACFT SDR SWAA2015031937218Skin · crackedFUSELAGE SKIN CRACKED AT BS 804, STRINGER 23L. REPAIRED SKIN IAW SRM & EA.
Back to JASC 5330