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 USAA920080079Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 807, S9L. REPAIRED FRAME, BS 807, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920080074Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 492, S21R. REPAIRED FRAME, BS 492, S21R IAW USAIRWAYS EA 100079.SDR SWAA076474Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076473Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076475Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076477Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA076476Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076444Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR 2007UALA05193Frame · damagedAFT PIT STA 847 RBL 20 FRAME UPPER CHORD UPPER SURFACE HAS MISDRILLED FASTENER. SUSPECT MAINTENANCE MISTAKE. REMOVED DAMAGED FRAME AND REPLACED WITH NEW FRAME. AC OK FOR SERVICE.SDR LR7A07134Frame · crackedDURING SCHEDULED C-3 CHECK, PER JOB CARD HC5302 FOUND AFT FUSELAGE UPPER BHD FORMER CRACKED AT FS 817, WL257. REPAIR ACCOMPLISHED IAW SMP583 FIG 53-50-05.SDR USAA920080105Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME INNER CHORD, BS 312, S7R. REPLACED FRAME INNER CHORD, BS 312, S7R IAW B737 SRM 51-10-02.SDR SWAA076364Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076363Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076362Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR 07FDEA05099Frame · damagedMAIN CABIN FRAME HAS DEEP WEAR AT STA 1166 AND STR 8L REMOVED DAMAGE SECTION OF FRAME STA 1166 AT STR 8L. FABRICATED AND INSTALLED REPAIR DOUBLER, REF SRM 51-40-3 FIG 1. TREATED AND PRIMED REPAIR PARTS AND AREA. THIS IS CLASSIFIED AS A MAJOR REPAIR.SDR DALA1134639222Former · corrodedCHINA EASTERN AIRLINES PERFORMED TASK CARD 65061155, CORROSION ON FORMER Y1288 L29-R29 OF AFT CARGO COMPARTMENT SRM 53-10-03 VOL III, FIG 1 SRM 53-10-02 VOL I FIG 3.SDR DALA1134629222Former · corrodedCHINA EASTER AIRLINES PERFORMED TASK CARD 65061153, CORROSION ON FORMER Y1212 L29-R29 OF AFT CARGO COMPARTMENT SRM 53-10-03 VOL III, FIG 1 SRM 53-10-02 VOL I FIG 3.SDR DALA1134619222Former · corrodedCHINA EASTERN AIRLINES PERFORMED TASK CARD 65061150, CORROSION ON FORMER Y1269 L29-R29 OF AFT CARGO COMPARTMENT SRM 53-10-03 VOL III, FIG 1 SRM 53-10-02 VOL I FIG 3.SDR USAA920071380Frame · crackedCLT - MAJOR REPAIR - DROP IN - CRACKED FRAME, BS 492, 24R. REPAIRED FRAME, BS 492, 24R IAW USAIRWAYS EA 100113.SDR CALA0700775Frame · crackedFUSELAGE FRAME CRACKED AT STA 787 BETWEEN STRINGER 8L AND 9L. REPAIRED PER ECRA 5310-04684.SDR CALA0700774Frame · crackedFUSELAGE FRAME IS CRACKED STATION 827 BETWEEN STRINGERS 8L AND 9L. REPAIRED PER ECRA 5310-04684.SDR CALA0700773Frame · crackedFUSELAGE FRAME IS CRACKED STA 907 BETWEEN STRINGERS 8L AND 9L. REPAIRED PER ECRA 5310-04684.SDR CALA0700772Frame · crackedFUSELAGE FRAME IS CRACKED STA 727B BETWEEN STRINGERS 8R AND 9R. REPAIRED PER ECRA 5310-04684.SDR CALA0700771Frame · crackedFUSELAGE FRAME IS CRACKED STATION 867 BETWEEN STRINGERS 8L AND 9L. REPAIRED PER ECRA 5310-04684.SDR CALA0700770Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 747 BETWEEN STRINGERS 8L AND 9L. REPAIRED PER ECRA 5310-04684.SDR CALA0700769Frame · crackedCABIN STATION 440 BETWEEN STRINGER 8 AND 9 PSU RAIL ATTACH BRACKET TO FRAME CRACKED LEFT SIDE. REPAIRED PER ECRA 5310-04684.SDR CALA0700768Frame · crackedCABIN STA 400 BETWEEN RIGHT STRINGER 8 AND PUS RAIL ATTACH BRACKET TO FRAME CRACKED. REPIARED PER ECRA 5310-04684.SDR CALA0700767Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 787 BETWEEN STRINGER 8R AND 9R. REPAIRED PER ECRA 5310-04684.SDR CALA0700766Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 867 BETWEEN STRINGERS 8R AND 9R REPAIRED PER ECRA 5310-04684.SDR 2007UALA05165Frame · damagedBS 1500 FRAME BETWEEN STR 28R - 29R HAS DAMAGE. FRAME REPAIR BETWEEN STR 28R-29R HA S BEEN DEEMED INTERIM WITH REPEAT INSPECTIONS EVERY 12000 CYCLES.SDR SWAA076332Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076331Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076347Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND BELTFRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SWA EA.SDR 265121707AFrame · corrodedAT SCHEDULED INSPECTION, DISCOVERED (3) SPOTS OF CORROSION ALONG FRAME 23 BETWEEN STRINGERS 20L AND 20R. CORROSION DID NOT PENTRATE TO FRAME 23, OR STRINGERS, REMOVED DAMAGED AREA AS ONE ENCOMPASSING AREA AND INSTALLED EXTERNAL DOUBLER. REFERENCE MFG ENGINEESDR USAA920080096Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 440, S8R. REPAIRED FRAME, BS 440, S8R IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR SWAA076287Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076286Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076288Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076282Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076283Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076284Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076320Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076321Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076322Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0700764Frame · damagedFUSELAGE FRAME STA 727C MIS-DRILLED. REPAIR PER ECRA 5310-04683.SDR CALA0700763Frame · crackedFRAME CRACKED AT STA 727C B/W STR 8RT 9RT. INSTALLED REPAIRED PER ECRA 5310-04683.SDR SWAA076266Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR 1218369042108Frame · corrodedCORROSION AND BARE METAL FOUND AT BELLY FRAME 28. CORROSION REMOVED FROM BELLY FRAME 28 RIGHT AND LEFT WEB. BELLY FRAME 28 LEFT AND RIGHT WEBS REPLACED IN ACCORDANCE WITH SRM.SDR USAA920071326Frame · crackedCLT - MAJOR REPAIR - FPBH - A .375 X .375 INCH L SHAPED CRACK ON FWD FRAME LOWER STOP FITTING OF FWD CARGO DOOR OPENING AT BS 440, S24R. REMOVED DAMAGE, INSTALLED DOUBLER AND TRIPLER. A 4000 FC REPETITIVE INSPECTION REQUIRED IAW US AIRWAYS EA-100077.SDR 1218368042108Frame Splice · corrodedCORROSION FOUND ON BELLY FRAME 27. CORROSION REMOVED, FRAME REPAIRED IN ACCORDANCE WITH SRM.
Back to JASC 5311