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 USAA920080014Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 727B, S8L - S9L. REPAIRED FRAME, BS 727B, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080013Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 727D, S8L - S9L. REPAIRED FRAME, BS 727D, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080012Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 747, S8L - S9L. REPAIRED FRAME, BS 747, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080011Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 787, S8L - S9L. REPAIRED FRAME, BS 787, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080010Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 827, S8L - S9L. REPAIRED FRAME, BS 827, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920080009Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 867, S8L - S9L. REPAIRED FRAME, BS 867, S8L - S9L IAW USAIRWAYS EA 100111.SDR USAA920071346Frame · crackedMCN - MAJOR REPAIR - C-16 CHECK - A CRACK FOUND ON FUSELAGE FRAME BS 188, LBL 31, WL 207. REMOVED DAMAGE AND INSTALLED FILLER IAW B737-300 SRM 53-00-07-2R11.SDR USAA920071345Frame · crackedMCN - MAJOR REPAIR - C-16 CHECK- A CRACK FOUND AT BS 188, RBL 31 WL 207. REMOVED DAMAGE AND INSTALLED FILLERS IAW B737-300 SRM 53-00-07-2R11.SDR USAA920071272Frame · crackedCLT - MAJOR REPAIR-C-18- NR I1C53037/7, CRACK ON FRAME AT BS 400 BETWEEN S8R & S9R. REPAIRED IAW EA10048.SDR 07FDEA05009Frame · misrepairedPREVIOUS REPAIR LOCATED IN BULK CARGO ON FRAME 64 UNDER FLOOR BETWEEN STRINGER 46 AND 48 RT HAS 2 EACH REPAIR ANGLES ON THE AFT SIDE MEASURING 14.4" BY 2.9" AND 13.6" BY 2.2" PREVIOUS INSTALLED REPAIR WAS DETERMINED NOT TO BE IAW FEDEX EA6-5310-68347, DUE TOSDR USAA920080086Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 827, S9R. REPAIRED FRAME, BS 827, S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-25.
SDR USAA920080017Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 747, S8R - S9R. REPAIRED FRAME, BS 747, S8R - S9R IAW USAIRWAYS EA 100111.SDR USAA920080016Frame · crackedMCN - MAJOR REPAIR - C16 CHECK - CRACKED FRAME, BS 827, S8R - S9R. REPAIRED FRAME, BS 827, S8R - S9R IAW USAIRWAYS EA 100111.SDR USAA920071268Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/15, FRAME 847 RIGHT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071267Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/6, FRAME 727E CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071266Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/14, FRAME 827 RIGHT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071265Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/12, FRAME 787 RIGHT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071264Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/11, FRAME 847 LEFT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071263Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/13, FRAME 807 RIGHT IS CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. REPAIRED IAW EA100048, TR53-10-20E.SDR USAA920071262Frame · crackedCLT - MAJOR REPAIR-C-18-NR I1C53034/10, FRAME 827 LEFT CRACKED AT RIVET FOR BIN RAIL ATTACHMENT. INSTALLED REPAIR IAW EA100048, TR53-10-20E.SDR SWAA076034Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR KCSA071529Frame · damagedDAMAGED STRUCTURE BEHIND LT COUNTER BALANCE WHEEL FOR FLIGHT DECK STAIRS AT STA 460 TO 480, WL 305, LBL 35.SDR QXEA200801890Frame · corrodedPDX -C5 CHECK - CORROSION ON FORWARD SIDE OF FRAME X202 BETWEEN STRINGER 30R AND 32R. REPAIRED IAW CPM CHAPTER 4 AND -8 200 SRM 51-20-11, 51-20-16, 51-20-36, AND 51-20-51 ALSO -8 200 NDTM 51-00-01.SDR QXEA200801868Frame · corrodedPDX - C5 CHECK - CORROSION ON FRAME X242 LOWER CASTELLATION AT STRINGER X222. REPAIRED IAW -8 200 SRM 51-20-91, 51-40-11, 51-20-16, 51-20-36, 51-20-57 AND -8 200 CPM CHAPTER 4, NDTM 51-00-01SDR QXEA200801952Frame · crackedPDX - C5 CHECK - FRAME AT STATION X312, 8 INCHES FROM CENTER LINE IS CRACKED AT TOP FLANGE. REMOVED DAMAGED FRAME SECTION, INSTALLED FRAME SPLICE IAW RD8-53-9913 AND D8 200 SRM 51-40-11.SDR DHL2007742052Frame · damagedFUSELAGE FRAME STATION 420 FRAME AND STRAP HAVE NUMEROUS HOLES DRILLED THROUGH BETWEEN STRINGER 7R AND 8R. REMOVED STRAPS AND FRAME ATTACHED PARTS FOR ACCESS IAW B-727 SRM 51-30-2. CUT OUT DAMAGED SECTION OF FRAME (DIMENSION 40" BY 5") IAW B-727 SRM 51-10-1.SDR DHL2007742051Frame · damagedFUSELAGE FRAME STATION 380, FRAME AND STRAPS HAVE NUMEROUS HOLES DRILLED THROUGH FROM STRINGER 5R TO STRINGER 10R. REMOVED STRAPS AND FRAME ATTACHED PARTS FOR ACCESS IAW B-727 SRM 51-30-2. CUT OUT DAMAGED SECTION OF FRAME (DIMENSION 26" BY 5") IAW B-727 SRM SDR ABXA070429Frame · crackedFRAME CRACKED AT FASTENER FS 1150 CANTED AT LONGERON 4 LEFT. REMOVED FRAME, REPAIRED AND REINSTALLED IAW DC9 SRM 53-03, FIGURE 30, 51-30-02, AND 51-30-05.SDR NWAA074136307Frame · crackedDURING "M" CHECK, FOUND 3 HOLES WITH CRACKS AT BS 1180 FRAME TENSION TIE AREA. REPAIRED PER EA 63-211310.SDR MALA070190Frame · misrepairedPREVIOUS REPAIR TO UNDERFLOOR FRAME STA 258 CENTER FUSELAGE REQUIRES ADDITIONAL WORK. REPAIRED SECTION IAW EO NR S53108.
SDR 2007UALA04959Frame · damagedAFT PIT BS 1360 FRAME HAS DENT AND MINOR SURFACE CORROSION AT STR 25L. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED SECTION OF FRAME. FABRICATED & INSTALLED A REPAIR ANGLE.SDR SWAA076012Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA076013Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076014Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR GLBA20061031Frame · crackedFRAME CRACKED AT F.S. 164.4 AND STRINGER 9R. CRACK APPROXIMATELY .750 INCH IN LENGTH. MAINTENANCE REPAIRED FRAME CRACK AT F.S. 164.4 AND STRINGER 9R IAW SRM 51-70. REPAIR APPROXIMATELY 5.5 BY 2.5 INCHES. 2024-T3 .O71 INCHES RII INSPECTION COMPLIED IAW GLA TASSDR USAA920071314Frame · crackedCLT - MAJOR REPAIR - C18 CHECK, CRACKED FRAME BS 480, S8R. REPAIRED FRAME, BS 480, S8R IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR USAA920071295Frame · crackedPIT - MAJOR REPAIR - C3 CHECK, CRACKED FRAME CHORD, BS 1580, S26L - S27L. REPAIRED FRAME CHORD, BS 1580, S26L - S27L IAW USAIRWAYS EA 110324.SDR SIMA200734105Frame · corrodedDURING MBV INSPECTION THE FRAME AT F.S. 272.0 WAS FOUND CORRODED. CUT OUT CORRODED ON FRAME INSTALLED NEW FRAME IAW SAAB SRM 53-70-30 AIRCRAFT RETURN TO SERVICE.SDR SIMA200734106Frame · corrodedDURING MBV INSPECTION, THE FRAME AT FS 294.0 WAS FOUND CORRODED. CUT OUT CORRODED AREA OF THE FRAME INSTALLED NEW FRAME IAW SAAB SRM 53-70-30. AIRCRAFT RETURN TO SERVICE.SDR SWAA075982Frame · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075994Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075975Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075976Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075977Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075989Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075990Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075991Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075992Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR USAA920080082Frame · crackedCLT - MAJOR REPAIR - C18 CHECK - CRACKED FRAME, BS 867, S9L. REPAIRED FRAME, BS 867, S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-25.SDR SIMA200733903Frame · corrodedDURING MBV INSPECTION THE FRAME AT FS 225.0 WAS FOUND TO BE CORRODED. REPAIRED FRAME AT FS 225.0 PER SAAB SRM (72LKS 3079 REV49) CHAPTER 53-70-30. AIRCRAFT RETURNED TO SERVICE.
Back to JASC 5311