N975AS, cancelled Jul 7, 2015
Service difficulty reports · 211
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 = 'N975AS' AND deregistration_id = 'N975AS-2015-07-07' 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 = 'N975AS' AND deregistration_id = 'N975AS-2015-07-07' 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 ASAA0680642Floor Panel · delaminatedFOUND CABIN FLOOR PANEL DELAMINATED AT INSERTS. REPLACED FLOOR PANEL PER SRM 53 05.SDR ASAA0680640Floor Panel · delaminatedFOUND CABIN FLOOR PANEL IS DELAMINATED AND HAS PULLED INSERTS. REPLACED PANEL PER SRM 53 05.SDR ASAA0680636Floor Panel · delaminatedFOUND CABIN FLOOR PANEL HAS WATER DAMAGE AND BROKEN INSERTS. REPLACED PANEL PER SRM 53 05.SDR ASAA0680635Floor Panel · delaminatedFOUND CABIN FLOOR PANEL IS DELAMINATED. REPLACED PANEL PER SRM 53 05.SDR ASAA0680634Seat Track · corrodedFOUND CABIN SEAT TRACK CORRODED. REPLACED DAMAGED SECTION OF TRACK PER SRM 53-05.SDR ASAA0680257Engine · seizedRIGHT ENGINE SEIZED ON FINAL APPROACH. REPLACED ENGINE. TEARDOWN REVEALED INITIAL CAUSE TO BE FAILED COMPRESSOR 8TH STAGE STATOR AT BRAZED WELD REPAIR. CRACK ORIGINATED ON VANE OD T/E AND PROPAGATED INTO HCF.SDR ASAA0580153Shear Tie · corrodedC-CHECK - SHEAR TIE CORRODED ON AFT SIDE OF LONGER. REMOVED DAMAGED SECTION AND INSTALLED REPAIR DOUBLERS. (K)SDR ASAA0580155Vane · chafedC-CHECK, RT WING OB FLAP VANE CHAFED BEHIND IB HINGE FAIRING. REMOVED DAMAGED SECTION. INSTALLED REPAIR DOUBLER AND FILLER. (K)SDR ASAA0580156Vane · dentedC-CHECK - RT WING IB FLAP VANE DENTED. REMOVED DAMAGED SECTION. INSTALLED REPAIR DOUBLER AND FILLER. (K)SDR ASAA0580154Intercostal · corrodedC-CHECK - INTERCOSTAL CORRODED ON TOP AND BOTTOM FLANGES. REPLACED INTERCOSTAL. (K)SDR ASAA0580152Cusp Web · canningC-CHECK - CUSP WEB IS (OIL CANNING). REMOVED DAMAGED SECTION AND INSTALLED REPAIR DOUBLER. (K)SDR ASAA0580150Frame · chafedC-CHECK, UPPER LT ACCY COMPARTMENT FWD EDGE OF FRAME WEB IS CHAFED. REMOVED DAMAGED SECTION. INSTALLED REPAIR DOUBLERS AND FILLER. (K)SDR ASAA0580151Intercostal · corrodedC-CHECK, INTERCOSTAL CORRODED. REPLACED INTERCOSTAL. (K)SDR ASAA0580149Cusp Web · corrodedC-CHECK - AFT CABIN UPPER CUSP MEMBRANE IS CORRODED. REMOVED DAMAGED SECTION. INSTALL REPAIR DOUBLER. (K)SDR ASAA0580148Cusp Web · puncturedC-CHECK - FWD CARGO BAY CUSP WEB ABOVE DOOR HINGE INS PUNCTURED. REMOVED DAMAGED SECTION. INSTALLED REPAIR DOUBLER. (K)SDR ASAA0580147Spacer · corrodedC-CHECK - AFT CARGO BAY DOOR BEAM SPACER IS CORRODED. REPLACED SPACER. (K)SDR ASAA0580146Floorboard · crackedC-CHECK - CABIN FLOOR PANEL HAT SECTION IS CRACKED. REPLACED HAT SECTION. (K)SDR ASAA0580145Floorboard · crackedC-CHECK, CABIN FLOOR PANEL HAT SECTION IS CRACKED. REPLACED HAT SECTION. (K)SDR ASAA0480372Module · inoperativePDX - FOUND DURING CHECK, EMERGENCY TRACK LIGHTS INOPERATIVE AT ROWS 26-29. RECONNECTED LOOSE MODULE CONNECTORS. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0480063Smoke Detector · malfunctionedDURING FILGHT, FOUND LEFT AFT LAVATORY SMOKE DETECTOR CAUSED FALSE CHIME ALARM. REPLACED DETECTOR. CHECKED OK. (M)SDR ASAA0380841Floorboard · delaminatedOKC - DURING C-CHECK, FOUND FLOORBOARD PANEL TORN AND DELAMINATED AT FS 313-389. REMOVED DAMAGED AREA AND REPAIRED WITH FIBERGLASS OVERLAP PER SRM 51-90-0. (M)SDR ASAA0380833Shear Tie · corrodedDURING C-CHECK SHEAR TIE FOUND CORRODED AT FS 1212. REMOVED DAMAGED AREA AND INSTALLED DOUBELR PER SRM'S 51-10-2, 51-10-4, 51-30-2, AND 51-30-5. (M)SDR ASAA0280566Floorboard · corrodedOKC - FOUND 30K CHECK, FLOORBOARD HAS NUMEROUS CORRODED INSERTS AND FASTENERS AT FS 207, LBL 22 TO RBL 22. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280567Floorboard · corrodedOKC - FOUND 30K CHECK, FLOORBOARD HAS NUMEROUS CORRODED INSERTS AND FASTENERS AT FS 160-207, BL 0 TO LBL 60. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280568Floorboard · corrodedOKC - FOUND FLOORBOARD HAS NUMEROUS CORRODED INSERTS AND FASTENERS AT FS 207, LBL 22-44. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280569Floorboard · damagedOKC - FOUND 30K-CHECK, FLOORBOARD HAS SOFT SPOT AT FS 218 TO 229, BL 0. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280570Floorboard · puncturedOKC - FOUND DURING 30K-CHECK, FLOORBOARD IS PUNCTURED AT FS 256-275, LBL 36. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280571Floorboard · puncturedOKC - FOUND 30K CHECK, FLOORBOARD IS PUNCTURED AT FS 1117-1174, LBL 22-LBL 44. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280572Floorboard · delaminatedOKC - FOUND 30K-CHECK, FOUND FLOORBOARD IS DELAMINATED FORWARD OF FS 617, RBL 36. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280559Longeron · corrodedOKC - FOUND LONGERON 29R IS CORRODED IN RADIUS AT FS 1180.25-1183. BLENDED AREA PER BAC TLX AOC-OKC-02-0086H AND EA 5310-02134. (M)SDR ASAA0280560Seat Track · corrodedOKC - FOUND 30K CHECK, LEFT INBOARD SEAT TRACK IS CORRODED AT FS 574-598, LBL 22. REMOVED DAMAGED SECTION AND INSTALLED REPAIR PARTS PER SRM 53-05. (M)SDR ASAA0280561Shear Tie · corrodedOKC - FOUND DURING 30K CHECK, SHEAR TIE IN AFT CARGO BAY CORRODED IN TWO AREAS AT FS 1287, L29L TO L29R. REMOVED CORROSION AND REPAIRED WITH DOUBLER PER SRM 53-01, 53-03, AND 51-30-2. (M)SDR ASAA0280563Floor Support · corrodedOKC - FOUND DURING 30K-CHECK, MAIN CABIN FLOOR SUPPORT CORRODED AT FS 195, LBL 44. INSTALLED NEW SUPPORT PER SRM 51-10-2 AND 51-10-4. (M)SDR ASAA0280565Floorboard · damagedOKC - FOUND 30K-CHECK, FLOORBOARD HAS SOFT SPOT AT FS 1003 TO 1022 AT LBL 22 TO RBL 22. REPLACED FLOORBOARD PER SRM 53-05. (M)SDR ASAA0280564Skin · dentedOKC - FOUND DURING 30K-CHECK, FUSELAGE SKIN DENTED AT FS 237 BETWEEN LONGERON 19L AND 20L. INSTALLED DOUBLER REPAIR PER SRM 53-04. (M)SDR ASAA0280558Skin · gougedOKC - FOUND DURING 30K-CHECK, AFT CARGO BAY DOOR SKIN AND SEAL RETAINER GOUGED AT AFT LOWER CORNER. BLENDED GOUGES PER BAC TLX AOC-OKC-02-00126H AND EA 5230-0-1182. (M)SDR ASAA0280562Seat Track · gougedOKC - FOUND DURING 30K-CHECK, LEFT INBOARD SEAT TRACK GOUGED AT FS 693, LBL 22. REMOVED DAMAGED SECTION AND INSTALLED REPAIR PART PER SRM 53-05. (M)SDR ASAA0280545Skin · corrodedOKC - FOUND 30K CHECK, SKIN CORRODED ON INNER SURFACE AROUND FASTENER HOLES AND SEALANT AT FS 1079-1098, LONGERON 28L-28R. REMOVED CORROSION AND REPAIRED PER BAC TLX AOC-OKC-02-0088H AND EA 5330-01609. (M)SDR ASAA0280546Longeron · corrodedOKC - FOUND 30K CHECK, LONGERON 30 CORRODED BY FASTENER AT FS 1007-1022. REMOVED CORROSION AND FASTENER. REPAIRED PER BAC TLX AOC-OKC-02-00080H AND EA 5310-02131. (M)SDR ASAA0280550Longeron · corrodedOKC - FOUND 30K CHECK, LONGERON 30 IS CORRODED AT SPLICE AT FS 1193-1212 ON LOWER SIDE. BLENDED CORROSION, THEN REPAIRED PER BAC TLX AOC-OKC-02-0087H AND EA 5310-02133. (M)SDR ASAA0280555Frame · corrodedOKC - FOUND 30K CHECK, FRAME CORRODED ON AFT SIDE AT FS 1060 BETWEEN LONGERON 29L AND 30. CUT OUT DAMAGE AND REPAIRED PER BAC TLX AOC-OKC-02-00095H, EA 5310-02137. (M)SDR ASAA0280554Longeron · corrodedOKC - FOUND 30K CHECK, LONGERON 29R CORRODED IN TWO AREAS AT FS 1212-1231. BLENDED CORROSION AND REPAIRED PER BAC TLX AOC-OKC-02-00090H, EA 5310-02135. (M)SDR ASAA02280553Longeron · corrodedOKC - FOUND 30K CHECK, LONGERON 30 CORRODED ON BOTTOM AND HORIZONTAL LEG AT FS 1237 AND 1245. BLENDED CORROSION AND REPAIRED PER BAC TLX AOC-OKC-02-00083H, EA 5310-02126. (M)SDR ASAA0280552Shear Tie · corrodedOKC - FOUND 30K CHECK, UPPER SHEAR TIE CORRODED AT FS 1212, LONGERON 28R. REPLACED SHEAR TIE PER SRM 53-24-0, 51-10-2, 51-10-4, AND 51-30-5. (M)SDR ASAA0280556Skin · gougedOKC - FOUND DURING 30K CHECK, MID CARGO BAY DOOR SEAL RETAINERS ARE CHAFED AND SKIN IS GOUGED. BLENDED AND REPAIRED PER BAC TLX AOC-OKC-02-00125H AND EA 5230-01183. (M)SDR ASAA0208547Sill · crackedOKC - FOUND 30K CHECK, R1 DOOR SILL PAN FORWARD EDGE IS CRACKED. WELD REPAIRED PAN EDGE PER EA 53-20-01551. (M)SDR ASAA0280548Skin · gougedOKC - DURING 30K CHECK, FOUND RIGHT WING LOWER LEADING EDGE IS GOUGED AT STATION XFS9. REPAIRED PER BAC TLX AOC-OKC-02-00110H AND EA 5740-01329. (M)SDR ASAA0280549Skin · gougedOKC - DURING 30K CHECK, FOUND RIGHT WING LOWER LEADING EDGE IS GOUGED AT STATION XFS67. REPAIRED PER BAC TLX AOC-OKC-02-00110H AND EA 5740-01329. (M)SDR ASAA0280551Skin · gougedOKC - FOUND 30K CHECK, LEFT WING LEADING EDGE UPPER SKIN GOUGED AT STATION XFS 142. CUT OUT DAMAGED AREA AND REPAIRED PER BAC TLX AOC-OKC-02-0081H AND EA 5740-01330. (M)SDR ASAA0280557Retainer · gougedOKC - FOUND 30K CHECK, MID CARGO BAY DOOR SEAL RETAINERS ARE GOUGED NEAR RADIUS AT FORWARD AND AFT LOWER SEAL RETAINER. BLENDED PER BAC TLX AOC-OKC-02-00125H AND EA 5230-01183. (M)
Back to N975AS, cancelled Jul 7, 2015