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 KCSA071488Frame · crackedMAIN CABIN LEFT SIDE FRAME IS CRACKED AT TENSION TIE TO FRAME INTERFACE AT STA 920, BETWEEN STR 5L TO 6L.SDR MASA200700727Frame · crackedFS 718.00 RT FRAME IS CRACKED BETWEEN STRINGERS 10 AND 12. PERMANENT REPAIR WAS ACCOMPLISHED BY AAR HOT SPRINGS.SDR USAA920071226Frame · corrodedMCN - MAJOR REPAIR - C20 CHECK - CORROSION ON FRAME, BS 794.30, S23R. REPLACED FRAME, BS 794.30, S23R IAW USAIRWAYS EA 98994.SDR USAA920071140Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, FORWARD SERVICE DOOR CUTOUT AFT FRAME CRACKED, BS 344. REPAIRED FORWARD SERVICE DOOR CUTOUT AFT FRAME, BS 344 IAW USAIRWAYS EA 100022.SDR 102207N338CS2Frame · crackedFUSELAGE FRAME CRACKED AT FS 275.6, LBL 15.35 AND RBL 15.35. FRAME P/N 6511136-2. NOTE: FIVE OTHER AIRCRAFT IN FLEET CHECKED AND FOR HAD CRACKS AT THE SAME LOCATION. THIS SDR IS A REVISION TO SDR 102207N338CS.SDR 102207N338CS1Frame · crackedFUSELAGE FRAME CRACKED AT FS 263.4 -- LBL 15.35 TO RBL 15.35. FRAME P/N 6511131-2. NOTE: FIVE OTHER AIRCRAFT IN FLEET CHECKED AND FOUR HAD CRACKS AT THE SAME LOCATION. THIS SDR IS A REVISION TO SDR 102207N338CSSDR USAA920071005Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 360, S13R. REPAIRED FRAME, BS 360, S13R IAW USAIRWAYS EA 98944, EA 98948 AND TYPICAL REPAIR 53-10-01.SDR SWAA075206Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075216Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075207Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8. REPAIRED FRAME PER SWA EA.SDR SWAA075160Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075164Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075197Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075162Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075161Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075175Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075163Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR KCSA071485Frame · crackedBS 380 FUSELAGE FRAME CRACKED AT STR 17L CUTOUT.SDR FDEA200710194649Frame · crackedFWD AVIONICS COMPT ON FRAME FOUND CRACK. REPAIRED FRAME IAW SRM 53-30-00 FIG 11 VOL I.SDR K11A2008121672002Frame · dentedFRAME DENTED.SDR ABXA070401Frame · corrodedFORWARD LOWER CARGO AFT SIDE AND LOWER LEG OF FRAME CORRODED FS 598 AT LONGERON 30. BLENDED AREA IN ACCORDANCE WITH DC9 SRM.SDR SIMA200730403Frame · corrodedDURING A MBV INSPECTION CORROSION WAS FOUND ON THE RT SIDE OF FRAME 72. REPAIRED FRAME 72 IAW SAAB SRM CHAPTER 53-70-30. AIRCRAFT RETURNED TO SERVICE.SDR USAA920071048Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 480, S8L - S9L. REPAIRED FRAME, BS 480, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR SIMA200730204Frame · corrodedDURING A MBV INSPECTION, CORROSION WAS FOUND ON THE RIGHT SIDE OF FRAME 72. REPAIRED FRAME 72 IAW SAAB SRM CHAPTER 53-70-30. AIRCRAFT RETURNED TO SERVICE.SDR 07FDEA04653Frame · crackedLOWER STUB FRAME EXTENTION AT BS 560, WEB IS CRACKED ABOVE AND INBD OF STR 21 L, AT RIVET HOLE MARKED END OF DOT WITH BLACK DOT REPLACED LOWER STUB FRAME EXTENSION REF SRM 51-30-2, AND DWG 53FX1350. TREATED AND PRIMED REF SRM 51-10-2.SDR 07FDEA04652Frame · crackedAIR CONDITIONING COMPT RT SIDE ON FRAME JAMB DOOR FOUND CRACK.SDR 07FDEA04649Frame · crackedFWD AVIONICS COMPT ON FRAME FOUND CRACK.SDR DHL2007748028Frame · dentedREWORK DUE TO IMPROPER REPAIR FRAME AT 9G BARRIER BS 348.2 IS DENTED BETWEEN STRINGER 5L AND STRINGER 6L. REMOVED SRM REPAIR AT FRAME STATION 348 STRINGER 5L - 6L IAW SRM 51-30-2. CUT OUT FRAME SECTION IAW DRAWING NR AE727-2-360. FABRICATED AND INSTALLED DOSDR DHL2007748016Frame · damagedFORWARD CARGO COMPARTMENT FRAME 640 AREA SHOW SEVERAL FASTENER HOLES IMPROPERLY PERFORMED. BLENDED DAMAGED AREA OF STUB FRAME AT STATION 638 BETWEEN 23L AND 25L. FABRICATED AND INSTALLED A REPAIR DOUBLER IAW SIE EO NR SIE-N748DH-10-16-07 MATERIAL USED 0.100"SDR MAC110701Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON FRAME 39 AT BL 0 REQUIRING A FRAME REPAIR. THE CORROSION ORIGINATED FROM A BLUE WATER SPILL AT SOMETIME IN THE PAST. THE LAV WAS PREVIOUSLY REMOVED DURING A RECONFIGURATION OF THE A/C. THIS IS AN ISOLATED CASE AND HSDR UPS07551052Frame · dentedINSPECTION TYPE:C DENT IN FWD CARGO COMPARTMENT FUSELAGE FRAME FRAME STA 660, S23R AND S24R. ACCOMPLISHED REPAIR PER FINAL EA 757-5330-27A-1755 AND UPS EO B757-5310-27937-A.SDR USAA920071001Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 360, S7L - S11L. REPAIRED FRAME, BS 360, S7L - S11L IAW USAIRWAYS EA 98915 AND TYPICAL REPAIR 53-10-20E.SDR USAA920070996Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 827, S8L - S9L. REPAIRED FRAME BS 827, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR SWAA075114Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 22L. REPAIRED FRAME PER SRM.SDR SWAA075137Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR DHL2007785011Frame · gougedC-1 DOOR CUT OUT AFT FRAME BS 620, WEB HAS DEEP GOUGE ON THE FORWARD SURFACE BETWEEN STRINGER 26R AND 27R. BLEND OUT AREA IAW B-727 SRM 51-10-1. OUT OF LIMITS IAW B-727 SRM 53-10-1 FIGURE 1 AND 53-10-2 FIGURE 3. REMOVED FASTENERS FROM AREA IAW B-727 SRM 51-SDR USAA920071049Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FRAME, BS 480, S1R. REPAIRED FRAME, BS 480, S1R IAW USAIRWAYS EA 98915.SDR 2007UALA04287Frame · dentedFWD PIT STA 580 MAIN FRAME BETWEEN STR 22L AND 24L HAS 2 DENTS. 10-30-07 MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE. INSTALLED ANGLE REPAIR.SDR 07FDEA04630Frame · corrodedCORROSION ON FWD FRAME AROUND MESC ACCESS DOOR FWD LOCK PIN PLATE, FS 423, BL 0 WL 151. REMOVED CORROSION ON FWD FRAME FOR MESC DOOR, ORIGINAL .040, REMOVED .012", REMAINING .028". LOT OF LIMITS REF SRM 51-10-1 PG 2, NOTE J, AND 53-10-1 PG 2A FIG 1. SHEESDR USAA920071208Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 784, S8L - S9L. REPAIRED FRAME, BS 784, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA920071207Frame · crackedCLT - MAJOR REPAIR - C16 CHECK, CRACKED FRAME, BS 727D, S8L - S9L. REPAIRED FRAME, BS 727D, S8L - S9L IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR UPS07551125Frame · dentedINSPECTION TYPE:C DENT IN AFT CARGO COMPARTMENT FUSELAGE FRAME STA 1340 APPROX BETWEEN S25R AND S26R. REPAIR ACCOMPL PER SRM 53-00-07 REPAIR S DETAIL III FIG 201 SHEET 8 OF 15. THIS IS A CATEGORY B REPAIR PER SRM 53-00-07. REINSPECTION PER SRM 53-00-07 DETASDR 2007UALA04281Frame · dentedFWD PIT STA 600 MAIN FRAME BETWEEN STR 23L AND 24L FRAME HAS 2 DENTS. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGE AND INSTALLED ANGLE REPAIR. HIGH FREQUENCY EDDY CURRENT INSP BEFORE INSURANCE CUT, NO CRACKS FOUND. COLD WORKED 4 EA HOLES.
SDR 2007UALA04275Frame · dentedFORWARD PIT FRAME AT STA 540 BETWEEN STR 26L AND 27L HAS DENT. MAJOR REPAIR ACCOMPLISHED. REMOVED EXISTING PRODUCTION SPLICE BETWEEN STR 23L-26L AND FABRICATED A NEW PRODUCTION SPLICE AND STRINGER CLIPS AND REPLACED SHEAR TIE -664 ABOVE STR-24L,
SDR SWAA075109Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075095Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR USAA920071204Frame · crackedCLT - MAJOR REPAIR - C16 CHECK , CRACKED FRAME, BS 747, S8R - S9R. REPAIRED FRAME, BS 747, S8R - S9R IAW USAIRWAYS TYPICAL REPAIR 53-10-20E.SDR 2007UALA04252Frame · corrodedCORROSION AT AFT PIT STR 43L FRAME 52 AND 47-51. REPLACED ANGLE AT STR 43L, FR52SDR GLBA20061015Frame · crackedFRAME AT FS 451.0 CRACKED AT STRINGER 10R RELIEF CUTOUT CRACK IS .6250 IN LONG. MAINTENANCE REPAIRED FRAME FLANGE AT FS 451.0 IAW 1900D SRM 51-70. REPAIR APPROXIMATELY 6 INCH BY 2 INCH 2024 T3 .063. RII COMPLIED WITH IAW TASKCARD 8.2.1.SDR SWAA075090Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT LOWER DOOR STOP. REMOVED AND REPLACED FRAME PER ACO.
Back to JASC 5311