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 ASAA1047994Frame · crackedFS 727B FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047993Frame · crackedFS 727D FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047992Frame · crackedFS 727F FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047990Frame · crackedFS 747 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047989Frame · crackedFS 787 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047988Frame · crackedFS 827 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047986Frame · crackedFS 867 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047984Frame · crackedFS 907 FRAME IS CRACKED. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR.SDR ASAA1047982Failsafe · corrodedAFT CARGO COMPT FAIL SAFE ON FRAME FS 747 CORRODED. INSTALLED REPAIR ANGLE.SDR ASAA1047981Frame · crackedSTA 727D FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047980Frame · crackedSTA 727F FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047979Frame · crackedSTA 747 FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047977Frame · crackedSTA 787 FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047976Frame · crackedSTA 827 FRAME IS CRACKED. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1047951Frame · crackedFRAME AT STA 867 IS CRACKED. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1047950Frame · crackedFRAME AT STA 907 IS CRACKED. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1047949Frame · crackedFRAME AT STA 727B IS CRACKED. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR DALA1012370998Frame · damagedLIGHTNING STRIKE ON WINDOW BELT FRAME LOWER EDGE STA Y=560 TO 579 REPAIR PER ERA 481744-14 REV ORG (DLM88101404)SDR KCSA101025Frame · corrodedBS 2000 FUSELAGE FRAME HAS CORROSION ON I/B CHORD AT LBL 23.SDR AALA20100426AFW01Frame · damagedFRAME STATION 500 STRINGER 30 LEFT AND 31 LEFT DAMAGED. ACCOMPLISHED REPAIR PER EA B767-53-010067.SDR USAA2010042890854Failsafe · corrodedBFM - C4 - LEVEL 2 CORROSION ON FAIL SAFE CHORD BETWEEN BS 1502 TO BS 1518, S20L. REPLACED FAIL SAFE CHORD BETWEEN BS 1502 TO BS 1518, S20L IAW B767 SRM 53-00-15, 51-40-02, 51-20-01, 51-21-02 & 51-40-05.SDR COEA2010042709901Frame · damagedFRAME FLANGE AND SPLICE STRAP JUST FORWARD OF FRAME 23 JUST BELOW STRINGER 14L HAS TOOLING DAMAGE OUT OF LIMITS.SDR USAA2010042790846Doubler · debondedCLT - RON - MAJOR REPAIR - BONDED DOUBLER IS DISBONDED ON AFT SIDE OF FRAME BS 947.5, S24L. REPAIRED DISBONDED ON AFT SIDE OF FRAME BS 947.5, S24L IAW EA 101915.SDR FDEA201004261363Frame · chafedMAIN CARGO COMPT FRAME 36 AT LT LONGERON NR 10 HAS CHAFED AREA .015 IN DEP CUT OUT DAMAGE SECTION AT FRAME 36, LONGERON 10 LT IN MAIN UPPER DECK COMPT, FABRICATED REPAIR PARTS AND INSTALLED FRAME REPAIR-INNER FLANGE IAW SRM 53-10-13, FIG 202, PAGE 209.SDR CALA2010042700173Frame · crackedFRAME 907 CRACKED BETWEEN S-8L & S-9L AT A/C OUTLET EXTRUSION ATTACHMENT(MARKED). FRAME AT STA 907 STR 8L&9L REPAIRED PER EA5310-04498 OP2 DIP REQUIRED BY EA5310-04498 STEP 35 ON L/P9716468 SEQ N00662.SDR CALA2010042700172Frame · crackedFRAME 867 CRACKED BETWEEN S-8L & S-9L AT A/C OUTLET EXTRUSION ATTACHMENT (MARKED). FRAME AT STA 867 STR 8L&9L REPAIRED PER EA5310-04498 OP2 DIP REQUIRED BY EA5310-04498 STEP 35 ON L/P9716468 SEQ N00662.SDR CALA2010042700171Frame · crackedSUPPORT TASK PAX CABIN FRAME AT STA 440 BETWEEN STR 8L AND 9L HAS CRACKED INDICATION WHEN PERFORMED HFEC PER EA 5310-04498 OP2. FRAME AT STA 440 STR 8L&9L REPAIRED PER EA5310-04498 OP2 DIP REQUIRED BY EA5310-04498 STEP 35 ON L/P9716468 SEQ N00662.SDR CALA2010042700170Frame · crackedFRAME 400 CRACKED BETWEEN S-8L & S-9L AT A/C OUTLET EXTRUSION ATTACHMENT (MARKED). FRAME AT STA 400 STR 8L&9L REPAIRED PER EA5310-04498 OP2 DIP REQUIRED BY EA5310-04498 STEP 35 ON L/P9716468 SEQ N00662.SDR CALA2010042700169Frame · crackedSUPPORT TASK PAX CABIN FRAME STA 440 BETWEEN SRT 8R AND 9R HAS CRACKED INDICATION WHEN PERFORMED HFEC INSPECTION PER EA 5310-04498 OP20. FRAME AT STA 440 STR 8L&9L REPAIRED PER EA5310-04498 OP2 DIP REQUIRED BY EA5310-04498 STEP 35 ON L/P9716468 SEQ N00662 CORSDR CALA2010042700168Frame · crackedFRAME 380 CRACKED BETWEEN S-8R & S-9R AT A/C OUTLET EXTRUSION ATTACHMENT (MARKED). FRAME AT STA 380 STR 8R&9R REPAIRED PER EA5310-04498 OP2 DIP REQUIRED BY EA5310-04498 STEP 35 ON L/P9716468 SEQ N00662.SDR AALA20100425TUL05Frame · corrodedSTATION 967 CORROSION AROUND FASTENER REMOVED BEYOND LIMITS. INSTALLED FILLER, DOUBLER, AND TRIPLER REPAIR.SDR SIMA201011901Frame · damagedDURING MAINTENANCE BASE VISIT FOUND THE RIGHT FRAME 64 HAD TOOLING MARKS BEYOND MANUAL LIMITS. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 64 IAW ENGINEERING ORDER EM-53MR-1523. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR CALA2010042600165Frame · crackedSUPPORT TASK PAX CABIN FRAME STA 727B BETWEEN STR 8R AND 9R HAS CRACKED INDICATION WHEN PERFORMED HFEC PER EA 5310-04498 OP 2. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLERS (ANGLES), TREATED AND PRIMED REF EA 5310-04498.SDR AALA20100423TUL14Frame · crackedTHE 1418 FRAME CRACKED AT LONGERON 2 LEFT. INSTALLED FRAME DOUBLER AT STATION 1418, LONGERON 2 LEFT AS PER AARD 53-10-00-15 AND SRM 53-01-0, FIGURE 2 SHEET 4.SDR AALA20100423TUL10Frame · corrodedAFT ANGLE OF FRAME STATION 1271 LONGERON 29 LEFT AND LONGERON 29 RIGHT HAS CORROSION. INSTALLED REPAIR DOUBLER J-ANGLE PER AARD 53-10-00-17.SDR FDEA201004231299Frame · crackedLOWER STUB FRAME EXTENSIONS, BS 540 STR 21L - 22L, CRACK ON RADIUS CUT OUT. REMOVED STUB FRAME AT BS 540 BETWEEN STRINGERS 21L - 22L IAW B727 SRM 51-30-2, REV 102. FORMED STUB FRAME USING 7075-0, .063" X 16" X 6", PO NO. 9009327 IAW B727 SRM 51-20- 1 FIG 7SDR FDEA201004231300Frame · crackedLOWER STUB FRAME EXTENSIONS, BS 580, STR 21L - 22L, CRACK ON RADIUS CUT OUT. REMOVED STUB FRAME AT BS 580 BETWEEN STR 21L AND 22L IAW SRM, REV 102, 51-30-2. FABRICATED STUB FRAME USING 7075 - 0, .063" X 6" X 17" IAW SRM 51-20-1 FIG. 7 AND DWG NR 53FX1350SDR ASOA201000613Frame · corrodedFRAME AT FS 517.00, STR19L IS SEVERELY CORRODED AROUND LIGHTNING HOLE. INSTALLED NEW BRACKET AT FS 517.00 STR 19L REF SRM 51-42-06 AND 51-42-21. LEAK CHECK "GOOD" ON STUB FRAME IAW AMM 21-50-00-86-2-801.SDR CALA2010042600161Frame · crackedSUPPORT TASK PER EA 5310-04498 OP.2, FRAME CRACKED STA 727B BETWEEN S8L AND 9SL. REPAIRED FRAME STA 727B BETWEEN S-8L AND S9-L REF EA 5310-04498.SDR CALA2010042600159Frame · crackedFRAME CRACKED BETWEEN S-8R & S9R AT A/C OUTLET EXTRUSION ATTACHMENT (MARKED). REPAIRED FRAME 787 BETWEEN S-8R AND S-9R REF EA 5310-014498.SDR CALA2010042600158Frame · crackedFRAME 747 CRACKED BETWEEN S-8R AND S-9R AT OUTLET EXTRUSION ATTACHMENT (MARKED). REPAIRED FRAME STA 747R BETWEEN S-8R AND S-9R REF EA 5310-0449 8.SDR CALA2010042600156Frame · crackedFRAME 907 CRACKED BETWEEN S-8R & S-9R AT A/C OUTLET T EXTRUSION ATTACHMENT (MARKED). PERFORMED REPAIR PER EA5310-04498,OP 02.SDR CALA2010042600155Frame · crackedFRAME 867 CRACKED BETWEEN S-8R & S-9R AT A/C OUTLET EXTRUSION ATTACHMENT (MARKED). PERFORMED REPAIR PER EA 5310-04498, OP. O2.SDR CALA2010042300154Frame · crackedFRAME 827 CRACKED BETWEEN S-8L & S9L AT A/C OUTLET EXTRUSION ATTACHMENT. REPAIRED FRAME 827 LT PER EC/RA 5311-01489.SDR CALA2010042300153Frame · crackedFRAME 827 CRACKED BETWEEN S-8R &S-9R AT A/C OUTLET EXTRUSION ATTACHMENT (MARKED). REPAIRED CRACKED FRAME 827 RT PER EC/RA 5311-01489.SDR DALA1011300179Frame · crackedM/D STA 903 RT FRAME TO CTR SECTION INNER CHORD FOUND CRACKED AND SUBJECT INNER CHORD REPAIRED IAW ERA 480429-14, REV 0.SDR ASOA201000625Frame · corrodedFS 333.0 HAS CORROSION AT LOWER BELLY SECTION AND REQUIRES REPLACEMENT OF FRAME IN THAT AFFECTED AREA. REMOVED FRAME AT FS 333, LBL 23 TO RBL 23 IAW SRM 51-42-06. DRILLED TO FINAL SIZE NEW SERVICEABLE FRAME AT FS 333, LBL 23 TO RBL 23 IAW SRM 51-42-06. INSTSDR ASOA201000624Frame · corrodedFS 364.0 HAS CORROSION AT LOWER BELLY SECTION AND REQUIRES REPLACEMENT OF FRAME IN THAT AFFECTED AREA. REMOVED FASTENERS AND CORROSION AROUND EFFECTED AREAS OF FRAME 264.0 AT LOWER BELLY SECTION AND FOUND FRAME TO HAVE AN ORIGINAL THICKNESS OF .080 WITH MATERSDR ASOA201000623Frame · corrodedFS 349.0 HAS CORROSION AT LOWER BELLY SECTION AND REQUIRES REPLACMENT OF FRAME IN THAT AFFECTED AREA. REMOVED FRAME 349.0 FROM STR 23R TO STR 23L IAW SRM 51-42-06. DRILLED NEW SERVICEABLE FRAME AT FS 349 FRAME STR LBL 23 TO RBL 23 IAW SRM 51-42-06 AND 51-4SDR ASAA1077739Frame · crackedFRAME IS CRACKED AT AC BRACKET ATTACH FASTENER HOLE. REPAIRED CRACKED FRAME AT BS 867.
Back to JASC 5311