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 AALA20121026003Skin · damagedFUSELAGE DENTED, PUNCTURED, AND SCRATCHED AT STATION 867, STRINGER 20 LEFT. INSTALLED DOUBLER PER SRM 53-00-02 REPAIR 1 AND EA B737-53-026790.SDR FOTR3352012032012Skin · corrodedSKIN LT SIDE LAP JOINT AT STR 4L HAS CORROSION SPOTS AND CORRODED FASTENERS BETWEEN BS 870-970. REPAIRED ON FAS WO 22148, NR 33521.SDR SWAA2012111609556Skin · crackedLEFT BS 767+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 3, 8, 9. REPAIRED LEFT BS 767 +10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-20818 REV 1 REO G15589 REV A.SDR SWAA2012111509510Skin · crackedLEFT BS 787+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICAITON AT HOLES 1, 3, 7, 9, 10. REPAIRED LEFT BS 787+10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-20817 REV- , REO G15588 REVIR.SDR SWAA2012111509509Skin · crackedRIGHT BS 847+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 4 , 9. REPAIRED RIGHT BS 847+10 UPPER AFT WINDOW CORNER IAW EA 1-353-20809 REV-, REO G15581 REV IR FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012111409353Skin · crackedLEFT BS 807+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3, 9. REPAIRED LEFT BS 807+10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-20816 REV-, REO G15587 REV IR FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012111409352Skin · crackedLEFT BS 827+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 7, 8. REPAIRED LEFT BS 827+10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-20815 REV-, REO G15586 REV IR.SDR SWAA2012111409351Skin · crackedLEFT BS 847+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 9, 12. REPAIRED LEFT BS 847+10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-20814 REV-, REO G15585 REVIR FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012111409350Skin · crackedLEFT BS 887+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3, 4, 9, 12. REPAIRED LEFT BS 887+10 UPPER AFT WINDOW CORNER IAW EA 1-353-20813 REV-, REO G15584 REV IR.SDR SWAA2012111409349Skin · crackedLEFT BS 787+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 2, 3, 4, 5, 6. REPAIRED LEFT BS 787+10 UPPER AFT WINDOW CORNER IAW EA 1-353-20820 REV-, REO G15591 REV IR FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012111409348Skin · crackedLEFT BS 767+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 7. REPAIRED LEFT BS 767+10 UPPER AFT WINDOW CORNER IAW EA 1-353-20819 REV-, REO G15590 REV IR.SDR SWAA2012111409347Skin · crackedLEFT BS 727+10 UPPER AFT WINDOW SKIN CUTOUT HAS HFEC CRACK INDICATION AT HOLE 4. REPAIRED SKIN CUTOUT IAW EA.SDR SWAA2012111409346Skin · crackedRIGHT BS 887+10 UPPER AFT WINDOW SKIN CUTOUT HAS HFEC NOISE INDICATION AT HOLE 6 AND HFEC CRACK INDICATION AT HOLES 2, 4. REPAIRED SKIN CUTOUT IAW EA.SDR SWAA2012111409345Skin · crackedRIGHT BS 807+10 UPPER AFT WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLES 1, 2, 3, 9. REPAIRED RIGHT BS 807+10 UPPER AFT WINDOW CORNER IAW EA 1-353-20811 REV-, REO G15583 REV IR FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012111409344Skin · crackedRIGHT BS 727+10 LOWER FORWARD WINDOW CORNER HAS HFEC CRACK INDICATION AT HOLE NR 7. REPAIRED RIGHT BS 727+10 LOWER FORWARD WINDOW CORNER IAW EA 1-353-20810 REV-, REO G15582 REV IR.SDR SWAA2012110909190Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110909189Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110809171Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110809165Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609125Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609124Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609123Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609122Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609121Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609120Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609119Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609118Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609117Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847 +10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609116Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609115Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012110609114Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR QXEA2012102501340Doubler · corrodedLAVATORY VENT INNER DOUBLER AND DOME NUT CHANNELS ARE CORRODED STA 19.4-32.4 STRINGER 33-32S. REMOVED LAV VENT FOM AND REMOVED LAV VENT DOUBLER IAW SRM 51-42-05-02-01. MATCH DRILLED NEW DOUBLER AND NUT PLATE CHANNELS IAW SRM 51-40-07-02-01. INSTALLED NEW DOSDR SWAA2012102908909Skin · crackedFUSELAGE SKIN CRACKED AT BS 360, STR 6R. REPAIRED SKIN IAW SRM.SDR SWAA2012102908908Skin · crackedFUSELAGE SKIN CRACKED AT BS 360, STR 5R. REPAIRED SKIN PER EA.SDR DALA12011403132Skin · dentedFWD LEFT SIDE OF FUSELAGE AT FR9 APPROX STR 21L DENTED. NR 200/10. DENT IS OUT OF "NEARNESS/FORM" CRITERION IAW SRM 53-11-11, FIG 104 DIM A= 1.1", B=.400", D=.031", T= .047". CUT OUT DAMAGED AREA IAW SRM 53-11-11, FIG 212, DIM. L=2.740" W=1.210". HFEC CUT OSDR DALA1252663764Skin · gougedC-1 DOOR SURROUND AFT EDGE SKIN DAMAGED. REPAIRED IAW ERA 502276-14 REV A ON NR 1. ERA 502276-14 A.SDR AALA20121025013Skin · crackedAFT FUSELAGE SKIN IS CRACKED AT STATION 1380, AT SHEAR TIE FASTENER ABOVE LONGERON 14 RIGHT. INSTALLED DOUBLER PER SRM 53-01-00 AND AARD 53-30-00-02.SDR DALA13010939229Skin · damagedWINDOW BELT LT SIDE LIGHTNING STRIKES BS 636-655. ACCOMPLISHED ERA 501771-14 REV O, SECT III. NO CRACKS FOUND.SDR DALA13010819229Skin · damagedWINDOW BELT, LIGHTNING STRIKES BS 560-579. ACCOMPLISHED ERA 501771-14, REV O, SECT III. NO CRACKS FOUND.SDR DALA13010809229Skin · damagedWINDOW BELT LT SIDE HAS LIGHTNING STRIKES BS 579-598. ACCOMPLISH ERA 501771-14 REV O, SECT III. NO CRACKS FOUND.
SDR DALA13010799229Skin · damagedWINDOW BELT LT SIDE HAS LIGHTNING STRIKES, BS 598-617. ACCOMPLISHED ERA 501771-14, REV O. NO CRACKS FOUND.SDR DALA13010789229Skin · damagedWINDOW BELT LT SIDE HAS LIGHTNING STRIKES BS 655-674. ACCOMPLISHED ERA 501771-14, REV O, SECT III. NO CRACKS FOUND.SDR FOTR2249812032012Skin · corrodedFUSELAGE SKIN RT SIDE LAP JOINT AT STR 4R HAS CORROSION SPOTS, ON SKIN AND AROUND FASTENERS HEAD, BETWEEN BS 950-1080. REPAIRED ON FAS WO 22148, NR 33498.SDR UALA2012102506108Skin · damagedBS 460-480 BETWEEN S14L & S15L ALTERNATE REPAIRS ACP IAW ECRA 5331-01643.SDR SWAA2012110509099Skin · crackedSKIN CRACKED AT BS 380, STR 14R. REPAIRED SKIN IAW EA.SDR SWAA2012110509098Skin · crackedSKIN CRACKED AT BS 500A, STR 14R. REPAIRED SKIN IAW EA.SDR SWAA2012110109007Skin · crackedFUSELAGE SKIN CRACKED AT BS 430+3, STR 1. REPAIRED SKIN IAW AAR EA AND EA.SDR UALA2012102506109Skin · damagedBS 460-480 BETWEEN S14R & S16R ALTERNATE REPAIRS ACP IAW ECRA 5331-01642.SDR AALA20121024024Skin · dentedDENT IN FUSELAGE SKIN, STATION 233, ABOVE LONGERON 18 LEFT. INSTALLED REPAIR DOUBLER PER SRM 53-04-00 FIGURE 12C .SDR SWAA2012102608869Skin · crackedSKIN CRACKED AT BS 500B+6, STR 2L. REPAIRED SKIN IAW SRM.
Back to JASC 5330