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 CALA2009020200076Frame · crackedFRAME CRACKED AT STATION 787 BETWEEN S-8R AND S-9R (OUTBOARD MOUNT BRACKET ATTACH) B737-53-3-0740. REPAIRED FRAME PER EA 5310-04889.SDR AALA2009021100088Frame · dentedDENT ON FUSELAGE AT CANT FRAME AT STATION 1497 LONGERON 15 LEFT. AREA OF DISCREPANCY IS 1 INCH BY 1 INCH WITH A DEPTH OF .043 INCH. DYE CHECKED DENT AND NO CRACKS. INSTALLED DOUBLER PER SRM 53-01 FIG 2 SHEET 5.SDR SWAA090733Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR ZZDA2009034Frame · corrodedAFT CARGO COMPARTMENT BILGE FRAME 870 FWD & AFT FACE HAS CORROSION AT STR 30. INSTALLED "Z" FRAME REPAIR AT LOWER CARGO COMPARTMENT FRAME STA 870 BETWEEN LONG. 27 LT & 27 RT PER B717 SRM 53-20-07 REPAIR 3 FIG 201.SDR SWAA090662Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 887, BETWEEN STR 27L TO 27R. REPAIRED FRAME PER SRM.SDR FDEA200901290392Frame · damagedAFT CARGO PIT STA 1380, STR 25-26L FRAME HAS MISDRILLED HOLE AND IS GOUGED. REPAIRED IAW SRM 53-00-07 REPAIR NR 5 FIG 201. THIS IS A MAJOR CATEGORY 'B' REPAIR WITH INITIAL INSPECTION 37,500 FLIGHT CYCLES OR 50,000 AIR FRAME CYCLES WHICHEVER COMES FIRST-REPEASDR FDEA200901290382Frame · gougedFWD PIT FRAME AT BS 520 STRINGER 22L IS GOUGED AT RADIUS. CUT OUT DAMAGED IAW SRM 51-40-3 FIG. 1. FABRICATED REPAIR DOUBLER, STRUCTURAL FILLER, AND 1 FILLER IAW SRM 53-10-2 FIG. 3 AND 51-40-3 FIG. 1. HEAT TREATED PART FROM 7075-O TO 7075-T6 IAW FAS ENGINEERINSDR FDEA200901290363Frame · damagedFOUND ON C 73 NO GAP BETWEEN FRAME AND STRINGER REPAIR PROFILE IN AREA OF FLUSH SKIN REPAIR. REPAIR PERFORMED BY CUT THE FRAME AT C 73 BETWEEN P56LH-56RH AND REPAIR IAW SRM 53-10-13 FIG 203 AND REPLACE THE STRINGER COUPLING IAW DRAWING R539-70631.SDR AALA2009021100084Frame · damagedOVERSIZED AND ELONGATED HOLES ON FRAME 1287 BETWEEN LONGERON 29 RIGHT AND LONGERON 29 LEFT. INSTALLED J ANGLE REPAIR WITH OVERSIZED FASTENERS PER AARD 53-10-00-14.SDR USAA2009022390410Frame · crackedSAL - C21 - MAJOR REPAIR - CRACK ON FRAME WEB AT BS 303.9, S16L. REPAIRED FRAME WEB AT BS 303.9, S16L IAW US AIRWAYS ENGINEERING TASK CARD M1L53001.SDR ASOA200900149Frame · crackedLT FS 718.00 FRAME IS CRACKED BETWEEN STRINGER 10 AND 12. REMOVED LT FRAME AT FS 718.00 IAW SRM 51-42-06. UPON REMOVAL OF FRAME, LOWER SPLICE PLATE WAS DAMAGED (BENT), REQUIRES REPLACEMENT. FABRICATED NEW LOWER SPLICE PLATE IAW DRAWING 600-36030 AND SRM 51-SDR SWAA090621Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090620Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090619Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090618Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090617Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090615Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA090614Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090613Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090612Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090611Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090610Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR USAA2009021690351Frame · crackedSAL - C21 - MAJOR REPAIR - NR 6208841 - CRACK ON FUSELAGE FRAME AT BS807 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS807 BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009021690350Frame · crackedSAL - C21 - MAJOR REPAIR - NR 6208840 - CRACK ON FUSELAGE FRAME AT BS727E BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS727E BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR USAA2009021690349Frame · crackedSAL - C21 - MAJOR REPAIR - NR 6208839 - CRACK ON FUSELAGE FRAME AT BS400 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS400 BETWEEN S8R TO S9R IAW TASK CARD M1C53002.SDR UPS09554611Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE ON INBOARD FLANGE STR 15R BS 1300. REPAIRED PER B757-5310-19952C AND SRM 51-40-02-0G.SDR UPS09554610Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15R BS 1220. REPAIRED PER B757-5310-19952C AND SRM 51-40-02-0G.SDR UPS09554609Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1620. REPAIRED DAMAGE INBOARD FLANGE AT STR 15L BS 1620 IAW UPS EO B757-5310-19952C AND B757 SRM 51-40-09-0G, 51-20-01-0G 51-40-02-0G.SDR UPS09554608Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1580. REPAIRED PER B757-5310-19952C AND SRM 51-40-02-0G.SDR UPS09554607Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1540. REPAIRED PER B757-5310-19952C AND SRM 51-40-02-0G.SDR UPS09554606Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1500. REPAIRED DAMAGE IAW UPS EO B757-5310-19952C AND B757 SRM 51-20-01-0G 51-40-02-0G.SDR UPS09554605Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1460. REPAIRED DAMAGE IAW UPS EO B757-5310-19952C AND SRM 51-20-01-0G 51-40-02-0G.SDR UPS09554604Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1420. REMOVED DAMAGE IAW UPS EO B757-5310-19952C AND B757 SRM 51-20-01-0G 51-40-02-0G.SDR UPS09554603Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1380. REPAIRED DAMAGE IAW UPS EO B757-5310-19952C AND B757 SRM51-20-01-0G 51-40-02-0G.SDR UPS09554602Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOUND AT STR 15L BS 1340. REPAIRED DAMAGE IAW UPS EO B757-5310-19952C AND B757 SRM 51-20-01-0G 51-40-02-0G.SDR UPS09554601Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1260. REPAIRED DAMAGE IAW UPS EO B757-5310-19952C AND B757 SRM51-20-01-0G 51-40-02-0G.SDR UPS09554600Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1220. REPAIRED DAMAGE IAW UPS EO B757-5310-19952C AND B757 SRM 51-40-02-0G 51-20-01-0G.SDR UPS09554599Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15R BS 1180. REPAIRED DAMAGE IAW UPS EO B757-5310-19952C AND B757 SRM 51-40-09-0G 51-20-01-0G, 51-40-02-0G.SDR UPS09554598Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15R BS 1100. REPAIRED DAMAGE IAW UPS EO B757-5310-19952C AND B757 SRM 51-20-01-0G 51-40-02-0G.SDR UPS09554597Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15R BS 1140. REPAIRED DAMAGE IAW UPS EO B757-5310-19952C AND B757 SRM 51-40-09-0G, 51-20-01-0G.SDR USAA2009020290258Frame · crackedCLT - Q5 - MAJOR REPAIR - FRAME REINFORCING ANGLE CRACKED AT BS 500C BETWEEN S20L TO S21L. REPAIRED FRAME REINFORCING ANGLE AT BS 500C BETWEEN S20L TO S21L IAW US AIRWAYS 100883.SDR UPS09554473Frame · damagedINSPECTION TYPE:C3 FRAME DAMAGE INBOARD FLANGE AT STR 15L BS 1140. REPAIRED DAMAGE IAW UPS EO B757-5310-19952-C AND 51-40-07-0G 51-20-01-0G, 51-40-02-0G.SDR ZZDA2009027Frame · crackedROLLED Z-FRAME CRACKED AT FUSELAGE STA 1098 RT BETWEEN L 11 & 13. CUT OUT DAMAGED AREA, REPAIRED PER B717 SRM 53-00-07 FIG 201.SDR USAA2009020690286Frame · crackedCLT - Q5 - MAJOR REPAIR - CRACK IN FRAME AT BS 500E BETWEEN S20L TO S21L. REPAIRED FRAME AT BS 500E BETWEEN S20L TO S21L IAW US AIRWAYS TYPICAL REPAIR 53-60-07A.SDR DL75E090111Frame · dentedFWD CARGO COMPT STA 580 STRINGER 25 L CIRCUMFERENTIAL FRAME DENTS, C/W AT SAA, SAT ON N/R 116219 SAA JOB 81998030001.SDR DL75E090110Frame · dentedFWD CARGO COMPARTMENT STA 600 STR 25L CIRCUMFERENTIAL FRAME DENTS, C/W AT SAA, SAT N/R 116220 SAA JOB 81998010001.SDR DLM88090106Frame · crackedCRACKED UPPER CAPS (2 EACH) ON FRAME 1437 BETWEEN LONGERON 2 RT AND 2 LT, NRC T0121147. CAPS WERE REMOVED. DOUBLERS WERE FABRICATED. REPAIR ANGLES WERE FABRICATED ERA 472134-14.SDR ZZDA2009024Frame · crackedCABIN - FWD ENTRY AFT FRAME WEB CRACKED AT STR 15 LT STA 200. FABRICATED WEB REPAIR PER B717 SRM 51-70-10 FIG 201.SDR SWAA090569Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090523Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 24L TO STR 25L. REPAIRED FRAME PER SRM.
Back to JASC 5311