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 UIEA200700502Frame · crackedFRAME AT STATION 1140 RT HAS A CRACK AT STRINGER 10 AND 10A LOCATION. CRACK AT STR 10A 0.500 INCH LONG AND STR 10 IS 0.750 IN LONG. PERMANENT REPAIR ACCOMPLISHED AS PER B747-300 SRM 53-10-04 FIG 123 AND BOEING MESSAGE NUMBER 1-711332103-6 AND FAA FORM 8100-9SDR UIEA200700501Frame · crackedFRAME AT STATION 1140 LT HAS A CRACK AT STRINGER 10 AND 10A LOCATION. CRACK AT STR 10A 0.875 INCH LONG AND STR 10 IS 0.760 INCH LONG. PERMANENT REPAIR ACCOMPLISHED AS PER B747-300 SRM 53-10-04 FIG 123 AND BOEING MESSAGE NUMBER 1-711332103-6 AND FAA FORM 8100SDR COMA0760724Frame · damagedBAGGAGE CART STRUCK AIRCRAFT JUST AFT OF APU EXHAUST. REPLACED FRAME SECTION STA 700 PER SRM 51-42-06.
SDR COMA0760723Frame · damagedBAGGAGE CART STRUCK AIRCRAFT JUST AFT OF APU EXHAUST. REPLACED FRAME SECTION STA 736 PER SRM 51-42-06.SDR COMA0760718Frame · damagedBAGGAGE CART STRUCK AIRCRAFT JUST AFT OF APU EXHAUST. REPLACED FRAME SECTION 718 PER SRM 51-42-06 AND SRM 51-42-20.SDR SWAA076216Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076204Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076205Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076206Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076207Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076208Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076209Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076210Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076211Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076203Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076215Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076212Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076217Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076218Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076219Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076220Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076213Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076201Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076202Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076214Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076191Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076189Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076230Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076231Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076229Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076232Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076234Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076235Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076233Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076190Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076246Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND STUB FRAME CRACKED AT BS 294.5, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA076245Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076197Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD FITTING CHORD CORRODED AT BS 1016, RBL 29. REPAIRED CHORD PER ER.SDR SWIA200719416Frame · crackedFOUND AT C-CHECK, CRACK IN LOWER FRAME AT STA280 AND LBL10. COMPLIED WITH REPAIRS AT STA 280 AND LBL10 PER REO 601R-53-11-171.
SDR SWIA200719415Frame · crackedFOUND AT C-CHECK, LOWER FRAME AT STA 280 AND RBL10 IS CRACKED. COMPLIED WITH REPAIRS AT STA 280 AND RBL10 PER CRJ200 REO601R 53-11-1314.
SDR USAA920080083Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 907, S9L. REPAIRED FRAME, BS 907, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR ASAA0782377Frame · crackedAFT ACCESSORY COMPT FRAME STA 1418 CRACKED AT LONGERON 2R. REMOVED DAMAGED SECTION OF FRAME LOCATED DRILLED AND INSTALLED A REPLACEMENT FRAME SECTION IAW MD 80 SRM 51-30-2 PG 1 AND 51-30-5 PG 1 AND ASA EA 5310 02749.SDR FDEA200712115024Frame · crackedMAIN CABIN FOUND 1 CRACK ON FRAME STA 1741, STR 14, RT. REPAIRED AREA IAW SRM 53-30-00 FIG 5 VOL I AND EA NR 8-5310-111521, 8-5330-111563.SDR 07FDEA05024Frame · crackedMAIN CABIN FOUND 1 CRACK ON FRAME STA 1741 STR 14 RT REPAIRED IAW SRM 53-30-00 FIG 5 VOL I AND EA NR 8-5380-111563.SDR SWAA076165Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076160Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076159Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076154Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076153Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR 121836042008Frame · corrodedFRAME 44 AFT FACE CORRODED AT JUNCTION OF LEFT AND RIGHT SEAT TRACK, FOUND TO BE OUT OF LIMITS. NEW FRAME SEGMENT WAS SPLICED IN, IN ACCORDANCE WITH SRM.
Back to JASC 5311