Registered aircraft · 17

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'CO' AND g.registrant_city = 'CEDAREDGE' ORDER BY g.n_number

duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'CO' AND g.registrant_city = 'CEDAREDGE'
  ORDER BY g.n_number"

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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'CO' AND g.registrant_city = 'CEDAREDGE'
ORDER BY g.n_number

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.

N1047QPiper PA-28R-201T · S/N 28R-7703049Built 1977 · Taras Brock DBA N1580APiper PA-20 · S/N 20-814Denton David W N171SEBarnosky Michael/Barnosky Jose RV-7 · S/N 73475Barnosky Michael W N175MWCameron Balloons Z-90 · S/N 6432Built 2006 · Barnosky Joseph J N404CXWilcox Glen THATCHER CX4 · S/N 404Built 2013 · Waterman Marc K N42950Piper J3C-65 · S/N 15309Built 1945 · Poeling Thomas C N457DMCessna 340A · S/N 340A0554Built 1978 · Major Development LLC N50552Konte William RANS S 7 COURIER · S/N 0802326Built 2005 · Waterman Marc K N519DFWilliams Marlin D KR-2 · S/N 9191Built 2017 · Williams Marlin D N5297BMooney M20 · S/N 1159Built 1956 · Hughes Shaman N6103JPiper PA-28-235 · S/N 28-7610121Built 1976 · Lance Shane N620XSCameron Balloons US V-31 · S/N 6563Built 2012 · Barnosky Joseph J N713PPMerle Lynch / Paul Phillips LYNCH/PHILLIPS TRIKE · S/N P1Lynch Merle N76MPPhoenix Air Sro U-15 PHOENIX · S/N 20/U15Built 2013 · Gates Kenneth E N7836WTheodore J Waltman BACKCOUNTRY SUPERCUB · S/N TCQ1302087Built 2014 · Waltman Theodore J N8623PPiper PA-24-260 · S/N 24-4070Built 1964 · Major Development LLC N923PSSprague Jack ACROSPORT I · S/N 923Built 2010 · Waterman Marc K

Back to Cedaredge, CO