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 IPXA10560412Frame · gougedINSPECTION TYPE:C1, STA 700, IB FLANGE OF FRAME AT STR 15L HAS SCREW STRIKES 2 EA. REPAIRED FRAME IAW ER NR 10-2774.SDR IPXA10560411Frame · gougedINSPECTION TYPE:C1, STA 680 INBD FLANGE OF FRAME AT STR 15L HAS SCREW STRIKE. REPAIRED IAW ER NR 10-2774.SDR IPXA10560369Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 1480, STR 15R. REPAIRED FRAME IAW ER NO 10-2795.SDR IPXA10560368Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY FRAME INNER FLANGE HAS A CREW GOUGE BS 1460 STR 15R. REPAIRED FRAME IAW ER NO 10-2795.SDR IPXA10560367Frame · gougedINSPECTION TYPE:C1, THE MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 1260 STR 15R. REPAIRED FRAME IAW ER NO 10-2795.SDR IPXA10560366Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY FRAME INNER FLANGE HAS 2 SCREW GOUGES BS 1340 STR 15-16R. REPAIRED IAW ER NO 10-2795.SDR IPXA10560365Frame · gougedINSPECTION TYPE:C1, THE MAIN CARGO BAY FRAME INNER FLANGE HAS 9 SCREW GOUGES BS 1540 STR 7-16R. REPAIRED IAW ER NR 10-2795.SDR IPXA10560359Frame · gougedINSPECTION TYPE:C1, THE MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 1320 STR 15R. REPAIRED MAIN CARGO BAY FROM INNER FLANG IAW SRM 53-00-07-1A ER 10-2795.SDR IPXA10560335Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY FRAME INNER FLANGE HAS 2 SCREW GOUGES BS 1260, STR 15-16L. REPAIRED FRAME IAW ER NR 10-2770.SDR IPXA10560329Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY FRAME INNER FLANGE HAS 2 SCREW GOUGES BS 1620, STR 15-16L. REPAIRED SCREW GOUGES ON FRAME INNER FLANGE IAW SRM 53-00-07-1A, SRM 51-40-02, SRM 51-10-02-0G, SRM 51-40-02-0G.SDR IPXA10560322Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 1340, STR 15L. DAMAGED AREA. FOUND TO BE OUT OF LIMITS. REPAIRED FRAME IAW SRM 53-00-07-1A,ER NR 10-2770.SDR IPXA10560321Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 1240, STR 15L. DAMAGED AREA FOUND TO BE OUT OF LIMITS, REPAIRED FRAME IAW SRM 53-00-07-1A, ER NR 10-2770.SDR IPXA10560320Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 1320, STR 15L. DAMAGED AREA FOUND TO BE OUT OF LIMITS, REPAIRED FRAME IAW SRM 53-00-07-1A.SDR IPXA10560319Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY INNER FLANGE HAS A SCREW GOUGE BS 1380 STR 15L. DAMAGED AREA FOUND TO BE OUT OF LIMITS, REPAIRED FRAME IAW SRM 53-00-0 7-1A, ER NR 10-2770.SDR IPXA10560318Frame · gougedINSPECTION TYPE:C1, MAIN CARGO BAY FRAME INNER FLANGE HAS SCREW GOUGE BS 1200, STR 15-16L. DAMAGED AREA FOUND TO BE OUT OF LIMITS, REPAIRED FRAME IAW SRM 53-00-07-1A, ER NR 10-2770.SDR IPXA10560302Frame · gougedINSPECTION TYPE:C1, THE MAIN CARGO BAY FRAME INNER FLANGE HAS A SCREW GOUGE BS 1620, STR 6R. REPAIRED GOUGE TO FRAME INNER FLANGE IAW SRM 51-40-05-0G, SRM 53-00-07-1A, SRM 51-20-01.SDR SWAA103138Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 807, STR 25L. REPAIRED FRAME PER EA.SDR FDEA201005131527Frame · misrepairedMAIN DECK CARGO - EXISTING REPAIR FOUND AT RT STA 535 FRAME ADJACENT TO 9G NET YOKE UPPER AND LOWER FITTINGS. EXISTING REPAIR AT MAIN DECK CARGO RT STA 535 FRAME ADJACENT TO 9G NET YOKE UPPER AND LOWER FITTINGS EVALUATED FOUND REPAIR NOT IAW ANY SRM REPAIR SCSDR FDEA201005131526Frame · misrepairedMAIN DECK CARGO - EXISTING REPAIR FOUND AT LT STA 535 FRAME ADJACENT TO 9G NET YOKE UPPER AND LOWER FITTINGS. EXISTING REPAIR AT MAIN DECK CARGO LT STA 535 FRAME ADJACENT TO 9G NET YOKE UPPER AND LOWER FITTINGS EVALUATED FOUND REPAIR NOT IAW ANY SRM REPAIR SDR USAA2010051490965Frame · crackedCLT - Q3 - MAJOR REPAIR - NR 03C10753039/007 - CRACK ON FUSELAGE FRAME AT BS500A BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS500A BETWEEN S8L TO S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR SWAA102771Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA102770Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, BETWEEN STR 8L TO STR 9L. REPAIRED FRAME PER EA.SDR SWAA102769Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 827, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA102757Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 727E, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA102722Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA102721Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER EA.SDR SWAA102720Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER EA.SDR SWAA102719Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER EA.SDR IPXA10560358Frame · gougedINSPECTION TYPE:C1, MAIN CARGO FRAME INNER FLANGE HAS MECH DAMAGE AT 1 AREA BS 395 STR 13R-14R. REPAIRED MAIN CARGO FRAME INNER FLANGE IAW ER 10-2777. SRM 51-40-90-00, SRM 51-20-01-00 SRM 51-40-05-0G.SDR IPXA10560357Frame · damagedINSPECTION TYPE:C1 MAIN CARGO FRAME INNER FLANGE HAS MECH DAMAGE AT 6 AREAS 345 STR 9L-16L. REPAIRED MAIN CARGO FRAME INNER FLANGE IAW SRM 53-00-07- IAW AMM 51-21-04-7 SRM 51-20-10 AND ER 10-2777 R1.SDR USAA2010051490968Frame · crackedCLT - Q3 - MAJOR REPAIR - NR 03C10753039/004 - CRACK ON FUSELAGE FRAME AT BS747 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS747 BETWEEN S8R TO S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2010051490967Frame · crackedCLT - Q3 - MAJOR REPAIR - NR 03C10753039/003 - CRACK ON FUSELAGE FRAME AT BS787 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS787 BETWEEN S8R TO S9R IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR USAA2010051490966Frame · crackedCLT - Q3 - MAJOR REPAIR - NR 03C10753039/006 - CRACK ON FUSELAGE FRAME AT BS400 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS400 BETWEEN S8L TO S9L IAW US AIRWAYS TYPICAL REPAIR 53-10-20E.SDR SIMA201013402Frame · gougedDURING MAINTENANCE BASE VISIT DAMAGED FRAME 33 BY STATION WHILE SETTING A RIVET DURING REPAIR. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 33 IAW SRM 53-00-04 FIG 206. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SIMA201013403Frame · gougedDURING MAINTENANCE BASE VISIT FOUND FRAME 70 ON THE RIGHT SIDE HAS A TOOLING MARK BETWEEN STRINGERS 11 RIGHT AND 12 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 70 IN ACCORDANCE WITH ENGINEERING ORDER EM-53MR-1539. THE AIRCRAFT WAS RETURNED SDR SWAA102699Frame · damagedDURING SCHEDULED 12Y CHECK, FOUND FWD CARGO BAY FRAME WEB DAMAGED AT BS 440, BETWEEN STR 25R TO STR 26R. REMOVED AND REPLACED WEB PER BAC DWG.SDR IPXA10560304Frame · damagedINSPECTION TYPE:C2, SCREW STRIKE ON FRAME INBD FLANGE AT BS 1140 BETWEEN S-15R AND S-16R. REMOVED DAMAGE AND INSTALLED RIVOT ON FRAME AT BS 1140 BETWEEN S-15R AND S-16R IAW ER NR 10-2903.SDR DLM88101151Frame · crackedDURING HMV3 FOUND AFT ACCESSORY STA 1485 CANTED FRAME WEB CRACKED APPOX 1". REMOVED DAMAGED AREA, NDT NO CRACK REMAINING. INSTALLED FILLER AND DOUBLER IAW SRM 53-01, FIG 4, SH4.SDR DLM88101150Frame · crackedDURING HMV3, FOUND AFT ACCESSORY AFT SIDE STA 1464 CANTED FRAME WEB HAS 2 EA CRACKS. CUTOUT DAMAGE 1.5 X 2 INCHES NDT VERIFIED DAMAGE REMOVED. FABRICATED AND INSTALLED FILLER FROM .025 & 075T6 AND REPAIR DOUBLER FROM .032 7075T6 IAW SRM FIG 4, SH 4.SDR IPXA10559788Frame · damagedINSPECTION TYPE:C2, ATS RESPONSIBILITY, WHILE WORKING CUSTOMER CARD 855525 MISDRILLED HOLE IN BS 345 RT FRAME JUST BELOW STR 11 RT. REPAIRED IAW ER NR 10-3587 DATED 11-MAY-10.SDR SWAA102695Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 986, STR 19R. REPAIRED FRAME PER SRM.SDR FDEA201005081487Frame · gougedFUSELAGE FRAME INNER CHORD GOUGED STA 1280 ABOVE S13R. FRAME REPAIR AT STA 1280 ABOVE STR 13R, INNER CHORD WAS ACCOMPLISHED IAW F-5310-139133. REPAIR ANGLE FABRICATED ON TRAVLER T10/815580 IAW SRM 51-70-11. REF FAA FORM 8100-9 DATED MAY 11, 2010. - FIRST SSDR IPXA10559784Frame · gougedINSPECTION TYPE:C2, DUE TO RCD PROCESS, NRC REQUIRED FOR FRAME REPAIR AT BS 345, STR 11, RT. REPAIR IAW ATS ER 10-2587.SDR FDEA201005071488Frame · crackedCRACK IN MAIN CABIN FRAME AT BS 804.50, STR 14R. REMOVED CRACKED ANGLE CHORD, FABRICATED NEW ANGLE CHORD FROM BAC 1490-2510, DIM: 38.1250" AND INSTALLED NEW ANGLE CHORD AT BS 804.5 STR 14R IAW SRM 51-30-2, SRM 53-10-2, FIG 5, SRM 51-10-2, SRM 51-30-2, AND ER SDR FDEA201005071477Frame · damagedNOSE EQUIPMENT BAY FRAME AT STA 231.25 BL0 FOUND WITH PUNCTURE HOLE. DAMAGED FRAME AT STA 231.25. R & R IAW SRM 51-40-02 REV 99. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR SWAA102659Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 500C, BETWEEN STR 19R TO STR 22R. REPAIRED FRAME PER SRM.SDR SWAA102653Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA102652Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA102634Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND STUB FRAME ANGLE CRACKED AT BS 639, RBL 45. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA102633Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND STUB FRAME ANGLE CRACKED AT BS 639, LBL 45. REMOVED AND REPLACED STUB FRAME PER SRM.
Back to JASC 5311