Craig, CO
Registered aircraft · 27
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'CRAIG' 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 = 'CRAIG' 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.
N1106APiper PA-18-125 · S/N 18-694N1150APiper PA-18-125 · S/N 18-744N16293Piper PA-28R-200 · S/N 28R-7335123N206LRBell 206L-3 · S/N 51307N20XCCcx-2300-Nx CCX-2300 · S/N CCX-2300-0022N2344GCessna 182B · S/N 51644N360HCPiper PA-18A · S/N 18-1868N37271Interstate S-1A · S/N 114N3907EPiper L-21B · S/N 53-7759N4017VCessna 170 · S/N 18336N4118FCessna 172 · S/N 46018N4191AEa Vision EA J100 · S/N 85467N4239XRockwell International S-2R · S/N 2012RN5393NCessna 182Q · S/N 18267686Registration pendingN53YBEvolution REVO · S/N 000613N663DCXag P100 PRO · S/N 8219343122KPN710WGCessna 182P · S/N 18263570N7173SHiller UH-12E · S/N 2351N7629VAero Commander CALLAIR A-9B · S/N 1357N763BFAyres S2R-G6 · S/N G6-126N7826GCessna 182P · S/N 18263329N7943VAyres S-2R · S/N 2325RN795GMDJI AGRAS T50 · S/N 1581F6BUB24C500163B1N819CTFlight Design CTSW · S/N 07-07-11N915QCPhilip Masse SLING TSI · S/N 326SKN920CJChampion 7GCB · S/N 56N9703XCessna 210B · S/N 21058003
Back to Craig, CO