N772SK
Service difficulty reports · 165
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 = 'N772SK' 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 = 'N772SK' 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 SWIA201024489Light · inoperativeEMERGENCY CEILING LEVEL FLOODLIGHT NR 4 INOP. (FLT 6483) RELAMPED EMERGENCY LIGHT.SDR SWIA201023588Light · inoperativeAFT MOST EMERGENCY CEILING LIGHT INOP. (FLT 6647) RELAMPED EMERGENCY LIGHT.SDR SWIA200923246Light · inoperativeAFT MOST EMERGENCY LIGHT INOP. (FLT 6386)RELAMPED.SDR SWIA200922222Light · inoperativeGALLEY SERVICE DOOR EMERGENCY LIGHT INOP. (FLT 6177) RELAMPED EMERGENCY LIGHT.SDR SWIA200921455Window · crackedFLT 6120 - RIGHT SIDE COCKPIT WINDOW CRACKED ON TAXI. REPLACED THE RIGHT SIDE WINDOW.SDR SWIA200921147Lamp · burned outFLT 6523 - CEILING LEVEL EMERGENCY LIGHT DOES NOT ILLUMINATE. RELAMPED.SDR SWIA200820221Floorbeam · crackedFS 280 FLOORBEAM CRACKED RBL 9.0. C-CHECK, REPAIRED PER SRM.SDR SWIA200820220Bracket · crackedFS 280 RT OUTBOARD INTERCOSTAL BRACKET CRACKED. C-CHECK, REPLACED.SDR SWIA200820219Floorbeam · crackedCOCKPIT FLOORBEAM IS CORRODED AND CRACKED. C-CHECK, REPAIRED PER SRM.SDR SWIA200820218Floorbeam · corrodedLT FS 280 FLOORBEAM CORRODED. C-CHECK, REPAIRED PER SRM.SDR SWIA200820217Floorbeam · crackedFS 280 FLOORBEAM CRACKED. C-CHECK, REPAIRED PER SRM.SDR SWIA200819438Adc · faultyFLT 6064 - FIRST OFFICERS ALTIMETER AND VSI IS FLUCTUATING WHILE IN FLIGHT. REPLACED NR 2 ADC IAW CRJ 700 MM 34-13-01. OPS CHECK GOOD, P/N 822-0372-436, S/N OFF 21VTY.
SDR SWIA200718408Relay · malfunctionedSOME EMERGENCY LIGHTS ARE COMING ON WHEN SWITCH IS IN THE ARMED POSITION. REPLACED RELAY K135. OPS CHECK GOOD.SDR SWIA200718335Charger · malfunctionedCREW REPORTS THAT EMERGENCY LIGHTS STAY ON WITH THE SWITCH IN THE OFF POSITION. REPLACED NR 2 ELBP CHARGER IAW CRJ 700 AMM 33-51-17. OPS CHECK GOOD.SDR SWIA200718250Bulb · inoperativeGALLEY EMERGENCY EXIT LIGHT BULB IS INOP AND COVER IS MISSING. REPLACED LIGHT BULB AND COVER.
Back to N772SK