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 2005UALA00221Frame · dentedAFT PIT AT STA 1540, APPROX AT STR 26R FRAME IS DENTED ON THE INBOARD FLANGE. FRAME FLANGE WAS REPAIRED USING NESTED J-ANGLES.SDR USAA050369Frame · corrodedPIT - FOUND FLOOR FRAME CORRODED 2.5 INCH LONG BY 2 INCH WIDE BY .15 INCH DEEP, MAIN CABIN FLOOR BS 347, RBL 54.75. ACCOMPLISHED T-CAP REPAIR PER 53-00-51 FIG 201 SHT 1. (M)SDR 05FDEA00433Frame · dentedFRAME IS DENTED ON I/B FLANGE AT BS 500 BETWEEN STR'S 23 LT AND 25 LT. REMOVED DAMAGE ON FRAME BS 500 BETWEEN STR 23L AND 25L. FABRICATED DOUBLER, MATERIAL 7075-T6 0.63", LOT #181795 IAW SRM 51-40-3, ALODINED, PRIMED, INSTALLED PER SRM 51-20-2, MM 51-20-1SDR 05FDEA00431Frame · dentedFRAME IS DENTED ON I/B FLANGE AT BS 560 BETWEEN STR'S 24 LT AND 25 LT. REPAIRED PER SRM 51-40-3, 51-10-2, MM 51-20-151-7 AND SRM 51-30-2SDR 05FDEA00432Frame · dentedFRAME IS DENTED ON I/B FLANGE AT BS 680 BETWEEN STR'S 23 LT AND 25 LT. REPAIRED PER SRM 51-40-3SDR 05FDEA00430Frame · dentedFRAME IS DENTED ON I/B FLANGE AT BS 660 BETWEEN STR'S 23 LT AND 25 LT. REPAIRED PER SRM 51-40-3SDR 05FDEA00412Frame · dentedMAIN DECK CARGO, FUSELAGE FRAME FOUND WITH DENT AT STA Y= 1681, LONGERON 12R. REPAIR CARRIED OUT IAW SRM 53-30-00 FIG. 1 VOL. I. COMPLIED WITH FEDEX EA 1-5330-81619.SDR 0500586739Frame · crackedDURING LINE CHECK AND IN COMPLIANCE WITH AD 2005-04-51, FOUND CRACK IN FRAME AT BS 460 S12L. REPAIRED PER EA 67-203103.SDR ABXA050072Frame · crackedFRAME CRACKED FS 889 AT LONGERON 29 LEFT. REPAIRED CRACKED FRAME FLANGE IAW DC-9 SRM DWG K05159.SDR 2005UALA00213Frame · dentedAFT PIT STA 1580, RBL 36 FRAME CAP DENTED. FRAME DENTED BY CARGO LOADING OPERATIONS. FAA-APPROVED PERMANENT REPAIR APPLIED TO FRAME INNER FLANGE.SDR SWAA050708Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050707Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050704Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, ABOVE STR 8R. REPAIRED FRAME PER SRM.SDR SWAA050703Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050702Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9L. REPAIRED FRAME PER SRM.SDR LR7A05036Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 782E, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05035Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 762E, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05034Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 324E, WL 147, LBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05033Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 732, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05032Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 702, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05031Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 444, WL 148, RBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05030Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 384, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05029Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 364, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05028Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 323, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05027Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 291, WL 148, RBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05026Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 283, WL 148, LBL 65 & RBL 65. REPAIRED IAW LAC MEA 382-53-04-074 R1.SDR LR7A05025Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 807E WL 148 LBL 65. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05024Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 768E, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05023Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 787 WL 178 AND 205, RBL 77. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05022Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 767, WL 152, RBL 66. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05021Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 747, WL 148, RBL 65. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05020Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 707, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05019Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 687, WL 148, RBL 65 AND LBL 65. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05018Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 667, WL 148, RBL 65. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05017Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 657, WL 175, LBL 77. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05016Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED / MIS-DRILLED FUSELAGE LINER HOLES AT FS 647, WL 148, LBL 65. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR LR7A05015Frame · misdrilledDURING SCHEDULED C5 INSPECTION PER JOB CARD HC5313 FOUND ELONGATED, MIS-DRILLED FUSELAGE LINER HOLES AT FS 637, WL 176, LBL 77. REPAIRED IAW LAC MEA 382-53-04-073 R1.SDR IXXA0500135SFrame · crackedDURING A ROUTINE C CHECK INSPECTION, FOUND LT FUSELAGE FORWARD ACCESSORY COMPARTMENT STRUCTURE FRAME CRACK DAMAGE AT STA FS 55.00, L-24L. MAJOR REPAIR ACCOMPLISHED REMOVAL OF FASTENERS AND CRACKED FRAME SEGMENT. PERFORMED AN NDT INSPECTION. FABRICATED FRAMESDR IXXA0500133SFrame · crackedDURING A ROUTINE C CHECK INSPECTION, FOUND RT FUSELAGE FORWARD ACCESSORY COMPARTMENT STRUCTURE FRAME CRACK DAMAGE AT STA FS 55.00,L-24R. MAJOR REPAIR ACCOMPLISHED REMOVAL OF FASTENERS FROM REPAIR AREA. REMOVED DAMAGED FRAME SEGMENT. PERFORMED NDT INSPECTIONSDR IXXA0500126SFrame · crackedDURING A ROUTINE C CHECK INSPECTION, FOUND RT FUSELAGE FORWARD ACCESSORY COMPARTMENT STRUCTURE FRAME CRACK DAMAGE STA FS 55.00 L-24R. MAJOR REPAIR ACCOMPLISHED REMOVAL OF FASTENERS. REMOVAL OF DAMAGED AREA FRAME SEGMENT. PERFORMED NDT INSPECTION, FABRICATED SDR ASAA0510016Frame · misdrilledOKC - FUSELAGE, STA 597 APPROX RBL 68 CABIN FLOORBEAM HAS MISDRILLED HOLES. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLE, DOUBLER, AND TRIPLER. ORDERED AND INSTALLED LOWER CHORD AND FRAME IAW SRM. (K)SDR DHL2005805546Frame · crackedFWD ACCY COMPT FRAME CRACKED 3.000 AT STA 55.000 L-23L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 53-2-0 FIG 2, TR 53-110, TR 53-125, SRM 53-3-3 FIG 3. REMOVED FASTENERS IAW SRM 51-1-20D PAGE 21, SRM 51-1-21 PG 1. CUT OUT DAMAGED SECTION AND FABRICATED SDR MASA200500178Frame · corrodedIN C-CHECK RAMP AT BL 0 FRAME 19 & 20 IS CORRODED AND HAS BEEN REPLACED IAW SRM 51-40-02.SDR SWAA050657Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND CRACKED STUB FRAME AT BS 360, BETWEEN STR 14L & STR 15L. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA050653Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FUSELAGE FRAME AT BS 1006, LBL 39, WL 200. REPAIRED FRAME SECTION PER SRM.SDR ABXA050066Frame · crackedLEFT AFT MAIN FRAME HAD A CRACK APPROXIMATELY 1.5 INCH IN LENGTH AT POINT E FORWARD FLANGE. CRACK WAS WITHIN ALLOWABLE LIMITS IAW DC-9 SERVICE BULLETIN 53-131 AND ES00913.SDR SWAA050647Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE BELT FRAME CRACKED AT BS 360, STR 14R. REPAIRED BELT FRAME PER SRM.SDR SWAA050646Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9L. REPAIRED FRAME PER SRM.SDR 050616394Doubler · crackedRIGHT FS 640 FRAME DOUBLER IS CRACKED IN RADIUS AT 3 INCH IN LENGTH.SDR 050616392Doubler · crackedLEFT FS 640 FRAME DOUBLER IS CRACKED IN RADIUS AT 3 INCH IN LENGTH.
Back to JASC 5311