Elbert, CO
Registered aircraft · 56
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 = 'ELBERT' 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 = 'ELBERT' 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.
N101GMPzl-Swidnik PW-5 · S/N 17.09.009N116YXGillis John WAIEX · S/N 001N14137Waco YKC · S/N 4223N1676RCessna R182 · S/N R18200510N17366Boeing A75N1(PT17) · S/N 75-2339N20769Cessna 182P · S/N 18261188N228RVAdamson Dag R VANS RV8A · S/N 81588N2357VCessna 140 · S/N 14593N2525RCessna 182K · S/N 18258225N265MWaco CSO · S/N AT-3007N269WRockwell International 114A · S/N 14533N2942MPiper PA-12 · S/N 12-1337N29863Taylorcraft BC12-65 · S/N 2714N305TBeech E-55 · S/N TE-952N331DWWatson Darrel E DW1 · S/N 001N333SPCessna 177B · S/N 17702265N334FPParrish Andrew L VANS RV-7A · S/N 71822N34051Taylorcraft BL12-65 · S/N 3006N3483MPiper PA-12 · S/N 12-2339N36397Taylorcraft DL-65 · S/N 4138N3657ZPiper PA-22-160 · S/N 22-7554N373EWWolff Eugene Ted D F A · S/N 80476N37JGJonker Sailplanes JS3 RES · S/N 03-179N397JTAircraft Restoration & Repair SS-300 · S/N 1N4048NCessna 140 · S/N 13506N4297BBeech F35 · S/N D-4245N4386VCessna 195 · S/N 7308N460ACessna 195 · S/N 7553N46KBird BK · S/N 1025N555EBeech K35 · S/N D-5845N565RACessna T210M · S/N 21062347N637CHSchempp Hirth Flugzeugbau ARCUS M · S/N 207N6580KKelley Herbert L GYGNET SF-2A · S/N 368N6646ECessna 175 · S/N 56146Registration pendingN6TASmith J A/Smith V A VANS RV-6 · S/N 24533N701DDDyiak Richard C ZENAIR CH701 · S/N 7-1235Registration pendingN722MGMaule MT-7-260 · S/N 27015CN7549PPiper PA-24-250 · S/N 24-2757N755BHSchempp-Hirth Flugzeugbau VENTUS 3M · S/N 065MPN759SRCessna 182Q · S/N 18266227N75AJStrickfaden Alan C RV-10 · S/N 40809N77798Boeing E75 · S/N 75-8333N7795XCessna 172B · S/N 17248295N7966YPiper PA-30 · S/N 30-1064N79775John Travis Clark RV-6-S6 · S/N 001N801MSFarion Donald PITTS S1 · S/N 585HN8094EMoss Elvin/Aero Structures 2 · S/N 2N837BDDuarte Ben W DUARTE ZENITH 750 · S/N 75-8429N83813Aeronca 7AC · S/N 7AC-2493N84HBBarker Homer E PITTS S-1E · S/N HB-1
Back to Elbert, CO