N746SK
Service difficulty reports · 226
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 = 'N746SK' 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 = 'N746SK' 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 SWIA201023595Light · inoperativeCEILING EMERGENCY FLOODLIGHT ADJACENT TO ROW 14 INOP. (FLT 6644) RELAMPED EMERGENCY LIGHT.SDR SWIA201023552Light · inoperativeNR 2 CABIN CEILING EMERGENCY LIGHT INOP. (FLT 6572) RELAMPED EMERGENCY LIGHT.SDR SWIA200923120Light · inoperativeROW 4 EMERGENCY OVERHEAD LIGHT INOP. (FLT 6942) RELAMPED EMERGENCY LIGHT.SDR SWIA200923006Light · inoperativeEMERGENCY CEILING LEVEL FLOODLIGHT OVER ROW 15 INOP. (FLT 6093) RELAMPED EMERGENCY LIGHT.SDR SWIA200922854Light · inoperativeSECOND TO LAST CEILING LEVEL EMERGENCY FLOODLIGHT INOP. (FLT 6100) RELAMPED EMERGENCY LIGHT.SDR SWIA200922657Light · inoperativeNR 2 EMERGENCY CEILING LIGHT INOP. (FLT 5818) RELAMPED EMERGENCY LIGHT.SDR SWIA200922528Adc · malfunctionedCAPTAINS AND FIRST OFFICERS ALTIMETER READINGS BEYOND LIMITS. (FLT 6097) REPLACED NR 1 ADC.SDR SWIA200922356Light · inoperativeMAIN CABIN DOOR EMERGENCY LIGHT INOP. (FLT 6704) RELAMPED EMERGENCY LIGHT.SDR SWIA200921776Light · inoperativeEMERGENCY EXIT LIGHT INOP. (FLT 6547) RELAMPED EMERGENCY LIGHT.SDR SWIA200921719Lamp · burned outFLT 5987 - OVERHEAD EMERGENCY FLOODLIGHT NR 6 INOP. RELAMPED.SDR SWIA200921612Lamp · burned outFLT 5952 - NR 4 EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921567Lamp · burned outFLT 6644 - LOWER LEFT SIDE OVERWING EMERGENCY EXIT SIGN INOP. RELAMPED.SDR SWIA200921525Windshield · crackedFLT 6543 - CAPTAINS WINDSHIELD CRACKED. REPLACED WINDSHIELD.SDR SWIA200820506Lamp · burned outCLT 6663 - CEILING EMERGENCY FLOOD LIGHT, AFT CABIN, INOP. RELAMPED.SDR SWIA200820278Light · inoperativeNR 4 CEILING LEVEL EMERGENCY FLOODLIGHT INOP (FLT 5818). RELAMPED EMERGENCY LIGHT.SDR SWIA200820249Battery · dischargedFLT 6564 - EMERGENCY EXIT SIGN LEFT SIDE INOP. REPLACED CHARGER AND BATTERY.SDR SWIA200820039Steering Sys · malfunctionedCAUTION STEERING INOP. MESSAGE UPON TOUCH DOWN (WOW) RUNWAY 120 IN SAT AIRCRAFT VEERED OFF THE RUNWAY. CLEARED NWS PLT HANDWHEEL FAULT CHECKED RIGGING OF NWS CONTROL BOX. PERFORMED TAXI CHECK.SDR SWIA200819448Battery Pack · dischargedFLT 6612 - EMERGENCY LIGHT IN FRONT OF CABIN IS INOP. REPLACED NR 1 ELBP AS REQUIRED. LIGHTS OPS CHECK GOOD.SDR SWIA200719016Power Supply · dischargedFLT 6710 - OVERHEAD EMERGENCY LIGHT POD IS INOP. REPLACED NR 4 ELBP IAW CRJ AMM 33-51-17. OPS CHECK GOOD.
SDR SWIA200719168Control Cable · frayedLEFT OUTBOARD RUDDER CABLE IS WORN, FOUND AT C-CHECK. REPLACED RUDDER CABLE IAW CRJ7/9 AMM 27-21-00-400-801-A02.
SDR SWIA200717812Windshield · crackedON CLIMB-OUT ABOUT FL190, THE F/O WINDSHIELD CRACKED. REPLACED RIGHT WINDSHIELD PER AMM 56-12-01. OPS CHECK GOOD, P/N OFF: NP139321-003, S/N OFF: 04231H3790.SDR SWIA200717799Sign · inoperativeLIGHTED "EXIT" PLACARD ON GALLEY SERVICE DOOR FAILS TO LIGHT. SECURED CONNECTION AT GALLEY SERVICE DOOR TOP EXIT SIGN LIGHT ASSEMBLY. OPERATIONAL CHECKS GOOD.SDR SWIA200617207Step · crackedPAX DOOR HAS 2 CRACKS ON FWD AND AFT ENDS OF SECOND STAIR FROM THE TOP, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS PER BOMBARDIER PER REO 670-52-11-104 AND RII 52-900-1000.SDR SWIA200617019Acm · malfunctionedAFTER ENGINE START WITH BOTH PACKS ON, RECEIVED SIGNIFICANT AMOUNT OF SMOKE AND DIRT IN COCKPIT. LEFT PACK AUTO FAIL MESSAGE AND TEMP FAIL MESSAGE. REPLACED LEFT SIDE ACM IAW CRJ MM 21-51-08. OPERATIONAL CHECKS GOOD, SN OFF: 00911.SDR SWIA200616540Control Unit · malfunctionedSLAT HALFSPEED STATUS MSG. REPLACED NR 2 SFECU IAW AMM 22-51-01. OPERATIONAL CHECK GOOD.SDR SWIA200515511Detector · malfunctionedFLAPS HALFSPEED STATUS MESSAGE AFTER DEPARTING ORD. REPLACED LEFT OB FLAP, OB SENSOR IAW MM 27-52-45. OPERATIONAL CHECK GOOD.
Back to N746SK