N898SK
Service difficulty reports · 118
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 = 'N898SK' AND registry_match = 'registration' 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 = 'N898SK' AND registry_match = 'registration' 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 SWIA201642362Longeron · corrodedCORROSION ON LONGERON 25R BETWEEN BS 333 - 349. REMOVED AND REPLACED THE LONGERON IAW SRM AND DWG. LEAK CHECKED GOOD IAW SRM.SDR SWIA201642363Stringer Splice · corrodedCORROSION AROUND FASTENER HOLES ON STRINGER SPLICE 25R, AFT OF THE FRAME AT BS 333. REMOVED AND REPLACED THE STRINGER SPLICE IAW SRM. LEAK CHECKED GOOD.SDR SWIA201641867Tire · failedNR 3 MAIN TIRE BURST ON T/O. DAMAGE TO RT FLAP, AND POSSIBLE ENGINE DAMAGE. CONTINUED TO DESTINATION, EMERGENCY LANDING DECLARED. REPLACED NR 3 TIRE. R & R RT INBD FLAP. OPS CHECK GOOD.SDR SWIA201438501Lamp · inoperativeAFT CEILING EMERGENCY OVERHEAD LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWIA201438389Lamp · inoperativeAFT CEILING EMERGENCY LIGHT IS INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWIA201438108Lamp · inoperativeLEFT FUSELAGE AFT MOST EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP IAW AMM.SDR SWIA201437590Hinge · gougedPASSENGER DOOR PIANO HINGE HAS GOUGES AT FORWARD LUG, MARKED. C-CHECK, BLENDED GOUGE REF REO.SDR SWIA201437589Hinge · gougedPASSENGER DOOR PIANO HINGE HAS GOUGES AT AFT LUG NR 5, MARKED. C-CHECK, BLENDED GOUGES, REF REO.SDR SWIA201437594Axle · corrodedLEFT MLG NR 1 AXLE IS CORRODED. C-CHECK, REMOVED CORROSION IAW REO.SDR SWIA201437593Axle · corrodedLEFT MLG NR 2 AXLE IS CORRODED. C-CHECK, REMOVED CORROSION IAW REO.SDR SWIA201437592Axle · corrodedRIGHT MLG NR 3 AXLE IS CORRODED. C-CHECK, REMOVED CORROSION IAW REO.SDR SWIA201437591Axle · corrodedRT MLG 4 AXLE IS CORRODED. C-CHECK, REMOVED CORROSION IAW REO 670-32-11-235.SDR SWIA201437595Seat Track · corrodedRIGHT FLOOR SEAT TRACK HAS CORROSION AT BS 364-379 APPROXIMATELY. C-CHECK, BLENDED OUT CORROSION IAW REO.SDR SWIA201437597Web · unknownREPLACE LT WEB AT F/S 280 IAW REO. C-CHECK, REPLACED LT WEB AT FS 280 IAW REO.SDR SWIA201437596Web · unknownRT WEB AT F/S 280 IAW REO. C-CHECK, REPLACED RT WEB AT FS 280 IAW REO.SDR SWIA201335106Light · inoperativeOVERHEAD EMERGENCY LIGHT NR 6 IS BURNED OUT. FLT 2937 RELAMPED.SDR SWIA201334430Light · inoperative2ND TO LAST EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT#2985 RELAMPED.SDR SWIA201334147Light · inoperativeEMERGENCY OVERHEAD LIGHT IN CABIN IS BURNED OUT. FLT#2974 RELAMPED.
Back to N898SK