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 ASAA0843157Frame · crackedFRAME CRACKED. REPAIRED FRAME PER EA 5310 02797.SDR ASAA0843156Frame · crackedFRAME CRACKED AT PSU RAIL BRACKET. REPAIRED FRAME PER EA 5310 02797.SDR ASAA0843139Frame · corrodedAFT CARGO PIT BS 767 BETWEEN 25R AND 26R LOWER FLANGE OF FRAME (AFT SIDE) HAS CORROSION. AFT CARGO PIT B767 BETWEEN STRINGER 25R 26R LOWER FLANGE REPAIRED IAW B737 400 SRM 51 70 11. REPAIRED WITH REPAIR PART.SDR ASAA0843134Frame · crackedRIGHT FRAME AT STA 867 CRACKED AT PSU RAIL BRACKET. REPAIRED PER EA 5310 02797.SDR ASAA0843131Frame · crackedRIGHT FRAME AT STA 787 CRACKED AT PSU RAIL BRACKET. REPAIRED PER EA 5310 02797.SDR ASAA0843130Frame · crackedRIGHT FRAME AT STA 747 AT PSU RAIL BRACKET CRACKED. REPAIRED PER EA 5310 02797.SDR ASAA0843128Frame · crackedRIGHT FRAME AT STA 727B CRACKED AT PSU RAIL BRACKET. RIGHT FRAME AT STA 727B AT PSU RAIL BRACKET REPAIRED IAW CASCADE ERO 8337 ASA EA 5310 02797.SDR ASAA0843127Frame · crackedRIGHT FRAME AT STATION 500A CRACKED AT PSU RAIL BRACKET. RIGHT FRAME AT STATION 500A AT PSU RAIL BRACKET REPAIRED IAW CASCADE ERO 8337 AND ASA EA 5310 02797.SDR ASAA0843126Frame · crackedRIGHT FRAME AT STATION 480 CRACKED AT PSU RAIL BRACKET. RIGHT FRAME AT STATION 480 AT PSU RAIL BRACKET REPAIRED IAW CASCADE ERO 8337 ASA EA 5310 02797.SDR ASAA0843124Frame · crackedRIGHT FRAME AT STA 440 CRACKED AT PSU RAIL BRACKET. REPAIRED PER EA 5310 02797.SDR ASAA0843123Frame · crackedLEFT FRAME AT STA 867 CRACKED AT PSU RAIL BRACKET REPAIR PER EA 5310 02797.SDR ASAA0843119Frame · crackedRIGHT FRAME AT PSU RAIL BRACKET CRACKED REPAIR PER EA 5310 02747.SDR ASAA0843088Frame · crackedLT SIDE FRAME AT STA 727D CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843087Frame · crackedLT SIDE FRAME AT STA 500A CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843084Frame · crackedLT SIDE FRAME AT STA 440 CRACKED AT PSU RAIL BRACKET. REPAIRED FRAME IAW ASA EA5310 02797.SDR ASAA0843083Frame · crackedLT FRAME AT STA 360 CRACKED AT PSU RAIL BRACKET. REPAIRED IAW EA5310 02797.SDR ASAA0843074Frame · crackedRT FRAME AT STA827 CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843095Frame · crackedRT FRAME AT STA 907 CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843094Frame · crackedLT FRAME AT STA 907 CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843093Frame · crackedLT FRAME AT STA 787 CRACKED AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR ASAA0843092Frame · crackedLT SIDE FRAME AT STA 727F CRACK AT PSU RAIL BRACKET. FRAME REPAIRED IAW ASA EA5310 02797.SDR COMA0860238Frame · crackedDURING FS 640 FRAME INSPECTION FOUND FORWARD FRAME CRACKED ON RT SIDE BELOW ENGINE SUPPORT BEAM. CUT OUT DAMAGED SECTION OF FRAME AND REPLACED WITH SPLICED IN REPAIR TO FRAME AND BONDED DOUBLER PER REO 601R-53-61-506, REV C.SDR UIEA200800203Frame · deformedMAIN DECK STA 1900 STRINGER 13R TO 14R FRAME FOUND DEFORMED. REPAIRED FRAME PER SRM 53-10-04.SDR USAA920081037Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - CRACKED FRAME, BS 727B, S8L - S9L. REPAIRED FRAME, BS 727B, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR 08FDEA01784Frame · damagedMAIN DECK INTERIOR FUSELAGE AT LEFT STA 535 FRAME, UPPER SUPPORT YOKE FOUND DAMAGED. MAIN DECK INTERIOR FUSELAGE AT LEFT HAND STA 535, UPPER SUPPORT YOKE, DAMAGED FRAME REPAIRED AS PER FEDEX DRAWING SRZ-53-503. REPAIR CLASSIFIED AS MINOR PER GMM 6-2- 100.SDR 2008UALA02661Frame · dentedAFT PIT STA 1540 STR 26L FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE AND INSTALLED "J" ANGLE REPAIR.SDR 2008UALA02660Frame · dentedAFT PIT BS 1400 AT STR 26L FRAME DENTED. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE AND INSTALLED "J" ANGLE REPAIR.SDR 2008UALA02659Frame · corrodedCORROSION UNDER NUTPLATE ON THE UNDERSIDE OF THE BILGE FRAME T-CAP AT BS 1197+132, LBL 18. MAJOR REPAIR ACCOMPLISHED: REMOVED CORROSION. INSTALLED STRAP & ANGLE REPAIR.SDR SWAA082512Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0800420Frame · crackedCABIN STATION 827RT BETWEEN S8R AND S9R PASSENGER SERVICE UNIT RAIL ATTACH BRACKET TO FRAME CRACKED. REPAIRED FRAME AT STA 827AND STR 8R + STR 9R PER EA 5310-04498.SDR ASAA0843161Frame · dentedAFT CARGO PIT BS 727E BETWEEN STRINGER 22L & 23L TOP FLANGE OF FRAME DENTED. AFT CARGO PIT FRAME REPAIRED AT BS 727E STRINGER 22L TO 23L IAW B737 400 SRM 51 70 11 FIG 1.SDR ASAA0843150Frame · dentedAFT CARGO PIT BS 727C BW STR 24R 25R TOP FLANGE OF FRAME DENTED. AFT CARGO PIT FRAME BS 727C STR 24R 25R REPAIRED IAW B737 400 SRM 51 70 11.SDR ASAA0843149Frame · dentedAFT CARGO PIT BS 727E AT STR 24R FRAME DENTED ON TOP FLANGE. AFT CARGO PIT BS 727E AT STR 24R FRAME REPAIRED IAW B737 400 SRM 51 70 11.SDR ASAA0843147Frame · dentedAFT CARGO PIT BS 727C AT STR 25L TOP FLANGE OF FRAME DENTED. REPAIRED WITH REPAIR PART IAW B737 400 SRM.SDR ASAA0843082Frame · crackedLT FRAME AT STA 400 CRACKED AT PSU RAIL BRACKET. REPAIRED IAW ASA EA5310 02797.SDR 08FDEA01766Frame · dentedCABIN : AFT CABIN AT APPROXIMATELY STATION 1741 LT LONGERON 12 FOUND FRAME DENTED. REPAIRED PER SRM 53-30-00 FIG.1, VOL.I. REPETITIVE INSPECTION REQUIRED, INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PERSDR 2008UALA02652Frame · dentedAFT PIT BS 1620 AT STR 26L FRAME DENTED. MAJOR REPAIR ACCOMPLISHED, CUTOUT DAMAGE. INSTALLED 'J' ANGLE REPAIR.SDR 2008UALA02651Frame · dentedAFT PIT BS 1540 AT STR 25R FRAME DENTED. MAJOR REPAIR ACCOMPLISHED, REMOVED DAMAGE. INSTALLED "J" ANGLE REPAIR.SDR 2008UALA02649Frame · damagedFRAME REPAIRED AT BS 580 BETWEEN STR'S 22L AND 23L. MAJOR REPAIR ACCOMPLISHED, INSTALLED NEW FRAME REPAIR.SDR USAA920081038Frame · crackedCLT - MAJOR REPAIR - Q6 CHECK - CRACKED FRAME, BS 727F, S8R - S9R. REPAIRED FRAME, BS 727F, S8R - S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR SWAA082495Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082497Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082496Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA082494Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA082498Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 11L. REPAIRED FRAME PER SWA EA.SDR 08FDEA01769Frame · dentedAFT CABIN AT APPROXIMATELY STATION 1681 LEFT SIDE LONGERON 12 FOUND FRAME DENTED. REPAIRED AS PER SRM 53-30-00 FIG.1,VOL.I. REPETITIVE INSPECTION REQUIRED, INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SDR 08FDEA01768Frame · dentedAFT CABIN AT APPROXIMATELY STATION 1701 LEFT SIDE LONGERON 12 FOUND FRAME DENTED. REPAIRED PER SRM 53-30-00 FIG 1, VOL I. REPETITIVE INSPECTION REQUIRED, INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES TO BE CARRIED OUT AS PER SSDR 08FDEA01767Frame · dentedAFT CABIN AT APPROXIMATELY STATION 1721 LT LONGERON 12 FOUND FRAME DENTED. REPAIRED AS PER SRM 53-30-00 FIG.1,VOL.I. REPETITIVE INSPECTION REQUIRED, INITIAL INSPECTION AT 14,500 CYCLES AND REPETITIVE INSPECTION AT 9,500 CYCLES AS PER SRM 53-30-00, FIG.1, VOL.SDR GTI2008F00000Frame · corrodedFRAME 69 LT AND RT HAVE EVIDENCE OF CORROSION. REMOVED AND REPLACED SHEAR PLATES. (K)SDR ASAA0843132Frame · corrodedAFT CARGO COMPARTMENT FRAME AT BS 727G IS CORRODED BETWEEN STRINGER 25R AND 26R. REPAIRED WITH REPAIR PART IAW B737 400 SRM.
Back to JASC 5311