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 UIEA200800195Skin · corrodedAFT CARGO STA 1860 STR 45R- 46R FUSELAGE SKIN FOUND WITH LEVEL 1 CORROSION. CORROSION REMOVED PER SRM 51-10-02 AND 51-30-01.SDR DLM88080727Skin · damagedLIGHTNING STRIKE FOUND ON UPPER AFT CORNER OF WINDOW 21L CUTOUT. AREA BLENDED AND INSPECTED.SDR MWEA080069Skin · damagedLIGHTNING STRIKE DAMAGE NOTED AT STATION 370 LONGERON RIGHT 7. FABRICATED AND INSTALLED DOUBLER.SDR ASAA0843076Skin · dentedDENT OF LT LOWER FUSELAGE EXTERIOR BS 500A TO BS 500B STR25 TO STR26. DAMAGE REPAIRED IAW B737 400 SRM 53 00 01.SDR UIEA200800205Skin · dentedBODY STATION 220 STRINGER 28L FOUND AREA DENTED AS MARKED. DENTED AREA RE-WORKED AS PER SRM 51-10-01.SDR UIEA200800198Skin · chafedFUSELAGE LOWER LOBE STA 220 - 240 LEFT SIDE STR 36L - 37L FOUND CHAFING. CHAFED AREA SMOOTHED OUT PER SRM 51-10-01.SDR SWAA082565Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT CRACKED AT BS 413, LBL 3. REPAIRED SKIN PER SRM.SDR SWAA082531Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA082529Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 910, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA082528Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 323, STR 20R. REPAIRED SKIN PER SWA EA.SDR ASAA0843078Skin · dentedDENT ON LT LOWER FUSEALGE AT BS 500 TO 500A STR 25 TO 26. REPAIR WORK ACCOMPLISHED IAW B737 400 SRM 53 00 01.SDR ASAA0843098Skin · dentedLT LOWER FUSELAGE EXTERIOR DENTED AT STA 500E TO 500F STR 26 TO 27. REPAIRED DENT IAW B737 400 SRM TR53 27 REPAIR 31 FIG 201.SDR ASAA0843104Skin · dentedDENTS AT BS 480 500 STR 25L 26L. REPAIRED WITH REPAIR PART.SDR USAA920081043Skin · crackedSAL - MAJOR REPAIR - BC2 CHECK - CRACKED FUSELAGE SKIN, BS 3117 / FR 73, S22L - S23L. REPAIRED FUSELAGE SKIN, BS 3117 / FR 73, S22L - S23L IAW EA 120733.SDR UPS08852233Skin · damagedA/C IS OOS DUE TO FUSELAGE DAMAGE CAUSED BY OTHER CARRIER'S BAGGAGE CART. REPAIRED PER UPS EO DC8-5330-29309-A.SDR DLM88080696Skin · gougedGOUGE ON FUSELAGE SKIN AT STA 237 BTW LONG 17 LT AND 18 LT. REPAIRED PER SRM 53-04D.SDR SWAA082546Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 413, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA082550Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 489, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA082549Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA082547Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 779, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA082548Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR DHL2008807511Panel · delaminatedWING TO FUS LWR PANEL NR 732 INTERNAL SKIN DELAMINATED (STA 980.000 - 1050.000). REMOVED WING TO FUS LWR PANEL NR 732 IAW SRM 51-3-0. CLEANED, TREATED AND PRIMED AREA IAW SRM 51-1-8B. INSTALLED NEW PANEL IAW SRM 51-3-0.SDR K11A2009010272306Skin · dentedDENT IN FUSELAGE.SDR ABXA080159Skin · corrodedDEEP PITTING CORROSION ON LT DOOR FRAME FORWARD LOWER CORNER INTERIOR SKIN AT FS 300 AND STRINGER 19 LEFT. BLENDED OUT AREAS, WITHIN LIMITS IAW B767-200 SRM 53-10-01 & 53-00-15. 1 EA PITTED AREA REPAIRED IAW B767 REA B653-573-69. (A)SDR DHL2008807536Skin · corrodedFUSELAGE EXTERNAL SKIN CORRODED (STA 665.000 - 680.000, L-35L - L-36) MAJOR REPAIR. PERFORMED MAJOR REPAIR IAW SRM 53-2-1 FIG 7 SHEET 1-4. REMOVED CORROSION IAW SRM 51-1-8 PG 17-18. FOUND OUT OF LIMITS IAW SRM 53-2-0 PG 2P. FABRICATED REPAIR DOUBLER (AL707SDR USAA920081117Skin · crackedMCN - MAJOR REPAIR - C21 CHECK - CRACKED FUSELAGE SKIN, BS 727E, S21R. REPAIRED FUSELAGE SKIN, BS 727E, S21R IAW B737 SRM 53-00-01- 2R 31, FIGURE 201.SDR DLM90080702Skin · dentedPRIOR TO FIRST FLT OF THE DAY, FOUND FUSELAGE SKIN DENTED AT FS 237 BETWEEN LONGERON 18L AND 19L AND REPAIR ID TAG MISSING. REPAIRED DAMAGED AREA, IAW MD80 SRM 53-04D, FIG 12 B AND MD90 SRM VOL 1, 51-00-01.SDR MWEA080070Skin · damagedLIGHTNING STRIKE DAMAGE NOTED AT STATION 293 LONGERON RIGHT 7. FABRICATED AND INSTALLED DOUBLER.SDR KCSA081238Skin · damagedSMALL AREA OF DAMAGE ON FUSELAGE BELLY SKIN AT BS 644, RBL-2.SDR KCSA081237Skin · damagedSMALL AREA OF DAMAGE ON FUSELAGE BELLY SKIN AT BS 647, RBL-2SDR KCSA081236Skin · damagedSMALL AREA OF DAMAGE ON FUSELAGE BELLY SKIN AT BS 610, LBL-2.SDR KCSA081235Skin · damagedSMALL AREA OF DAMAGE ON FUSELAGE BELLY SKIN AT BS 792, BL-0.SDR USAA920081018Skin · crackedCLT - MAJOR REPAIR - C4 CHECK - CRACKED FUSELAGE SKIN, BS 947.5, S14R. REPAIRED FUSELAGE SKIN, BS 947.5, S14R IAW B737 SRM 53-60-01 REPAIR 7.SDR SWAA082506Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA082509Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 430 AND BS 450, STR 28R AND STR 28L. REPAIRED SKIN PER ER.SDR SWAA082510Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 540, STR 17R. REPAIRED SKIN PER ER.SDR ASAA0843152Bear Strap · corrodedBEAR STRAP CORRODED IN AFT CARGO BAY AREA. REPAIR STRAP PER EA 5330 02357.SDR ASAA0843159Bear Strap · corrodedAFT PIT BILGE STA 787 TO STA 793 RBL 23R BEAR STRAP HAS TWO AREAS OF CORROSION. REFER TO NIR 5097068 FOR REPAIR OF BEAR STRAP BS 787 TO BS 793 RBL 23.SDR FDKA200805194Skin · dentedTHE RIGHT FORWARD FUSELAGE SKIN IS DENTED UNDER THE PITOT STATIC TUBE. THE DAMAGE HAS BEEN FILLED.SDR USAA920081011Skin · crackedPHX - MAJOR REPAIR - DAILY CHECK - CRACKED FUSELAGE SKIN, BS 727E, S24R. REPAIRED FUSELAGE SKIN, BS 727E, S24R IAW B737 SRM 53-00-01 REPAIR 31.SDR SWAA082466Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 430, BL 0. REPAIRED SKIN PER EA.SDR SWAA082468Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BS 394, STR 17R. REPAIRED SKIN PER EA.SDR SWAA082471Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 366, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA082465Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, BL 0. REPAIRED SKIN PER EA.SDR SWAA082467Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BS 503D, STR 16L. REPAIRED SKIN PER EA.SDR USAA920080990Skin · crackedCLT - MAJOR REPAIR - RON - CRACKED FUSELAGE SKIN, BS 727D, S24L. REPAIRED FUSELAGE SKIN, BS 727D, S24L IAW B737 SRM 53-00-01 REPAIR 31 AND USAIRWAYS TYPICAL REPAIR 53-33.SDR 2008UALA02641Skin · damagedA DENT WAS FOUND ON EXTERNAL SKIN OF BULK CARGO DOOR AT FWD LOWER CORNER. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED AREA. ACCMP HFEC INSP FOR CRACK FREE CUTOUT. INSTALLED REPAIR DOUBLER.SDR UPS08M52412Skin · corrodedINSPECTION TYPE:C AFT FUSELAGE EXTERIOR, RIGHT SIDE AT STA 2033 BETWEEN LONGERONS L39 & L 40, CORROSION FOUND SURROUNDING FASTENER HOLE. ATTACH FASTENERS & INNER SUPPORTS REMOVED PER SRM 51-31-01 V II R35. SKIN CORROSION REMOVED PER SRM 51-21-01 VII R35. DASDR DLM88080699Skin · crackedDUE AT HMV, SRM 53-04 FIG 12B SHT 2, REPAIR T6 DOUBLER/2 FT BELOW FWD AIRSTAIR CONTROL BOX/LT SIDE STA 160. REPAIRED PER ERA 467994-14 REV ORG ON N/R T0092778 AT HMV-3 IN GDL.SDR DU4R2008193Skin · dentedS/O 312001 OPS NR 24422 - AFT CARGO EXT DOOR SKIN HAS OUT OF LIMIT DENTS BETWEEN 2 EA EXISTING REPAIRS.
Back to JASC 5330