Fort Lupton, CO
Registered aircraft · 26
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 = 'FORT LUPTON' 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 = 'FORT LUPTON' 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.
N1084WAndrew J Parks SE5A · S/N C1084N152RBEberle John S FOLKER DR-1 TRIPLANE · S/N 20936N170MFOMF OMF-100-160 · S/N 0017N185NSLafayette Foundation F1 CAMEL · S/N 1445N18852Parks FOKKER D-VII REPLICA · S/N 20N1917JRushton Donald SE5A REPLICA · S/N F-904N210JVCessna 210L · S/N 21059850N2447ECessna T182T · S/N T18208767N29RGAviat PITTS S-2B · S/N 5229N3202KGlobe GC-1B · S/N 1195N3424SCessna 182G · S/N 18255824N3573GCallair A-9 · S/N 1082N372FDDe Santi Michael P VANS RV-9 · S/N 91851N4363PDesanti Michael P AEROMARINE KLEMM · S/N 3001N43889Olson Perry D TITAN 51 MUSTANG · S/N M02914SOHK0009N4JEEickmeier John L PITTS SPECIAL S1C · S/N JLE-001N52RTTallini Robert J SE5A · S/N 078252N559MWMarkham Mike W KITFOX IV · S/N 1559N6005CCirrus Design SR22 · S/N 0597N628EKGates Learjet 55 · S/N 071N75067Aeronca L-16A · S/N 7BCM-101N757FKPerikles John J FOK-DRI · S/N 1972N8353DPiper PA-28-181 · S/N 28-8190189N9051QPiper PA-12 · S/N 12-619N913DMCubcrafters CC11-160 · S/N CC11-00401N9887HHoward DGA-15P · S/N 748
Back to Fort Lupton, CO