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 DHL2005805528Frame · misdrilledMAIN CARGO COMPT FRAME INBD FLANGE (2EA) HOLES MISDRILLED AT STA 1480.000 L-13L L-12L (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATE 03-05-05, EO NR AST 050205 DATE 02-21-05. CLEANED, TREATED AND PRIMED (AREA) MISDRILLED HOLES IAW SRM 51-1-8SDR CALA0500087Frame · corrodedINSPECTION FOUND AFT CARGO PIT FRAME CORRODED AT BS 1440, RBL 9, BETWEEN S28R AND S29R. A REPAIR WAS PERFORMED IAW ECRA 5310-04467. A DIP WAS ISSUED TO PERFORM A PERMANENT REPAIR AFTER 10 MONTHS, BUT BEFORE 3-14-2006.SDR SWAA050857Frame · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON FUSELAGE FRAME AT BS 847, BETWEEN STR 23R & STR 25R. REPAIRED FRAME PER SRM.SDR UIEA200500023Frame · chafedD-CHECK AT SINGAPORE, DURING INSPECTION GOUGES WERE FOUND ON THE STATION 2460 BULKHEAD INNER T-CHORD TOP SURFACE AT LBL 30, AND WL 235. BLENDED OUT THE DAMAGED AREA AND INSTALLED A REPAIR STRAP OF .0710 INCH THICK CLAD 2040-T3 MATERIAL. (M)SDR 05FDEA00592Frame · crackedMAIN CABIN FRAME 37 CLS ADAPTER -YD40 IS GOUGED AND CRACKED (BETWEEN SEAT TRACK 2 AND 3 LT). REMOVED AND REPLACED CLS ADAPTER PER A310 SRM 51-72-10. TREATED, PRIMED AND TOP COATED AREA AND FASTENERS PER A310-200 SRM 51-75-10.SDR VTZA200500013Doubler · crackedRIGHT FS 640 FRAME DOUBLER IS CRACKED IN RADIUS AT 3 INCH IN RADIUS.SDR USAA050376Frame · crackedCLT - Q6 - FRAME, .125 INCH, CRACKED, STA 787, STR8/9L. INSTALLED DOUBLER IAW TR 53-10-20B. INSTALLED DOUBLER IAW TR. (K)SDR DHL2005782550Frame · bentFRAME AT STR 26 R STA 1110 BENT. CUT OUT DAMAGE AREA IAW B727 SRM 53-10-1 SIZE 2" BY 1". FABRICATED FRAME DOUBLER USING 7075 T6 .071 PO NR 9001298 DIM 10" BY 4" IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1. ALODINE AND PRIMED IAW B727 SRM 51-10-2. INSTALLESDR DHL2005782549Frame · bentFRAME BETWEEN STR 25-26 R AT STA 1050 BENT. CUT OUT DAMAGE AREA SIZE 1 1/2 INCH BY 1 INCH IAW B727 SRM 53-10-1. FABRICATED FRAME REPAIR USING 7075-T6 .071 PO NR 9002012 DIM 8 INCH BY 4 INCH IAW B727 SRM 53-10-2 FIG 5 AND 51-40-3 FIG 1. ALODINE AND PRIMED PASDR ASAA0540172Frame · crackedPAE - PASSENGER CABIN, BS 601 FRAME CHORD IS CRACKED AT RBL 64, WL 204. REPAIRED FRAME CHORD PR EA 5310-02449. (M)SDR AWXA200500446Frame · corrodedMCN - MAJOR REPAIR - DURING C-05 CHECK CORROSION WAS FOUND ON AFT SIDE OF AFT LOWER FUSELAGE FRAME AT BS 986.5, STR 25 RT. MAINTENANCE CUT OUT CORRODED AREA OF AFT LOWER FUSELAGE FRAME AT BS 986.5, STR 25 RT; FABRICATED A FILLER AND DOUBLER; INSTALLED REPAIR SDR USAA050362Frame · crackedCLT - Q6 - FRAME, .250 INCH CRACK, STA 867, STR 8/9L. INSTALLED DOUBLER REPAIR IAW TR. (K)SDR 2005UALA00250Frame · gougedAFT PIT FUSELAGE FRAME GOUGED IN 6 PLACES BS 1520 STR 22R TO 25R. DAMAGE TO FRAMES IN AFT PIT DUE TO NORMAL CARGO LOADING. DAMAGE WAS REMOVED AND REPAIR ANGLE FABRICATED TO REPAIR FRAME.SDR SWAA050809Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FRAME CRACKS AT BS 663, STR 3L & STR 3R. REPAIRED FRAME PER SRM.SDR SWAA050805Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, BETWEEN STR 13L & STR 14L. REPAIRED FRAME PER SRM.SDR SWAA050802Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA050801Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 9R. REPAIRED FRAME PER SRM.SDR 05FDEA00541Frame · damagedREPAIR NEEDS EVALUATION FOR FAA APPROVED DATA AND MAJOR OR MINOR CLASSIFICATION. ITEM NR 9 ON LIST FUSELAGE, REPAIR DOUBLER, LOWER RT SIDE, AT FR 26/32 REPAIR DOUBLER FOUND TO BE IN CONFORMANCE WITH A310-200 SRM 53-10-12 FIG 205. ACTUAL LOCATION OF DOUBLER FSDR 05FDEA00517Frame · crackedFRAME IS CRACKED AT BS 620, LBL 8, WL 157. REMOVED EXISTING REPAIR, FABRICATED DOUBLER, SHEAR TIE AND INSTALLED DOUBLER, AND SHEAR TIE. IAW SRM 53-10-4.SDR SWAA050779Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L TO STR 9L. REPAIRED FRAME PER SRM.SDR ASOA05302Frame · corrodedDURING A C-CHECK, THE OUTER CHORD AT FR 17 LT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE OUTER CHORD AT FR17 LT IAW SRM. (K)SDR 0500576743Frame · crackedDURING L-CHECK, FOUND CRACK IN FRAME AT BS 380 S24R. REPAIRED PER EA 67-165195.SDR 2005UALA00239Frame · dentedAFT PIT STA 1540, STR 27R, FRAME INBD FLANGE IS DENTED. FABRICATED AND INSTALLED NEW PRODUCTION SPLICE ANGLE EXTENDED TO ACCOMODATE REPAIR TO THE DAMAGED FRAME.SDR 2005UALA00238Frame · dentedAFT PIT STA 1440, STR 26L FRAME INBD FLANGE DENTED. FABRICATED AND INSTALLED NEW PRODUCTION SPLICE ANGLE EXTENDED TO ACCOMODATE REPAIR TO THE DAMAGED FRAME.SDR 2005UALA00246Frame · damagedUPPER FRAME LT SIDE STA 178 HAS LOW EDGE DISTANCE. FABRICATED AND INSTALLED A REPAIR CHORD SPLICE ANGLE, PICKING UP AN ADDITIONAL FASTENER LOCATION.SDR 2005UALA00240Frame · corrodedCORROSION FOUND AT BS 1480 FRAME BETWEEN STR 27L TO 28L, ON INBD FLANGE. DAMAGE CAUSED BY CORROSION. REPAIRED FRAME USING A NESTED J-ANGLE REPAIR DOUBLER.SDR SWAA050780Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAMES CRACKED AT BS 188, WL 208, LT & RT SIDE. REMOVED AND REPLACED FRAMES PER SRM.SDR SWAA050778Frame · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA FUSELAGE FRAMES CRACKED AT BS 360 & BS 787, STR 8R TO STR 9R. REPAIRED FRAMES PER SRM.SDR DHL2005782538Frame · bentAFT CARGO BENT FRAME STA 1070 RIGHT AROUND STR 27R. REMOVED DAMAGED AREA, FABRICATED DOUBLER REPAIR FROM 7075-T6,0. .063 PO NR 9001660 DIMENSIONS 3 1/4' X 8 1/2', FILLER REPAIR FROM 7075-T6 0.063 PO #9001660 DIMENSIONS 1 3/8' BY 1 3/4' AND SHIM FROM 7075-T6 0SDR SWAA050769Frame · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO BELTFRAME CORRODED AT BS 887, LBL 1. REPAIRED BELTFRAME PER SRM.SDR SWAA050759Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, BETWEEN STR 8R & STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050758Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, BETWEEN STR 8R & STR 9R. REPAIRED FRAME PER SRM.SDR SWAA050757Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, BETWEEN STR 8R & STR 9R. REPAIRED FRAME PER SRM.SDR MALA050272Frame · chafedDURING 4Y/2Y CHECK IN BNA FOUND RT FUSELAGE FRAME STA 686 INBOARD FLANGE CHAFED FROM CARGO DOOR AFT CABLE JUST ABOVE FLOOR LEVEL. SMOOTHED OUT, PRIMED, PAINTED, AND INSTALLED WEAR STRIP. REF MESABA EOS53290. WORK PERFORMED ON EMB WO 211832 TASK 1514.SDR UPS05444213Frame · crackedBS 2180 STR 25R FRAME FOUND CRACKED, CRACK LENGTH 1 INCH. FRAME REPAIRED AT BS 2180 STR 25R AREA AS PER HX RS R-53-62-35275 AND UPS EO B747-5310-21972A.SDR COMA0560170Frame · crackedRIGHT HAND 640 FRAME CRACKED. REPAIRED IAW CRJ SRM 51-42-06, 51-42-21 AND 51-25-01.SDR COMA0560168Frame · crackedLEFT HAND 640 FRAME CRACKED. REPAIRED IAW REO 601R-53-61-487 AND CRJ SRM 51-23-00, 51-25-06, 51-25-16, 51-42-06, 51-42-21, 51-41-02 AND 51-42-20.SDR ASOA05301Frame · corrodedDURING A C-CHECK, THE FAIL SAFE FRAME SEGMENT IN THE AFT AVIONICS COMPARTMENT AT FR46, STRINGER 19L AND 19R WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FAIL SAFE FRAME SEGMENT IN THE AFT AVIONICS COMPARTMENT AT FR 46, STRINGERSDR 20030822Frame · crackedDURING ROUTINE INSPECTION, FOUND WEB CRACK ON FRAME FS 466.0 STRINGER 10R. REPAIRED CRACK IAW WITH EO. AIRCRAFT RETURNED TO SERVICE.SDR USAA050447Frame · corrodedBFM - FOUND FLOOR FRAME CORRODED 2 INCH LONG BY 1 INCH WIDE BY .050 INCH DEEP AREA, STATION 1109 RBL 14.5-RBL 45. REMOVED AND REPLACED CHORD SECTION, ADDING CHANNEL AND STRAP PER 53-00-07. (M)SDR 05FDEA00489Frame · chafedBS 1148, STR 22 LT UPPER FRAME FLANGE IS CHAFED BY HYDRAULIC LINE. *S/D* REPAIRED EPR SRM 53-10-1, 51-40-3.SDR 2005UALA00234Frame · corrodedDOOR 4L AFT FRAME CORROSION AT STA 1681 BOTTOM OF STR 17L. DAMAGE CAUSED BY TYPICAL FLOOR STRUCTURE CORROSION. DAMAGE WAS REMOVED AND REPAIR ANGLES WERE FABRICATED AND INSTALLED.SDR SWAA050746Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA OUTBOARD CHORD CRACKS AT BS 188, LBL 29 & RBL 29, WL 207. REPAIRED CHORD PER SRM.SDR SWAA050745Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA050744Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9R. REPAIRED FRAME PER SRM.SDR 2005UALA00226Frame · dentedAFT PIT STA 1440, STR 26L FRAME INBOARD FLANGE IS DENTED. FRAME FLANGE WAS REPAIRED USING NESTED J-ANGLES.SDR 2005UALA00225Frame · dentedAFT PIT STA 1480 AT STR 26L, FRAME IS DENTED ON INBOARD FLANGE. FRAME FLANGE WAS REPAIRED BY EXTENDING THE EXISTING SPLICE ANGLE TO REPAIR THE DAMAGED FLANGE.SDR 2005UALA00224Frame · dentedAFT PIT STA 1460 AT STR 26L FRAME IS DENTED ON INBOARD FLANGE. FRAME FLANGE WAS REPAIRED USING NESTED J-ANGLES.SDR 2005UALA00223Frame · dentedAFT PIT STA 1580 FRAME DENTED ON INBOARD FLANGE AT STR 26R. FRAME FLANGE WAS REPAIRED USING NESTED J-ANGLES.SDR 2005UALA00222Frame · dentedAFT PIT FRAME IS DENTED 3 EA PLACES ON INBOARD FLANGE AT BS 1420, BETWEEN STR 23L AND 26L. FRAME FLANGE WAS REPAIRED BY EXTENDING THE EXISTING SPLICE ANGLE TO REPAIR THE DAMAGED FLANGE.
Back to JASC 5311