N773SK
Service difficulty reports · 160
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 = 'N773SK' 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 = 'N773SK' 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 SWIA201334187Acm · failedTHICK HAZE IN THE CABIN. RT PACK FAILED WITH A HIGH OUTPUT TEMPERATURE. FLT#6514 REPLACED RT AIR CYCLE MACHINE IAW AMM. PN ON GG670-95009-3, PN OFF GG670-95009-5, SN ON 00904 & SN OFF 00850.SDR SWIA201334059Lens · missingCOVER MISSING ON FLOOR LEVEL EMERGENCY EXIT SIGN AT GALLEY SERVICE DOOR. FLT#6389 RE-INSTALLED LENS ON FLOOR LEVEL EMERGENCY EXIT SIGN.SDR SWIA201333539Light · inoperativeNR 4 EMERGENCY OVERHEAD LIGHT IS BURNED OUT, RELAMPED.SDR SWIA201333538Light · inoperativeNR 3 EMERGENCY OVERHEAD LIGHT IS BURNED OUT, RELAMPED.SDR SWIA201333485Bulb · burned outONE BULB IN EMERGENCY EXIT SIGN BY LT EMERGENCY EXIT OVERWING DOOR IS BURNED OUT. REPLACED BULB.SDR SWIA201333123Light · inoperativeTHIRD EMERGENCY CEILING POD LIGHT FROM FRONT BURNED OUT. (FLT 5617) RELAMPED EMERGENCY LIGHT.SDR SWIA201333019Light · inoperativeLEFT SIDE BOTTOM OVERWING EMERGENCY LIGHT PLACARD IS BURNED OUT. (FLT 6405) RELAMPED EMERGENCY LIGHT.SDR SWIA201332860Light · inoperativeCEILING EMERGENCY LIGHTS OVER ROW 8 BURNED OUT. (FLT 6241) RELAMPED EMERGENCY LIGHTS.SDR SWIA201232326Light · inoperativeOVERHEAD EMERGENCY LIGHT IN FIRST CLASS BURNED OUT. (FLT 6299) RELAMPED NR 1 POD LIGHT REF CRJ MM 33-51-09. OPS CHECK GOOD.SDR SWIA201231816Sign · missingFLOOR LEVEL EMERGENCY EXIT SIGN IN GALLEY IS MISSING. (FLT 5193) REPLACED SERVICE DOOR FLOOD LIGHT IN REFERENCE TO AMM.SDR SWIA201231772Light · inoperativeEMERGENCY EXIT LIGHT AT ROW 12AB HAS 1 LIGHT BULB BURNED OUT. (FLT 6501) RELAMPED EMERGENCY LIGHT.SDR SWIA201231695Light · inoperativeTHREE OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 6424) RELAMPED EMERGENCY LIGHTS.SDR SWIA201231668Structure · corrodedINNER CHORD AT FS 1031-1047 AT AFT CARGO DOOR IS CORRODED. (C-CHECK) REPLACED INNER CHORD AT FS 1031-1047 IN REFERENCE TO CRJ700 SRM.SDR SWIA201231686Skin Panel · chafedRIGHT AILERON UPPER LEADING EDGE SKIN CHAFED. (C-CHECK) REPLACED RIGHT AILERON LEADING EDGE SKIN PANEL, PART # CC670-13052-4 IN REFERENCE TO CRJ 700 SRM.SDR SWIA201231688Sill · corrodedLEFT FLOOR SILL HAS CORROSION FROM FS 969.00 TO FS 1000.00. (C-CHECK) REPLACED THE FLOOR SILL AND INNER CORD AT FS 969.99 TO FS 1000.00 IN REFERENCE TO CRJ 700 SRM.SDR SWIA201231687Skin · chafedLEFT AILERON UPPER LEADING EDGE SKIN CHAFED AT INBOARD AND OUTBOARD SIDES OF INBOARD HINGE. (C-CHECK) REPLACED LEFT AILERON UPPER LEADING EDGE SKIN IN REFERENCE TO CRJ700 SRM.SDR SWIA201231670Crossbeam · crackedFS 280.0 CROSSBEAM IS CRACKED. (C-CHECK) REPAIRED FS 280.0 CROSSBEAM PER REO.SDR SWIA201231669Sill · corrodedLEFT SILL UNDER FLOORBOARD FROM FS 1000.00 TO FS 1047.00 HAS CORROSION. (C-CHECK) REPLACED LEFT FLOOR SILL FROM FS 1000.00 TO FS 1047.00 PER CRJ700 SRM.SDR SWIA201231188Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230477Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5367) RELAMPED EMERGENCY LIGHT.SDR SWIA201230407Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6648) RELAMPED EMERGENCY LIGHT.SDR SWIA201230349Lamp · burned outFLT 5441, NR 1 OVERHEAD EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201230085Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230086Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230037Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229772Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5367) RELAMPED EMERGENCY LIGHT.SDR SWIA201229363Light · inoperativeNR 3, 4, AND 6 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 6227) RELAMPED EMERGENCY LIGHTS.SDR SWIA201229362Light · inoperativeOVERHEAD EMERGENCY LIGHT ON ROW 14 AND 15 IS OUT. (FLT 5360) RELAMPED EMERGENCY LIGHT.SDR SWIA201128947Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT OUT. (FLT 6230) RELAMPED EMERGENCY LIGHT.SDR SWIA201128866Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5167) RELAMPED EMERGENCY LIGHT.SDR SWIA201128298Light · brokenGALLEY EMERGENCY LIGHT COVER & BULBS BROKEN. (FLT 5192) REPLACED GALLEY EMERGENCY LIGHT COVER AND BULBS.SDR SWIA201128030Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6240) RELAMPED EMERGENCY LIGHT.SDR SWIA201128000Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6535) RELAMPED EMERGENCY LIGHT.SDR SWIA201127763Light · inoperativeTHE 4TH OVERHEAD EMEGENCY LIGHT IS BURNED OUT. (FLT 6508) RELAMPED EMERGENCY LIGHT.SDR SWIA201127674Light · inoperativeEMERGENCY LIGHT AT ROW 8 IS OUT. (FLT 5639) RELAMPED EMERGENCY LIGHT.SDR SWIA201126730Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126729Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6284) RELAMPED EMERGENCY LIGHT.SDR SWIA201126703Light · inoperativeNR 1 CEILING EMERGENCY LIGHT BURNED OUT. (FLT 6450) RELAMPED EMERGENCY LIGHT.SDR SWIA201126452Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6384) RELAMPED EMERGENCY LIGHT.SDR SWIA201125947Light · inoperativeGALLEY DOOR EMERGENCY EXIT LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201125822Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 7029) RELAMPED EMERGENCY LIGHT.SDR SWIA201125640Floorbeam · crackedFS 280 FLOORBEAM IS CRACKED AT RIGHT SIDE. (C-CHECK) REPAIR PER REO.SDR SWIA201024410Light · inoperativeGALLEY SERVICE DOOR EMERGENCY LIGHT INOP. (FLT 6712) RELAMPED EMERGENCY LIGHT.SDR SWIA201024324Mount · corrodedLEFT ENGINE, AFT THRUST SHAFT, CORRODED. (ENG CHANGE) REPLACED AFT THRUST MOUNT PER AMM.SDR SWIA201023985Acm · malfunctionedRIGHT PACK FILLED CABIN WITH SMOKE. (FLT 6023) REPLACED RIGHT AIR CYCLE MACHINE. P/N OFF: GG670-95009-3, S/N OFF: 01094.SDR SWIA201023808Battery Pack · dischargedMULTIPLE EMERGENCY LIGHTS INOP. (FLT 6212) REPLACED THREE EMERGENCY LIGHT BATTERY PACKS.SDR SWIA200923422Light · inoperativeAFT EMERGENCY CEILING LIGHT INOP. (FLT 6541) RELAMPED EMERGENCY LIGHT.SDR SWIA200923184Light · inoperativeEMERGENCY LIGHT SECOND FROM AFT INOP. (FLT 5796) RELAMPED EMERGENCY LIGHT.SDR SWIA200921228Lamp · burned outFLT 6442 - FLOOR LEVEL EXIT LIGHT AT SERVICE DOOR BROKEN. RELAMPED.SDR SWIA200921016Lens · missingFLT 6318 - CABIN SERVICE DOOR FLOOR LEVEL EMERGENCY FLOODLIGHT IS MISSING LENS. REPLACED LENS.
Back to N773SK