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 SWAA2013050315549Skin · crackedFUSELAGE SKIN CRACKED AT BS 847 UPPER AFT RIGHT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013050315557Skin · crackedFUSELAGE SKIN CRACKED AT BS 787 UPPER AFT RIGHT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013050315556Skin · crackedFUSELAGE SKIN CRACKED AT BS 807 LOWER FWD LEFT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013050315555Skin · crackedFUSELAGE SKIN CRACKED AT BS 807 UPPER AFT RIGHT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013050315550Skin · crackedFUSELAGE SKIN CRACKED AT BS 887 UPPER AFT RIGHT WINDOW CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2013042615261Skin · crackedLEFT BS 827 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 6, 9. REPAIRED SKIN IAW SB.SDR SWAA2013042615260Skin · crackedLEFT BS 807 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 6, 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013042615259Skin · crackedLEFT BS 827 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013042515205Skin · crackedLEFT BS 787 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 6, 9. REPAIRED SKIN IAW SB.SDR SWAA2013042515204Skin · crackedLEFT BS 767 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 9. REPAIRED SKIN IAW SB.SDR SWAA2013042415146Skin · crackedLEFT BS 847 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415130Skin · crackedLEFT BS 867 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415129Skin · crackedLEFT BS 847 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3, 7, 8. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415128Skin · crackedLEFT BS 887 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 5. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415127Skin · crackedLEFT BS 867 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 5, 6. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415110Skin · crackedRIGHT BS 827 AFT UPPER WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415109Skin · crackedRIGHT BS 787 AFT UPPER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 9. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415108Skin · crackedRIGHT BS 767 AFT UPPER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3, 9. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415107Skin · crackedRIGHT BS 867 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013042415106Skin · crackedRIGHT BS 847 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW SB.SDR SWAA2013042415104Skin · crackedRIGHT BS 827 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLE NR 2. REPAIRED SKIN IAW SB.SDR SWAA2013042415103Skin · crackedRIGHT BS 787 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415096Skin · crackedRIGHT BS 767 FORWARD LOWER WINDOW SKIN CUTOUT CRACKED AT HOLES 1, 2. REPAIRED SKIN IAW BOEING SB.SDR SWAA2013042415125Skin · crackedRIGHT BS 867 AFT UPPER WINDOW SKIN CUTOUT CRACKED AT HOLES 2, 3. REPAIRED SKIN IAW BOEING SB.SDR USAA2013041600036Skin · corrodedC4 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE SKIN BETWEEN BS 747 TO BS 755 & BETWEEN S20L TO S22L. REPAIRED FUSELAGE SKIN BETWEEN BS 747 TO BS 755 & BETWEEN S20L TO S22L IAW EA 505208.SDR DALA1308876802Skin · dentedDENT ON FUSELAGE SKIN AT FRAME BS 620 BETWEEN STRINGER 15L AND 16L. REPAIRED IAW ERA 508943-14, REV ORIGINAL.SDR DALA1308866802Skin · dentedDENT IN FUSELAGE SKIN, BS 635, STR 16L. REPAIRED IAW ERA 508943-14, REV ORIG.SDR DALA13016265812Skin · damagedLIGHTNING STRIKE ON SKIN BS 500, S25L. REMOVED DAMAGE AND INSPECTED. FABRICATED REPAIR IAW SRM 53-00-01. INSTALLED REPAIR PARTS IAW SRM 53-00-01. APPLIED CIC TO REPAIR AREA AND RESTORED FINISH TO EXTERIOR.SDR DALA13016255812Skin · damagedLIGHTNING STRIKES ON SKIN BS 490 S24L. REMOVED DAMAGE, INSPECTED, AND FABRICATED REPAIR IAW SRM 53-00-01. INSTALLED REPAIR AND APPLIED CIC TO REPAIR AREA AND RESTORED FINISH TO EXTERIOR. COMPLETED REPAIR IAW SRM 53-00-01.SDR DALA13015861805Skin · corrodedRT STA 955 UNDER REPAIR PROCESS AFTER FAIL SAFE STRAP TRIMMED OFF FUSELAGE SKIN FOUND CORROSION. TRIMMED OFF AREA FUSELAGE SKIN CORRODED AREA SPOT FACE AND BLEED MAKE DISK FILLER AND INSTALL ACCOMPLISHED IAW ER/A 511797-14AD, REV ORIG.SDR DALA1516380907Skin · damagedSKIN, BS 120 BELOW L-18L CREASED, AND DENTED. REPAIRED IAW ERA 508148-14.SDR IPXA13678238Stringer · crackedINSPECTION TYPE:C08, CRACK 1.1 INCHES, WAS FOUND ON STRINGER 20L BETWEEN BS 1502 AND 1518. REPAIR IAW SR 1-2419267958.SDR DALA1311913749Skin · wornCROWN SKIN BS 327-328 AT LBL 6 WORN. REPAIRED IAW ERA 513578-14 AND ERA 513578-14.SDR FDEA201304100759Skin · unknownFUSELAGE EXTERIOR SKIN RIGHT HAND SIDE THERE IS A DOUBLER REPAIR AT BS 420 FROM S18 - 20R. REPAIR REMOVED AND RE-WORKED IAW SRM 53-00-01, REPAIR 16, FIG.201, REV.108. REPAIR IS CAT.B, MAJOR.SDR AALA20130410002Skin · corrodedFUSELAGE SKIN IS BULGED BETWEEN STATIONS 650 AND 655 AT LONGERON 30. ACCOMPLISHED REPAIR PER SRM 53-04-03 AND EA.SDR ASAA2013041094437Skin · dentedCHECK DENT AT STA NR 896 W/L236 ACFT GROUNDED. CHECKED LIMITS ON FUSELAGE SKIN AT STA 896 W/L 236 ORIGINAL THICKNESS IS .100 WIDTH IS .650 AND LENGTH IS 3 DEPTH IS .020 W/Y=32.5 FOUND TO BE WITHIN LIMITS IAW SRM 53-00-01 TOPCOAT IAW AMM 51-21-44.SDR USAA2013041200040Skin Panel · corrodedC4 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE SKIN PANEL BETWEEN BS 766 TO BS 780 & BETWEEN S18L TO S19L. REPAIRED FUSELAGE SKIN PANEL BETWEEN BS 766 TO BS 780 & BETWEEN S18L TO S19L IAW B757 SRM 51-10-02, 53-00-01-1A & EA 505210.SDR SWAA2013041514817Skin · crackedSKIN CRACKED AT BS 344, STR 2L. REPAIRED SKIN PER SRM.SDR DALA13016040946Skin · corrodedCORROSION ON INNER FUSELAGE SKIN PREVIOUS REPAIR DOUBLER BETWEEN STA Y=610 TO Y=628 LONG, 28RY AND 29 LT REF (T0 277241). REPAIR FILLER WAS REMOVED IAW SRM MD-88 51-30-5. FABRICATED AND INSTALLED, AND PROTECTED AGAINST CORROSION IAW SRM 51-10-3 PAR 14-21 AND SDR DALA13016020945Skin · damagedACFT DAMAGE AT RT FUS SKIN AT DRAIN OPENING BETWEEN FRAME STA 1309 & 1287 & BETWEEN LONGERON 24R & LONGERON 25R, ACCOMPLISH HIDING DAMAGE INSPECTION. CUT OUT DAMAGE AREA. NDT NO CRACK NOTED, FABRICATED SKIN DOUBLER REPAIR AND FINGER DOUBLER. INSTALLED DOUBLESDR FDEA201304100763Skin · chafedAFT FUSELAGE SKIN BELOW STRINGER 9L AFT OF BULKHEAD BS 1787, EXT SURFACE CHAFED BY STAB FAIRING. COMPLIED WITH EA F-5330-T0300225, CAT "A" MAJOR REPAIR.SDR CALA2013041000211Skin · crackedWHILE PERFORMING FCD 5710-02262 HFEC CRACK INDICATION NOTED AT BS 663 BETWEEN RBL 40 - 45.64 WL 192 - 200.6. REPAIRED IAW SRM 57-10-10, REPAIR 3, ALT 2.SDR UALA2013041302527Skin · damagedACP'D REPAIR AT BS 1602 ABOVE STRINGER 20R LAP JOINT AT C03 VISIT PER UA-EVA-73476 BY REMOVING DAMAGED SKIN AND INSTALLING A DOUBLER AND A FILLER. ACP'D REPAIR PER AVO 1984.SDR DALA1311903749Skin · wornCROWN SKIN BS 346-347 AT BL 0 WORN. REPAIRED IAW ERA 513578-14 AND ERA 513578-14.SDR SWIA201333333Skin · chafedFUSELAGE SKIN HAS TWO CHAFES FROM SCREWS WHERE THE AFT BODY FAIRING SCREWS TOGETHER ON LOWER FUSELAGE. (C-CHECK) REPAIRED CHAFED AREAS UNDER AFT BODY FAIRING ON LOWER FUSELAGE IAW REO.SDR SWAA2013042415124Skin · crackedSKIN CRACKED AT BS 380, STR 14R. REPAIRED SKIN IAW EA.SDR USAA2013041200041Skin Panel · corrodedC4 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FUSELAGE SKIN PANEL BETWEEN BS 752 TO BS 760 & BETWEEN S24L TO S25L. REPAIRED FUSELAGE SKIN PANEL BETWEEN BS 752 TO BS 760 & BETWEEN S24L TO S25L IAW B757 SRM 53-00-01-2R & EA 505208.SDR FDEA201304090755Skin · dentedEXTERNAL FUSELAGE SKIN DENTED BS 1496 BETWEEN S14-15R. REPAIRED DENT IAW SRM 53-00-01, FIG 201, REPAIR 16. MAJOR REPAIR.SDR DALA1309040610Doubler · corrodedSURFACE CORROSION FOUND ON LWR TCAS ANTENNA AND DOUBLER. REMOVED OLD DOUBLER AND CLEANED IAW SRM 43-00-01. PERFORMED DETAILED INSPECTION. TREATED AND PRIMED IAW PS 900-4-1-N2 AND 900-3-6N3 R/R TCAS ANTENNA DOUBLER IAW DELTA EO NR 6-59954-3, REV D. R & SDR AALA20130410001Skin · corrodedSKIN BULGING AROUND FASTENER HEADS AT STATION 1197. CUTOUT DAMAGE AND INSTALLED REPAIR DOUBLER AND FILLER PER SRM 53-00-01-2R-1.
Back to JASC 5330