Centennial, CO
Registered aircraft · 91
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 = 'CENTENNIAL' 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 = 'CENTENNIAL' 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.
N111HBHead Balloons AX8-88 · S/N 463N111WSMooney M20R · S/N 29-0290N118TMAmerican Champion 7GCBC · S/N 1303-2000N1306WMooney M20E · S/N 194N137ZMBombardier BD-700-1A11 · S/N 9275N141XLAlbert M Khasky VELOCITY XL-RG · S/N 3RX084N142YXSheryka Nicholas SONEX WAIEX · S/N W0142N165ARCessna 172S · S/N 172S8018N17912Schweizer SGS 1-26E · S/N 542N1846ZCessna 180K · S/N 180-52968N185JLCessna A185F · S/N 18503612N1889DBeech C35 · S/N D-3161N1985HKubicek Factory S R O BB30M · S/N 2349N20272Cessna 172M · S/N 17261148N2140KLuscombe 8A · S/N 4867N2165CCessna 195B · S/N 16150N219JGRaytheon C90A · S/N LJ-1470N2296N8174y M24 ORION PLUS · S/N 24224136N233LDFlight Design CTSW · S/N 07-01-10N25JGCessna P210N · S/N P21000329N2618PPiper PA-22-150 · S/N 22-2954N2649PPiper PA-22-150 · S/N 22-2987N267WSMooney M20E · S/N 1000N303HMGulfstream Aerospace GVI (G650) · S/N 6345N303XCessna 182C · S/N 52957N309LBHawker Beechcraft B200GT · S/N BY-124N3187BCessna 170B · S/N 25429N3310APiper PA-22-135 · S/N 22-1587N331VRA A Sovran ZENITH CH-300 · S/N 509N336ASStrickland A C III RV-6 · S/N 22336N34521Cessna 177B · S/N 17701856N357PJRotorsport UK ROTORSPORT UK CAVALO · S/N RSUK-V00611N3614NSchweizer SGS 1-36 · S/N 2N3669QBeech A23-24 · S/N MA-256N3951VCessna 170 · S/N 18376N4040LBalloon Works FIREFLY 7 · S/N 7835N428DMDowning Charles E GLASAIR FT · S/N 428N444VVBucher E Philip AMERICAN FALCON · S/N 04N44682Piper PA-28-140 · S/N 28-7425437N4612KCessna P210N · S/N P21000236N4681SCessna TR182 · S/N R18201377N46HCCammack Howard D RV-3 · S/N 11236N4832VMooney M20K · S/N 25-0371N56HSGates Learjet 55 · S/N 072N6082RPiper AEROSTAR 601P · S/N 61P07628063378N617BCJohn Howard RANS S-21 OUTBOUND · S/N 10250450N618LLearjet 60 · S/N 267N620ABCirrus Design SR22T · S/N 11484N6289SCessna 150G · S/N 15067089N650KTGulfstream Aerospace GVI (G650ER) · S/N 6461
Back to Centennial, CO