N804SK
Service difficulty reports · 289
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 = 'N804SK' 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 = 'N804SK' 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 SWIA201229409Floorbeam · crackedFS 280 FLOORBEAM IS CRACKED AND CORRODED. (C-CHECK) REPAIR CRACK AND CORROSION AT FS 280 OF FLOORBEAM.SDR SWIA201129044Light · inoperativeTHE 2ND OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4464) RELAMPED EMERGENCY LIGHT.SDR SWIA201128592Light · inoperativeLAST TWO OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4797) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128508Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4637) RELAMPED EMERGENCY LIGHT.SDR SWIA201128174Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (FLT 4703) RELAMPED EMERGENCY LIGHT.SDR SWIA201128040Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4484) RELAMPED EMERGENCY LIGHT.SDR SWIA201127201Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4819) RELAMPED EMERGENCY LIGHT.SDR SWIA201126914Light · inoperativeOVERHEAD EMERGENCY LIGHTS AT ROWS 5, 10 AND 13 ARE OUT. (FLT 4740) RELAMPED EMERGENCY LIGHTS.SDR SWIA201126807Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4701) RELAMPED EMERGENCY LIGHT.SDR SWIA201126719Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4695) RELAMPED EMERGENCY LIGHT.SDR SWIA201126648Connector · unsecureANTI-ICE DUCT WARNING MESSAGE. (FLT 4695) TIGHTENED CONNECTOR ON LEFT WING TELESCOPIC DUCT.SDR SWIA201126620Light · inoperativeNEXT TO AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4506) RELAMPED EMERGENCY LIGHT.SDR SWIA201126529Door · lack of lubeMAIN CABIN DOOR DIFFICULT TO OPEN FROM INSIDE. (FLT 4631) CLEANED AND LUBED MAIN CABIN DOOR.SDR SWIA201126491Light · inoperativeCEILING EMERGENCY LIGHT NEAR ROW 12 IS OUT. (FLT 4616) RELAMPED EMERGENCY LIGHT.SDR SWIA201126232Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 IS OUT. (FLT 4790) RELAMPED EMERGENCY LIGHT.SDR SWIA201126100Light · inoperativeOVERHEAD EMERGENCY LIGHTS AT ROW 5 AND ROW 15 ARE OUT. (FLT 4521) RELAMPED EMERGENCY LIGHTS.SDR SWIA201125943Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT BURNT OUT. (FLT 4661) RELAMPED EMERGENCY LIGHT.SDR SWIA201125807Mount · corrodedRIGHT ENGINE AFT MOUNT HAS PITTING. (ENGINE CHANGE) REPLACED THE RIGHT ENGINE AFT THRUST MOUNT.SDR SWIA201024681Quick Disconnect · wornNR 4 BRAKE LOCKED UP DURING TAXI-IN. (FLT 4588) REPLACED NR 4 QUICK DISCONNECT FITTING.SDR SWIA201024369Beam · corrodedFS 280 BEAM CRACKED AND CORRODED. (C CHECK) REPAIRED PER REO AND INSTALLED PER SRM.SDR SWIA201024654Beam · crackedFS 280 BEAM CRACKED AND CORRODED. (C-CHECK) REPLACED PER SRM.SDR SWIA201024653Bulkhead · corrodedFS 280 LOWER BULKHEAD WEB CORRODED. (C CHECK) REPAIRED PER SRM.SDR SWIA201024295Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 INOP. (FLT 4733) RELAMPED EMERGENCY LIGHT.SDR SWIA201024148Light · inoperativeAFT CENTER CEILING LIGHT INOP. (FLT 4643) RELAMPED CEILING LIGHT.SDR SWIA201023870Light · inoperativeEMERGENCY EXIT LIGHTING INOP BY SERVICE DOOR. (FLT 4487) RELAMPED EMERGENCY LIGHT.SDR SWIA201023656Light · inoperativeCABIN CEILING EMERGENCY LIGHT INOP. (FLT 4720) RELAMPED EMERGENCY LIGHT.SDR SWIA201023412Light · inoperativeEMERGENCY FLOODLIGHT NR 2 ON CEILING INOP. (FLT 4632) RELAMPED EMERGENCY LIGHT.SDR SWIA200923293Light · detachedFLOOR ILLUMINATION STRIP CAME OFF. (FLT 4496) INSTALLED A NEW FLOOR ILLUMINATION STRIP.SDR SWIA200923055Light · inoperativeEMERGENCY CEILING LIGHT AT ROW 17 INOP. (FLT 4766)RELAMPED.SDR SWIA200922944Printer · malfunctionedACARS PRINTER STARTED SMOKING. (FLT 4487) REPLACED ACARS PRINTER.SDR SWIA200922871Light · inoperativeEMERGENCY LIGHTS IN CEILING INOP. (FLT 4565) RELAMPED EMERGENCY LIGHT.SDR SWIA200921609Lamp · burned outFLT 4821 - CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921360Lamp · burned outFLT 4496 - AFT OVERHEAD EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200920815Light · inoperativeFLT 4598 - SECOND FROM THE REAR EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200820386Lamp · burned outFLT 4522 - EMERGENCY CEILING FLOOD LIGHTS INOP AT ROW 20. RELAMPED.SDR SWIA200820317Coffeemaker · smokeFLT 4680 - COFFEEMAKER HAD BURNING SMELL, SET OFF LAVATORY SMOKE ALARM. REPLACED COFFEEMAKERS.SDR SWIA200819936Light · inoperativeEMERGENCY CABIN LIGHT INOPERATIVE. (FLIGHT NR 4070) REPLACED EMERGENCY LIGHT IAW 33-51-21. OPS CHECK OK.
SDR SWIA200718617Pump · leakingRECEIVED A "HYD 2 LO PRESS" CAUTION MESSAGE ON ARRIVAL, FLIGHT NR 2056. REPLACED NR 2 EDP IAW CRJ 900 AMM 29-11-01.SDR SWIA200717790Unknown · odorVERY STRONG FUEL SMELL IN COCKPIT/CABIN ABOUT 3 MINUTES AFTER APU START. PERFORMED OPS CHECK OF THE ENGINE, APU AND PACKS. COULD NOT DUPLICATE DISCREPANCY.
Back to N804SK