N976AS, cancelled Mar 30, 2015
Service difficulty reports · 201
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N976AS' AND deregistration_id = 'N976AS-2015-03-30' 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 n_number = 'N976AS' AND deregistration_id = 'N976AS-2015-03-30' 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 ASAA0280491Seat Track · corrodedOKC - FOUND 30K CHECK, SEAT TRACK CORRODED AT FS 1122, LBL 22. REPLACED SEAT TRACK PER SRM 53-05, 51-10-4, 51-30-05, AND 51-30-1. (M)SDR ASAA0280492Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 200-256, LBL 14 - RBL 22. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280493Floorboard · tornOKC - DURING SCHEDULED 30K CHECK, FLOORBOARD AT BS 1079-1117, LEFT BUTTOCK LINE 22, RIGHT BUTTOCK LINE 22 TORN. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280495Floorboard · corrodedOKC - FOUND DURING SCHEDULED 30K CHECK, FLOORBOARD AT BS 160-200, RIGHT BUTTOCK LINE 44, RIGHT BUTTOCK LINE 54 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280496Floorboard · corrodedOKC - DURING SCHEDULED 30K CHECK, FLOORBOARD AT BS 160-200, LEFT BUTTOCK LINE 8, LEFT BUTTOCK LINE 44 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280497Floorboard · corrodedOKC - FOUND DURING SCHEDULED 30K CHECK, FLOORBOARD AT BS 160-200, LEFT BUTTOCK LINE 8, RIGHT BUTTOCK LINE 44 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280498Floorboard · corrodedOKC - FOUND DURING SCHEDULED 30K CHECK, FOUND FLOORBOARD AT BS 160-256, LEFT BUTTOCK LINE 22, LEFT BUTTOCK LINE 44 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280499Floorboard · corrodedOKC - DURING SCHEDULED 30K CHECK, FOUND FLOORBOARD AT BS 200-256, LEFT BUTTOCK LINE 22, RIGHT BUTTOCK LINE 22 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280501Floorboard · corrodedOKC - DURING SCHEDULED 30K CHECK, FOUND FLOORBOARD AT BS 1307-1361, LEFT BUTTOCK LINE 18 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280502Floorboard · corrodedOKC - DURING SCHEDULED 30K-CHECK, FLOORBOARD AT BS 1117-1174, LEFT BUTTOCK LINE 6, LEFT BUTTOCK LINE 22 CORRODED. REMOVED AND REPLACED FLOORBOARD PER MD80 SRM. (M)SDR ASAA0280503Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD AT STATION 1156-1250 LBL 22 TO LBL 44 HAS 29 CORRODED INSERTS. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0280504Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD AT STATION 200-256 RBL 22 TO RBL 44 HAS 18 CORRODED INSERTS. REMOVED AND REPLACED IAW SRM. (M)SDR ASAA0280505Longeron · corrodedOKC - FOUND DURING 30K CHECK, LONGERON 30 CORRODED AT STATION 588. REPAIRED IAW EA. (M)SDR ASAA0280506Skin · gougedOKC - FOUND DURING 30K CHECK, RIGHT ELEVATOR OUTBOARD LEADING EDGE GOUGED AT TIP MATING SURFACE. REPAIRED IAW EA. (M)SDR ASAA0280507Skin · dentedOKC - FOUND DURING 30K CHECK, DENT IN FUSELAGE SKIN AT STATION 1150 BETWEEN LONGERON 26R-27R. REPAIRED IAW SRM. (M)SDR ASAA0280508Skin · dentedOKC - FOUND DURING 30K CHECK, DENT IN FUSELAGE SKIN AT STATION 1340 LONGERON 19R. REPAIRED IAW SRM. (M)SDR ASAA0280509Skin · gougedOKC - FOUND DURING 30K CHECK, LEFT WIND LEADING EDGE UPPER SURFACE GOUGED AT STATION XFS 624. REPAIRED IAW EA. (M)SDR ASAA020510Strake · damagedOKC - FOUND DURING 30K CHECK, RIGHT STRAKE AFT EDGE IS FLATTENED. REPAIRED IAW EA. (M)SDR ASAA0280511Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK AT RBL 44 AND STATION 287 IS CORRODED. REPAIRED IAW SRM. (M)SDR ASAA0280512Seat Track · corrodedOKC - FOUND DURING 30K CHECK, SEAT TRACK AT STATION 1229 AND LBL 22 IS CORRODED. REPAIRED IAW SRM. (M)SDR ASAA0280466Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 465-541, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280467Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 541-617, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280468Floorboard · debondedOKC - FOUND 30K CHECK, FLOORBOARD DISBONDED AT FS 693-769, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280469Floorboard · debondedOKC - FOUND 30K CHECK, FLOORBOARD DISBONDED AT FS 693-769, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280470Floorboard · debondedOKC - FOUND 30K CHECK, FLOORBOARD DISBONDED AT FS 807-826, LBL 22 - RBL 22. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280471Floorboard · debondedOKC - FOUND 30K CHECK, FLOORBOARD DISBONDED AT FS 889-927, RBL 22 - RBL 44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280472Floorboard · debondedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 927-1003, LBL 22 - LBL 44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280473Floorboard · puncturedOKC - FOUND DURING 30K CHECK, FLOORBOARD PUNCTURED AT FS 1250-1307, LBL 22 - LBL 44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280474Door · chafedOKC - FOUND DURING 30K CHECK, LEFT WING NR 11 SLAT TRACK DOOR IS CHAFFED AT FORWARD END. REPLACED SLAT TRACK DOOR. (M)SDR ASAA0280475Cargo Track · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY RIGHT TIE-DOWN TRACK FORWARD SPLICE IS CORRODED AT FS 1090. REPLACED SPLICE PER SRM 53-05, FIG 4G, AND 53-24-0, FIG 11. (M)SDR ASAA0280476Insert · corrodedOKC - FOUND DURING 30K CHECK, FLOORBOARD HAS CORRODED INSERTS AT FS 160-200, RBL 8 TO LBL 8. REPLACED INSERTS PER SRM 53-05. (M)SDR ASAA0280477Floor Panel · delaminatedOKC - FOUND DURING 30K CHECK, FLIGHT DECK FLOOR PANEL LOWER SURFACE IS SEPARATING FROM CORE AT FS 148.55, RBL 31-44. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280478Floor Panel · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DELAMINATING AT FS 541-579, LBL 22 TO RBL 22. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280450Bracket · crackedOKC - FOUND DURING 30K CHECK, HYDRAULIC VALVE BRACKET CRACKED IN RIGHT WHEEL WELL. REPLACED BRACKET PER DAC DWG 7936937, SRM 51-10-2, 51-10-4, AND 51-30-5. (M)SDR ASAA0280462Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 313-389, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280463Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 313-389, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280464Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 398-446, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280465Floorboard · delaminatedOKC - FOUND DURING 30K CHECK, FLOORBOARD DISBONDED AT FS 465-541, RBL 22-44. REPLACED FLOORBOARD PER SRM 53-05 AND 53-24-0. (M)SDR ASAA0280449Floor Support · corrodedOKC - DURING 30K-CHECK, FLOOR SUPPORT CORRODED AT FS 1155, LBL 22-44. REPLACED SUPPORT PER SRM 53-14-1, 51-10-4, AND 51-30-5. (M)SDR ASAA0280443Door · chafedOKC - FOUND DURING 30K-CHECK, RIGHT NR 5 SLAT TRACK DOOR CHAFED AT FORWARD END. REPLACED SLAT TRACK DOOR PER MM 27-80-01. (M)SDR ASAA0280440Web · corrodedOKC - FOUND DURING 30K CHECK, FOUND CUSP WEB CORRODED AT FS 617-712. REPLACED CUSP WEB PER SRM 51-30-2, AND 51-10-4. (M)SDR ASAA0280441Web · corrodedOKC - FOUND DURING 30K CHECK, CUSP WEB CORRODED AT FS 1239. REPLACED CUSP WEB PER SRM 53-14-3, FIG 12, 51-70-4, 51-30-1 AND 51-30-5. (M)SDR ASAA0280442Panel · chafedOKC - FOUND DURING 30K CHECK, LEFT NR 3 SLAT TRACK PANEL FORWARD END IS CHAFED AT NOTCH-OUT. REPLACED SLAT TRACK DOOR PER MM 27-80-01. (M)SDR ASAA0280444Skin · dentedOKC - FOUND DURING 30K CHECK, LEFT ELEVATOR CONTROL TAB DENTED ON LOWER OUTBOARD SURFACE. CUT OFF DAMAGED AREA AND REPAIRED PER SRM 51-70-2. (M)SDR ASAA0280419Splice · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY LEFT TIE DOWN TRACK OUTBOARD FORWARD SPLICE IS CORRODED AT FS 1090. REPLACED TIE DOWN TRACK SPLICE PER SRM 53-24-0, FIG 11, 51-10-2, 51-10-4, 51-10-2, AND 51-30-2. (M)SDR ASAA0280414Shear Tie · corrodedOKC - FOUND DURING 30K CHECK, SHEAR TIE CORRODED AT FS 1150, LONGERON 29L-29R. REPLACED SHEAR TIE PER SRM 53-14-3 AND 51-30-5. (M)SDR ASAA0280411Door Frame · crackedOKC - FOUND DURING 30K CHECK, LEFT PAX L1 DOOR INTERNAL FRAME IS CRACKED BEHIND INNER DOOR HANDLE. REPLACED FRAME PER SRM 51-30-2. (M)SDR ASAA0280412Strap · crackedOKC - FOUND 30K CHECK, RIGHT WING LEADING EDGE SPLICE STRAP IS CRACKED AT STATION XRS 164, XFS 299. REPLACED SPLICE PER SRM 57-32-1, 51-10-4, AND 51-30-2. (M)SDR ASAA0280413Doubler · crackedOKC - FOUND DURING 30K CHECK, LEFT WING LEADING EDGE BUTT SPLICE DOUBLER IS CRACKED 1.25 INCH AT LOWER AFT EDGE. REPLACED SPLICE PER SRM 57-32-1, 51-10-4, AND 51-30-2. (M)SDR ASAA0280409Floor Support · corrodedOKC - FOUND DURING 30K CHECK, AFT CARGO BAY FLOOR SUPPORT CORRODED AT FS 1212 BETWEEN LONGERON 28L AND 29L. REPLACED SUPPORT PER SRM 53-24-0, FIG 11, AND SRM 51-30-2. (M)
Back to N976AS, cancelled Mar 30, 2015