Sebastian, FL
Cancelled registrations · 56
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 = 'FL' AND d.registrant_city = 'SEBASTIAN' 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 = 'FL' AND d.registrant_city = 'SEBASTIAN' 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.
N613KTBennett Kirkland E VELOCITY 173 RG ELTE · S/N DMO-386N3258ZPiper PA-22-160 · S/N 22-7207N135BGAnthony Croenlein SPRINT · S/N 9569087N8976LGrumman American Avn. AA-1B · S/N AA1B-0426N122SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0630N637SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0637N663SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0664N738SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0638N787SXCzech 4 Sky A S SKYCRUISER · S/N 01001N511VTVelocity VELOCITY SERG 173 · S/N SEG 475N4644ZPiper PA-22-108 · S/N 22-8164N843RAChristian Eagle RA-3 · S/N 002N840RAChristian Eagle RA-2 · S/N 001N8447RPiper PA-28-140 · S/N 28-22331N909CTBuckeye Industries BREEZE LX-912 · S/N 16454N9062HCessna 172M · S/N 17265924N2890PConsolidated Aeronautics LAKE LA-4-200 · S/N 939N243RAChristian Eagle MACKEY SQ2 · S/N TCQ1008072N811BFBeech H-18 · S/N BA-659N761BCCessna T210M · S/N 21062117N5167CBeech B35 · S/N D-2452N92LRRandolph Lloyd FIRESTAR · S/N FS11444N5123XCoker Adetokunbo EXEC 162F · S/N 6124N91WXBuckeye BREEZE · S/N 16384N347CStinson 108-2 · S/N 108-3347N27902Piper PA-31-350 · S/N 31-7952037N4848UCessna 210-5A · S/N 205-0548N20VEAero Commander 520 · S/N 520-62N6375PPiper PA-24-250 · S/N 24-1485N452WLLanza Wayne T COZY MK III · S/N 49N52BZBretscher Robert G VELOCITY 173RG · S/N 104BN1208NLockheed F-5G · S/N 7700N1977WBeech B19 · S/N MB-655N7202SCoker Adetokunbo STREAK SHADOW · S/N 222N59TTTomaszewski Tommy E RANS S-4 COYOTE · S/N 99280N8114PMcknight Michael P NIEUPORT 17 · S/N 00894N4905DCessna 182A · S/N 51005N356TCSwearingen SA226TC · S/N TC356N69266Cessna 152 · S/N 15282591N714JBCessna 150M · S/N 15079202N915SKWatkins Basil Kirke EXPRESS 90 FT · S/N 0110N48447Cessna 152 · S/N 15280911N49767Cessna 152 · S/N 15283506N5413BCessna 152 · S/N 15283866N8761NPiper PA-28-140 · S/N 28-25583N101SBCessna 401 · S/N 401-0241N19097Cessna 150L · S/N 15074167N60476Cessna 150J · S/N 15070339N111KESwing Duane VELOCITY · S/N DMO122N4717XCessna 150G · S/N 15064767
Back to Sebastian, FL