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 SWAA117991Skin · crackedDURING SCHEDULED SPV CHECK FOUND, RT FUSELAGE WINDOW SKIN CRACKED AT BS 867+10 UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117990Skin · crackedDURING SCHEDULED SPV CHECK FOUND, RT FUSELAGE WINDOW SKIN CRACKED AT BS 847+10 UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117989Skin · crackedDURING SCHEDULE SPV CHECK FOUND, RT FUSELAGE WINDOW SKIN CRACKED AT BS 827+10 UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117988Skin · crackedDURING SCHEDULED SPV CHECK FOUND, RT FUSELAGE WINDOW SKIN CRACKED AT BS 807+10 UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117987Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 787+10 UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117986Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 787+10 LOWER FWD CORNER. REPAIRED SKIN IAW SB.SDR SWAA117985Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 867+10 UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117984Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 807+10 UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117983Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 500C+10 UPPER FWD CORNER. REPAIRED SKIN IAW SB.SDR SWAA117982Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 460+10 UPPER FWD CORNER. REPAIRED SKIN IAW SB.SDR SWAA117981Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LT FUSELAGE WINDOW SKIN CRACKED AT BS 440+10 UPPER FWD CORNER. REPAIRED SKIN IAW SB.SDR SWAA117980Skin · crackedDURING SCHEDULED SPV CHECK FOUND, RT FUSELAGE WINDOW SKIN CRACKED AT BS 480+10 LOWER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117979Skin · crackedDURING SCHEDULED SPV CHECK FOUND, RT FUSELAGE WINDOW SKIN CRACKED AT BS 460+10 LOWER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117978Skin · crackedDURING SCHEDULED SPV CHECK FOUND, RT FUSELAGE WINDOW SKIN CRACKED AT BS 420+10 LOWER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117960Skin · corrodedDURING SCHEDULED 26Y CHECK FOUND, SKIN CORRODED AT BS 532, STR 27R. REPAIRED SKIN IAW ER AND EA.SDR SWAA117944Skin · crackedDURING SCHEDULED 16Y CHECK FOUND, SKIN CRACKED AT BS 947.5+11, STR 17R. REPAIRED SKIN IAW SRM.SDR AALA20111116TUL05Skin · dentedREPAIR DOUBLER AT STATIONS 229 TO 245, BELOW LONGERON 18 LEFT, DENTED. INSTALLED PERMANENT REPAIR PER SRM 53-34-00 FIGURES 1 AND 2, SRM 53-04-05 FIGURE 2 AND SRM 51-60-00.SDR DALA1521870651Skin · damagedLIGHTNING STRIKE BS 418 RT OF BL 026, STICKER 8, REPAIRED IAW SRM 53-00-01, REPAIR 6, SECTION I, PARAGRAPH 4.SDR DALA1521860651Skin · damagedLIGHTNING STRIKE BS 426.5 BL 0, STICKER 7, REPAIRED IAW SRM 53-00-01, REPAIR 6.SDR DALA1521850651Skin · damagedLIGHTNING STRIKE BS 460 RT OF BL, 0. REPAIRED IAW SRM 53-00-01, REPAIR 6SDR DALA1521840651Skin · damagedLIGHTNING STRIKE BETWEEN BS 460 AND, 480 RT OF BL 0. REPAIRED IAW SRM 53-00-01.SDR DALA1521830651Skin · damagedLIGHTNING STRIKE BETWEEN BS 480 AND, 500 RT OF BL 0, REPAIRED IAW SRM 53-00-01.SDR DALA1521820651Skin · damagedREPAIRED IAW SRM 53-00-01, REPAIR 6, LIGHTNING STRIKE BETWEEN BS 540 AND PERMANENT REPAIR C/W AND IDENTIFED., 560 RT OF BL 0, STICKER 3, 18".SDR DALA1521810651Skin · damagedLIGHTNING STRIKE AT BS 600, RT OF, REPAIRED IAW SRM 53-00-01, PERMANENT REPAIR C/W AND IDENTIFED, BL 0, STICKER 2, 14".SDR FDEA201111154926Skin · dentedLOWER FUSELAGE BELLY NOSE SKIN PANEL DENTED. R & R SKIN IAW SRM 51-40-21 AND IAW DWG A53611171202.SDR IPXA1570710Skin · dentedDENT ON FUSELAGE SKIN, BS 661-781, S4-10R. INSTALLED DOUBLER REPAIR IAW EA 111587A.SDR IPXA1570694Skin · dentedINSPECTION TYPE:SPVS, FUSELAGE SKIN, BS 1459-1621, STR 4R-4L HAS DENT DAMAGE. REPAIRED DAMAGE IAW EA 111702.SDR IPXA1570692Skin Panel · dentedINSPECTION TYPE:SPV, DENTS ON FUSELAGE SKIN, BS 439-661, S4-10R. INSTALLED DOUBLER REPAIR IAW EA 111605 IR AND EO B757-5330-45314-A.SDR IPXA1570690Skin · dentedINSPECTION TYPE: SPV, DENT ON FUSELAGE SKIN PANEL, BS 439-661 S4-10R. REPAIRED DENT IAW EA 111604 IR AND EO B757-5330-45313-A.SDR IPXA1570689Skin · dentedINSPECTION TYPE:SPV, FUSELAGE SKIN, BS 1459-1621, S4R-4L HAS DENT DAMAGE. REPAIRED DAMAGE IAW EA 111598.SDR IPXA1570688Skin Panel · dentedINSPECTION TYPE: SPV, FUSELAGE SKIN, BS 1459-1621, STR 4R-4L HAS DENT DAMAGE. REPAIRED DAMAGE IAW EA 111597.SDR IPXA1570687Skin · dentedINSPECTION TYPE: SPV, FUSELAGE SKIN, BS 1459-1621, S4R-4L HAS DENT DAMAGE. REPAIRED DAMAGE IAW EA 111595.SDR IPXA1570686Skin · dentedINSPECTION TYPE: SPV, FUSELAGE SKIN, BS 1459-1621, S4R-4L HAS DENT DAMAGE. REPAIRED DAMAGE IAW EA 111594.SDR IPXA1570685Skin Panel · dentedINSPECTION TYPE: SPV, FUSELAGE SKIN, BS 1459-1621, S4R-4L HAS DENT DAMAGE. REPAIRED DAMAGE IAW EA 111593.SDR IPXA1570684Skin Panel · dentedINSPECTION TYPE: SPV, DENT ON FUSELAGE SKIN, BS 439-661, S4-10R. REPAIRED DENT IAW EA 111606 IR AND EO B757-5330-45315-A.SDR IPXA1570683Skin · dentedINSPECTION TYPE: SPV, FUSELAGE SKIN PANEL, BS 1459-1621, S4R-4L HAS DENT DAMAGE. REPAIRED DAMAGE IAW EA 111592.SDR IPXA1570682Skin · dentedINSPECTION TYPE:SPV, FUSELAGE SKIN PANEL, BS 1459-1621, S4R-4L HAS DENT DAMAGE. REPAIRED DAMAGE IAW EA 111591.SDR IPXA1570672Skin · dentedDENTS ON FUSELAGE SKIN PANEL, BS 661-781 S4L-S10L. DENTS REPAIRED IAW EA 111601, EO B757-5330-45340-A.SDR IPXA11570633Skin Panel · dentedINSPECTION TYPE:SPV DENTS ON SKIN PANEL, BS 661-781, S4-10R. DENTS REPAIRED IAW EA 111586 EO B757-5330-45355-A.SDR IPXA11570622Skin · dentedDENTS ON FUSELAGE SKIN PANEL, BS 661-781 S4L -S10L. REPAIRED DENTS IAW EA 1116 02 IR AND EO B757-5330-45339-A.SDR MASA2011121364199Skin · defectiveFOUR REDUNDANT HOLES FOUND IN REPLACEMENT SKIN PANEL P/N SH670-330013-13 LOCATED AT FS 506.125 BETWEEN STR 5L-6L(2) AND STR 5R-6R(2). C/W RO CRJ9-53-0830, TASK MRO 18396.SDR FDEA201111154925Strap · corrodedEMPENNAGE SKIN STRAP BS 1790 THE FORWARD EDGE OF THE APU INLET CUTOUT HAS CORROSION. R & R IAW SRM 51-40-02, REV 104. REPAIR CLASSIFIED AS MAJOR.SDR AALA20111115TUL04Skin · dentedDENTS IN SKIN AT STATION 256. INSTALLED DOUBLER REPAIR PER BOEING DRAWING SG09530002.SDR COEA2011111517801Skin · damagedHEAVY CK COE / MAJOR REPAIR: DENT WITH GOUGE IN SKIN EXTERNAL FUSELAGE 2.7" AFT OF FR 39 AND .9" ABOVE STRINGER 19R. REPAIR PER ATR SRAS AND SRI.SDR DALA1163470928Skin · damagedDURING HMV ELONGATED HOLES WAS FOUND ON FUSELAGE SKIN FROM STA Y=1418 TO 1422 BTW LONGERON 1 AND 2RT. CUT OUT DAMAGE AREA OF FUSELAGE SKIN AND INSTALLED FILLER, DOUBLER IAW ERA 497385-14 REV ORIG.SDR DALA1163460928Skin · crackedDURING HMV A CRACK WAS FOUND ON FUSELAGE SKIN AT STA Y=1418 BTW LONGERON 1 AND 2RT WITH 0.562" LENGTH. CRACK AREA ON FUSELAGE WAS CUT OUT AND FILLER, DOUBLER INSTALLED IAW ERA 497385-14 REV ORIG.SDR DALA1163459017Skin · dentedAT HMV TRANSFERRED FROM SMS ERA 456396-14 REV D SEC III PERMANENT REPAIR TO FUSELAGE SKIN AT STA Y=110-140 LONGERON 28R-29L.SDR SWAA117914Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 866 TO BS 872, STR 1. REPAIRED SKIN IAW ER AND EA.SDR SWAA117887Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 847+10 UPPER AFT CORNER. REPAIRED SKIN IAW SB.SDR SWAA117886Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 787+10 UPPER AFT CORNER. REPAIRED SKIN IAW SB.
Back to JASC 5330