San Luis Obispo, CA
Cancelled registrations · 86
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'CA' AND d.registrant_city = 'SAN LUIS OBISPO' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'CA' AND d.registrant_city = 'SAN LUIS OBISPO' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N3319BAerospatiale SA319B ALOUETTE III · S/N 2030N7257PCessna 172R · S/N 17280786N670ATBeech B90 · S/N LJ-481N7323KPiper PA-20-135 · S/N 20-268N3235PPiper PA-23-150 · S/N 23-1179N68603Cessna 152 · S/N 15282315N3279ECessna 172N · S/N 17271490N801QWLockheed Martin FURY BLOCK 10 · S/N AV029N767LCDJI PHANTOM 2 VISION + · S/N PT646037103N699GFLockheed Martin FURY BLOCK 10 · S/N AV022N699HFLockheed Martin FURY BLOCK 10 · S/N AV023N699JFLockheed Martin FURY BLOCK 10 · S/N AV025N889PCLockheed Martin FURY BLOCK 10 · S/N AV026N890PCLockheed Martin FURY BLOCK 10 · S/N AV020N25076Piper J3C-65 · S/N 3645N341CPCirrus Design SR22 · S/N 3245N2252DCessna 170B · S/N 20404N337LJCessna P337H · S/N P3370294N3FVHarmuth BABY LAKES · S/N 7210B-409BN80566Day Jacque V G MARK III · S/N 1N225DHBeech 95-B55 (T42A) · S/N TC-1271N6231MStinson 108-3 · S/N 108-4231N711AXCessna 310H · S/N 310H0093N79226Cessna 172K · S/N 17257978N5539LNicolaides John D. FLYER 10 · S/N N10NFN2054HBalloon Works FIREFLY 6B · S/N 6680N9063ACessna 170A · S/N 18822N27692Taylorcraft BL-65 · S/N 2334N3031SCessna 150G · S/N 15066931N4342BPiper PA-28-161 · S/N 28-8416050N4931HCessna 152 · S/N 15284026N9214YPiper PA-31-310 · S/N 31-278N8469SCessna 182H · S/N 18256569N714RHCessna 150M · S/N 15079371N71727Luscombe 8C · S/N 3154N68618Orion D200 · S/N D200XN6575BMooney M20A · S/N 1245N6185QCessna 320B · S/N 320B0002N4042UCessna 150E · S/N 15061442N43702Taylorcraft BC12D-85 · S/N 7361N792JBBowers Fly Baby 1-A · S/N 67-48N3741PPiper PA-22-150 · S/N 22-3461N86801Bellanca 8GCBC · S/N 20-74N44028Taylorcraft BC12-D · S/N 9828N5488YCessna T210N · S/N 21064226N279JBeech E35 · S/N D-3946N533RGCessna 182P · S/N 18262419N8608WPiper PA-28-235 · S/N 28-10124N10PLCessna 180J · S/N 18052588N4175BAero Commander 520 · S/N 520-81
Back to San Luis Obispo, CA