JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 FDEA200912234506Frame · crackedDURING INSPECTION CAC INT. FOUND CRACK ON FRAME. REPAIRED FRAMES IAW SRM 53-30-00 FIG.7 VOL.1.SDR AALA20091222TUL07Frame · crackedSTATION 1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED DOUBLER PER SRM 53-03-00.SDR FDEA200912224494Frame · wornMAIN CABIN DEFORMATION AND WEAR ON FRAME. REPAIRED AREA IAW SRM 53-30-00, FIG 4, VOL I.SDR SWAA097996Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097968Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097967Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097957Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097952Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 344, STR 22L. REPAIRED FRAME PER AEO.SDR SWAA097945Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097920Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, STR 13L. REPAIRED FRAME PER EA.SDR SWAA097919Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, STR 13R. REPAIRED FRAME PER EA.SDR SWAA097918Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 767, STR 14R. REPAIRED FRAME PER EA.SDR UALA2009122103947Frame · crackedUPPER DECK FRAME FLANGE CRACKED AT BS 1220 LT AT TENSION TIE. MAJOR REPAIR ACCOMPLISHED: INSTALLED REPAIR DOUBLER.SDR UALA2009122103944Frame · crackedUPPER DECK BS 1160 RT FRAME CRACKED AT 4 HOLES COMMON TO TENSION TIE. MAJOR REPAIR ACCOMPLISHED: SPLICED IN NEW FRAME SECTION.SDR RMXA1221200903291Frame · crackedDURING A SCHEDULED INSP, A CRACK WAS DISCOVERED IN THE FUSELAGE TAILCONE SUPPORT FRAME PN L533M1022205. REPAIR SCHEME REQUEST SUBMITTED TO MFG AND RECEIVED. REPAIR WILL CONSIST OF INSTALLED A SB DOUBLER ON THE FRAME. THIS HAD BEEN A ISSUE ON EARLIER SN ACFT, SDR A6WA201040067Frame · corrodedCORROSION ON FRAME 319.70 AT BL 0. REMOVED AND REPLACED LOWER FRAME SECTOR.SDR DLM90092020Frame · dentedACFT ENCOUNTERED A BIRD STRIKE ON THE FUSELAGE JUST ABOVE THE F/O EYEBROW WINDOW AT THE FS 148 FRAME BETWEEN L-6R AND L-8R. THE SKIN WAS REPAIRED ON ERA 478136-14 AND THE FRAME HAS BEEN REPAIRED ON ERA 478189-14.SDR SWAA097909Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097908Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097907Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097906Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097900Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA097897Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR DLM88092006Frame · crackedDURING HMV A CRACK WAS FOUND ON LT FUSELAGE FRAME OVERWING STA Y=886 IN PAX CABIN. FRAME WAS REPLACED IAW DWG SR059530282 REV ORIG.SDR AALA20091218TUL21Frame · crackedCRACK IN FRAME STATION 1497 AT 4 O`CLOCK POSITION. INSTALLED DOUBLER PER ENGINEERING AUTHORIZATION 53-008466, DATED 12/18/09.SDR ZZDA2009423Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2984.SDR ZZDA2009422Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 1 CONDITION 1. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2973.SDR UALA2009121803922Frame · crackedUPPER DECK BS 1160 LT FRAME AND TENSION TIE CRACKED. FRAME CRACKED AT 4 HOLES, TENSION TIE CRACKED AT 6 HOLES. MAJOR REPAIR ACCOMPLISHED: INSTALLED REPAIR AT FWD TENSION TIE.SDR DALA1143030920Frame · crackedFUSELAGE MAIN FRAME CRACKS. REPAIRED IAW EA 09-460094-12, ME03.SDR ASOA200901432Frame · corrodedFUSELAGE FRAME AT FS 319.70 HAS SMALL AREA OF CORROSION AT BOTTOM OF FRAME BETWEEN STRS 25L AND 26L.SDR SWAA097834Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097825Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097824Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097823Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097822Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097891Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097890Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097889Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097888Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097887Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097886Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097885Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097884Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097883Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097882Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097881Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097789Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097788Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER EA.SDR SWAA097787Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR AALA20091215TUL06Frame · crackedFOUND CRACK AT FRAME STATION 1418, LONGERON 2 RIGHT. INSTALLED DOUBLER AND STRAP PER SRM 53-03-00 FIG 31A.
Back to JASC 5311