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 SWAA2015021736667Skin · crackedSKIN CRACKED AT BS 400+15, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2015021236569Post · crackedLEFT NR 3 WINDOW FRAME E - F POST CRACKED AROUND HOLE NR 3 FROM LOWER POSITION. REPAIRED POST IAW ACO.SDR SWAA2015021236568Post · crackedLEFT NR 3 WINDOW FRAME E - F POST CRACKED AROUND NR 2 HOLE FROM LOWER POSITION. REPAIRED POST IAW ACO.SDR SWAA2015021236567Post · crackedRIGHT NR 3 WINDOW FRAME E - F POST CRACKED AROUND NR 4 HOLE FROM LOWER POSITION. REPAIRED POST IAW ACO.SDR SWAA2015021236566Post · crackedRIGHT NR 3 WINDOW FRAME E - F POST CRACKED AROUND NR 3 HOLE FROM LOWER POSITION. REPAIRED POST IAW ACO.SDR SWAA2015021236565Post · crackedRIGHT NR 3 WINDOW FRAME E - F POST CRACKED AROUND NR 2 HOLE FROM LOWER POSITION. REPAIRED POST IAW ACO.SDR SWAA2015021236563Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+12, STRINGER 26L. REPAIRED SKIN IAW EA.SDR SWAA2015020936423Skin · crackedSKIN CRACKED AT BS 948+15, STRINGER 5R. REPAIRED SKIN IAW SRM.SDR SWAA2015020936422Skin · crackedSKIN CRACKED AT BS 500C+1, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2015020936421Skin · crackedSKIN CRACKED AT BS 727C+13, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR REXA2015012700010Skin · dentedFUSELAGE SKIN DENTED AT FS 620 AT THE CARGO DOOR LOWER CORNER AT STRINGER 17L. REPAIRED IAW REO 601R-53-00-34.SDR FDEA201501210253Skin · corrodedLEFT LOWER CTR FUSELAGE SKIN HAS SURFACE CORROSION UNDER RUB STRIP FROM BS 1701 - 1781. REPAIRED SKIN IAW SRM 53-20-00 FIG 6. CLASS 1 REPAIR.SDR FDEA201501210250Skin · crackedLEFT LOWER FUSELAGE BS 1701 SKIN CORRODED & CRACKED UNDER RUB STRIP. REPAIRED SKIN IAW SRM 53-20-00 FIG 6. CLASS 1 REPAIR.SDR SWAA2015012336023Skin · crackedBULKHEAD LOWER CHORD SKIN CRACKED AT BS 540, STRINGER 22L, FASTENER HOLE CODED C. REPAIRED SKIN IAW EA.SDR SWAA2015012336022Skin · crackedBULKHEAD LOWER CHORD SKIN CRACKED AT BS 540, 3RD FASTENER DOWN FWD SIDE BELOW STRINGER 22R. REPAIRED SKIN IAW EA.SDR SWAA2015012336021Skin · crackedBULKHEAD LOWER CHORD SKIN CRACKED AT BS 540, STRINGER 22L, FASTENER HOLE CODED B. REPAIRED SKIN IAW EA.SDR SWAA2015012336006Skin · crackedSKIN CRACKED AT BS 420, BETWEEN STRINGER 20R - 21R. R & R SKIN IAW SRM.SDR SWAA2015012236000Skin · crackedSKIN LOWER BULKHEAD CHORD CRACKED AT BS 540, STRINGER 22L, AFT 3RD HOLE BELOW. REPAIRED SKIN IAW EA.SDR SWAA2015012235995Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22L, BULKHEAD LOWER CHORD FASTENER HOLE CODED H. REPAIRED SKIN IAW EA.SDR SWAA2015012235994Skin · crackedFUSELAGE SKIN CRACKED AT B 540, STRINGER 22L, BULKHEAD LOWER CHORD FASTENER HOLE CODED G. REPAIRED SKIN IAW EA.SDR SWAA2015012235989Skin · crackedFUSELAGE SKIN CRACKED AT BS 540, STRINGER 22L, BULKHEAD LOWER CHORD FASTENER HOLE CODED F. REPAIRED SKIN IAW EA.SDR AALA20150121005Skin · scratchedSCRATCH 16 INCHES LONG, 3/16 INCHES WIDE & .003 INCHES DEEP BELOW BULK CARGO DOOR. REPAIRED SKIN IAW EA 53-038147 & 5361-39-A2153.SDR FDEA201501210249Skin · dentedLOWER FWD FUSELAGE RT HAS A DENT APPROX STATION 348. FOUND DENT OUT OF LIMITS. REPAIRED IAW SRM 53-20-00 FIG 13.SDR SWAA2015032037651Skin · crackedSKIN CRACKED AT BS 887+6.5, STRINGER 25L. REPAIRED SKIN IAW EA.SDR SWAA2015032037650Skin · crackedSKIN CRACKED AT BS 867+13.5, STRINGER 25L. REPAIRED SKIN IAW EA.SDR SWAA2015032037649Skin · crackedSKIN CRACKED AT BS 787+12, STRINGER 23L. REPAIRED SKIN IAW EA.SDR SWAA2015032037648Skin · crackedSKIN CRACKED AT BS 747+5.250, STRINGER 25L. REPAIRED SKIN IAW EA.SDR SWAA2015032037647Skin · crackedSKIN CRACKED AT BS 767+3.250, STRINGER 23L. REPAIRED SKIN IAW EA.SDR SWAA2015032037646Skin · crackedSKIN CRACKED AT BS 767+16.5, STRINGER 21L. REPAIRED SKIN IAW EA.SDR SWAA2015032037645Skin · crackedSKIN CRACKED AT BS 767+16.5, STRINGER 24L. REPAIRED SKIN IAW EA.SDR SWAA2015032037644Skin · crackedSKIN CRACKED AT BS 767+7, STRINGER 24L. REPAIRED SKIN IAW EO & EA.SDR SWAA2015031937621Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B+5, STRINGER 15L. REPAIRED SKIN IAW ER & EA.SDR SWAA2015031737532Skin · crackedSKIN CRACKED BETWEEN BS 827+14 TO BS 847, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2015031737531Skin · crackedSKIN CRACKED AT BS 867+15.5, STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2015031237370Skin · crackedSKIN CRACKED AT BS 540, STRINGER 22R. REPAIRED SKIN IAW ER & EA.SDR DALA2015031202105Skin · dentedBIRD STRIKE DAMAGE BELOW F/O SLIDING WINDOW, FOUND DENT APPROXIMATELY 9" X 7" AT STA 539 FWD OF FRAME 9. DENT IS OUT OF LIMITS DUE TO CLOSENESS OF FASTENERS ON FRAME 9. CUT OUT DAMAGE, FAB. DOUBLER AND INSTALLED IAW ER/A 532347-14, REV A, AND SRM 53-00-11.SDR SWAA2015030637192Skin · crackedFUSELAGE SKIN CRACKED AT STATION 540, STRINGER 22L. REPAIRED SKIN IAW SRM & EA.SDR FDEA201501200237Skin · damagedFUSELAGE EXTERIOR SKIN NICKED & SCRATCHED AT BS 520 - 540, STRINGER 23 - 24R. NICKS AND SCRATCHES REMOVED AND FOUND OUT OF LIMITS IAW SRM 53-00-01 FIG 101 DETAIL II REV 113. REPAIRED IAW EA F-5330-T0314821 PART 1. CLASSIFIED MAJOR IAW GMM 6-2-100.SDR SWAA2015012336019Post · crackedLEFT FLIGHT DECK NR 3 WINDOW POST CRACKED AT 2ND FASTENER HOLE FROM THE BOTTOM. REPAIRED POST IAW ACO.SDR SWAA2015012336018Post · crackedRIGHT FLIGHT DECK NR 3 WINDOW POST CRACKED AT 2ND FASTENER HOLE FROM THE BOTTOM. REPAIRED POST IAW ACO.SDR SWAA2015012235998Skin · crackedBULKHEAD LOWER CHORD SKIN CRACKED AT BS 540, BETWEEN STRINGER 22L - 23L, FASTENER F. REPAIRED SKIN IAW EA.SDR SWAA2015012235997Skin · crackedBULKHEAD LOWER CHORD SKIN CRACKED AT BS 540, BETWEEN STRINGER 22L - 23L, FASTENER B. REPAIRED SKIN IAW EA.SDR SWAA2015012235991Skin · crackedBULKHEAD LOWER CHORD SKIN CRACKED AT BS 540, BETWEEN STRINGER 22R - 23R, FASTENER B. REPAIRED SKIN IAW EA.SDR SIMA20150120007Skin · crackedAFT FUSELAGE SKIN CRACKED ABOVE STRINGER 2R AT FRAME 75. ACCOMPLISHED REPAIR ON AFT FUSE SKIN ABOVE STRINGER 2R AT FRAME 75 IAW ERS-EM-53MR-1028.SDR SIMA20150120005Skin · crackedAFT FUSELAGE SKIN CRACKED ABOVE STRINGER 2L AT FRAME 75. ACCOMPLISHED REPAIR ON AFT FUSE SKIN ABOVE STRINGER 2L AT FRAME 75 IAW ERS-EM-53MR-1028.SDR DALA2015012100431Skin · corrodedFUSELAGE SKIN AT BS 1691, S28R AFT LAV VENT SURROUND STRUCTURE CORRODED. REPAIRED IAW ER/A 523081-14AD, REV A.SDR COEA2015012003903Skin · corrodedHEAVY CHECK COE & MAJOR REPAIR. EXTERIOR SKIN HAS AREA OF LEVEL 2 CORROSION AROUND FASTENER BETWEEN FRAME 20 & 21, UPPER CROWN SKIN PANEL AT STRINGER 4L. REPAIR IAW SRAS DT S-164 15 8938 ISSUE A 1/16/2015.SDR SWAA2015031737481Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 927+18 TO BS 927+21.5, STRINGER 21R. REPAIRED SKIN IAW EA & SWA EA.SDR ASAA2015011910665Skin · corrodedTAIL COMPARTMENT, BS 1088 BULKHEAD APU AIR INLET CUTOUT RT LANDING HAS CORRECTED ON FWD SIDE. ACFT GROUNDED. R & R APU INLET RT LANDING IAW SRM 51-40-02-0G-0 AND SRM 51-30-01 0G-0, W .75 N, O .070, R .061, L 2.0, D .009.SDR ASAA2015011910663Skin · corrodedFS 1088, BULKHEAD RT APU AIR INLET CUTOUT LT LANDING HAS CORROSION ON FWD SURFACE. ACFT GROUNDED. R & R APU INLET LT LANDING IAW SRM 51-40-02-0G-0 AND SRM 51-30-01-0G-0 W .75", O .070", R .052", L 3.0", D .018".
Back to JASC 5330