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 CALA0800772Frame · crackedFRAME CRACKED STATION 727B AT S-9L. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS REF EA5310-04498.SDR CALA0800771Frame · crackedFRAME CRACKED STATION 787 AT S-9R. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS REF EA 5310-04498.SDR SWAA084366Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500A, STR 28L, WL 148. REPAIRED FRAME PER SRM.SDR USAA920081471Frame · crackedPHX-RON -MAJOR REPAIR- FRAME AT BS 460 S16R IS CRACKED AT SKIN ATTACHMENT. REPAIRED FRAME AT BS 460 S16R IAW B737 SRM 53-00-07-2R7 REPAIR 7. (S)SDR CALA0800769Frame · crackedFRAME CRACKED STATION 440 AT S-9L. REPAIRED CRACKED FRAME AT STATION 440 STR-9L REF EA 5310-04498 OP 02.SDR CALA0800768Frame · crackedFRAME CRACKED STATION 380 AT S-9R. REPAIRED FRAME REF EA 5310-04498 OP 2.SDR SWAA084323Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084322Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084321Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084332Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084331Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 967, STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA084320Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084319Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084318Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084316Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084315Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 747, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA084302Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, STR 25L TO BS 26L. REPAIRED FRAME PER SRM.SDR SWAA084293Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084292Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084291Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084290Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084289Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084288Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084284Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084283Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084282Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084281Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084280Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084279Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0800765Frame · crackedFRAME CRACKED STATION 867 AT S-9L. INSTALLED REPAIR DOUBLERS PER EA 5310-04498, OP 2.SDR CALA0800764Frame · crackedFRAME CRACKED STATION 787 AT S-9L. REPAIRED FRAME PER EA 5310-04498 OP 2.SDR CALA0800763Frame · crackedFRAME CRACKED STATION 867 AT S-9R. INSTALLED REPAIR ANGLES PER EA 5310-04498, OP 2.SDR 2008UALA04105Frame · damagedFWD PIT STA 580 FRAME INNER FLANGE BETWEEN S-24L AND S-25L DENTED. ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGED FRAME SECTION AND INSTALLED DOUBLER REPAIR PER SRM.SDR 2008UALA04104Frame · dentedFWD PIT AT STA 660, STR 23L, FRAME DENTED AT INBOUND FLANGE. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND INSTALLED DOUBLER REPAIR PER SRM 53-00-07, REPAIR 5.SDR 2008UALA04103Frame · dentedAFT PIT STA 1480 FRAME INNER FLANGE DENTED AT S-26L. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND INSTALLED DOUBLER REPAIR PER SRM 53-00-07, REPAIR 5.SDR 2008UALA04101Frame · dentedAFT PIT STA 1440 FRAME INNER FLANGE DENTED IN 2 EACH PLACES BETWEEN S-25L TO 26L. *S/D* ACCOMPLISHED MAJOR REPAIR AT GSO. CUT OUT DAMAGE AND INSTALLED DOUBLER REPAIR PER SRM 53-00-07, REPAIR 5.SDR UPS08553060Frame · damagedINSPECTION TYPE-C2, WHILE WORKING FWD CARGO COMP FRAME AT BS 820 BETWEEN STR 246 & 256 MISDRILLED FRAME AT STR 26L. CUT OUT DAMAGE AND SPLICED IN REPAIR FRAME SECTION.SDR CALA0800762Frame · crackedFRAME CRACKED STATION 907 AT S-9R. REPAIRED FRAME PER EA 5310-04498, OP 2.SDR CALA0800761Frame · crackedFRAME CRACKED STATION 747 AT S-9R. REPAIRED FRAME PER EA 5310-04498 OP 2.SDR SWAA084278Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084277Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR CALA0800759Frame · crackedFRAME CRACKED STATION 440 AT S-9R. REPAIRED FRAME REF EA 5310-04498 OP 2.SDR CALA0800758Frame · crackedFRAME CRACKED STATION 482 AT S-9 R. REPAIRED PER EA 5310-04498.SDR CALA0800757Frame · crackedFRAME CRACKED STATION 400 AT S-9R. CUT OUT DAMAGE AND INSTALLED REPAIR DOUBLERS REF EA 5310-04498.SDR USAA920081504Frame · crackedCLT-Q6 - MAJOR REPAIR - CRACK ON FRAME AT BS 847 BETWEEN S8L & S9L. REPAIRED FRAME AT BS 847 BETWEEN S8L & S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E. (S)SDR UPS08553062Frame · dentedINSPECTION TYPE-C2, FRAME DENTED ON IB FRAME BS 1500, STR 23L, TRIMMED OUT DAMAGED AREA FABRICATED & INSTALLED REPAIR PARTS.SDR SWAA084259Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 440, STR 25L. REPAIRED FRAME PER SRM.SDR SWAA084258Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084256Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 11R. REPAIRED FRAME PER SRM.SDR SWAA084253Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 14L. REPAIRED FRAME PER SWA EA.
Back to JASC 5311