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 SWAA075454Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075453Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075452Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075456Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075468Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075467Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075433Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED SKIN PER SWA EA.SDR SWAA075432Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED SKIN PER SWA EA.SDR SWAA075431Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED SKIN PER SWA EA.SDR SWAA075414Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075413Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075412Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR 2007UALA04509Frame · dentedAFT PIT STA 1480 MAIN FRAME AT STR 26L FRAME HAS 2 DENTS. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE AND INSTALLED ANGLE REPAIR.SDR 2007UALA04506Frame · dentedFWD PIT STA 520 MAIN FRAME BETWEEN STR 24L AND 25L FRAME HAS 2 DENTS.
SDR CALA0700630Frame · crackedINSPECTION FOUND A .5 INCH CRACK AT FORWARD FASTENER HOLE OF FRAME BETWEEN STRINGER 8R AND 9R, STA 727-827. A DOUBLER AND STRAP WERE INSTALLED IAW ECRA 5310-04668, REV B.SDR 07FDEA04705Frame · corrodedUPPER LOBE STATION 700 FRAME, BELOW STRINGER 1L IS CORRODED. REMOVED CORR ON BS 700 FRAME IAW SRM 53-00-07. ORIGINAL MATERIAL THICKNESS WAS .063". MATERIAL REMOVED WAS .018". MATERIAL REMAINING WAS .046", OUT OF LIMITS PER SRM 53-00-07. FABRICATED REPAIRSDR SWAA075440Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 27R. REPAIRED FRAME PER SRM.SDR 2007UALA04474Frame · crackedBS 1265 LEFT FRAME WEB CRACKED AT NR 1 FASTENER HOLE. REPAIRED FRAME WEB ACCOMPLISHED COA 897887102. AC OK FOR SERVICE.
SDR ABXA070413Frame · corrodedFORWARD LOWER CARGO FRAME AT STATION 579 WAS CORRODED AT LONGERON 30. REPAIRED FRAME IN ACCORDANCE WITH DC9 SRM 53-03.SDR TRAX200701617Frame · corrodedFR 38 BETWEEN STR 20-21L CORRODED. REMOVED CORROSION ON FR38 BTW STR 20-21L AS PER SRM 51-21-42 AND WITHIN LIMITS AS PER SRM 53-61-00 MATERIAL THICKNESS: 0.063 MATERIAL REMOVED: 0.003 WITHIN LIMITS AS PER SRM: 53-61-00 FIG 301.SDR 2007UALA04463Frame · corrodedMAIN CABIN FRAME CAP CORRODED STA 246 BL80R TO BL84R. SUSPECT MOISTURE CONTAMINATION. REMOVED CAP SECTION AND FABRICATED NEW SECTION. ACFT OK FOR SERVICE.SDR SWAA075383Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075384Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075370Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075369Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075378Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075377Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075376Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075368Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075387Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075385Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075371Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075386Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075375Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075367Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR CALA0700625Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN FUSELAGE FRAME AT STA 767, S9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04669.SDR CALA0700624Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN FUSELAGE FRAME AT STA 867, S9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04669.SDR CALA0700623Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN FUSELAGE FRAME AT STA 480 BETWEEN S8L AND S9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04669.SDR CALA0700622Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN FUSELAGE FRAME AT STA 480 BETWEEN S8R AND S9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04669.SDR 07FDEA04692Frame Splice · crackedFWD LOWER CARGO SPLICE FRAME AT STA 580 BETWEEN STR 21L AND 22L HAS A CRACK. REMOVED 53FX1350 SPLICE FRAME, FABRICATED AND INSTALLED NEW SPLICE FRAME IAW 727 SRM 51-10-01 AND FEDEX DRG 53FX1370.SDR USAA920071052Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 312, S7R - S8R. REPLACED FRAME, BS 312, S7R - S8L IAW B737 SRM 51-40-03.SDR 2007UALA04439Frame · corrodedMAIN CABIN FRAME T-CAP CORRODED STA 303 BL51R TO BL55R. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF T-CAP. FABRICATED T-CAP SPLICE. INSTALLED TEE CHORD, ANGLE & SPLICE REPAIR.SDR CALA0700620Frame · crackedINSPECTION FOUND A . 5 INCH CRACK IN AFT SIDE OF FUSELAGE FRAME AT STA 440 AROUND RIVET BELOW S8R. THE FRAME WAS REPAIRED IAW ECRA 5310-04668.SDR CALA0700619Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN AFT SIDE OF FUSELAGE FRAME AT STA 380 AROUND RIVET BELOW S8R. THE FRAME WAS REPAIRED IAW ECRA 5310-04668.SDR CALA0700618Frame · crackedINSPECTION FOUND A .5 INCH CRACK AT FORWARD FASTENER HOLE OF FRAME AT STA 787 BETWEEN STRINGERS 8L AND 9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04668.SDR CALA0700617Frame · crackedINSPECTION FOUND A 5 INCH CRACK AT FORWARD FASTENER HOLE OF FRAME AT STA 867 BETWEEN STRINGERS 8L AND 9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04668.SDR CALA0700616Frame · crackedINSPECTION FOUND A .5 INCH CRACK AT FASTENER HOLE OF FRAME AT STA 827 BETWEEN STRINGERS 8L AND 9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04668.SDR CALA0700615Frame · crackedINSPECTION FOUND A .5 INCH CRACK AT FORWARD FASTENER HOLE OF FRAME AT STA 787 BETWEEN STRINGERS 8R AND 9R. THE FRAME WAS REPAIRED IAW ECRA 5310-04668.SDR CALA0700614Frame · crackedINSPECTION FOUND A .5 INCH CRACK AT FORWARD FASTENER HOLE OF FRAME AT STA 747 BETWEEN STRINGERS 8L AND 9L. THE FRAME WAS REPAIRED IAW ECRA 5310-04668.SDR CALA0700613Frame · crackedINSPECTION FOUND A .5 INCH CRACK IN AFT SIDE OF FUSELAGE FRAME AT STA 400 AROUND RIVET BELOW S8L. THE FRAME WAS REPAIRED IAW ECRA 5310-04668.
Back to JASC 5311