Denver, NC
Registered aircraft · 47
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 = 'NC' AND g.registrant_city = 'DENVER' 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 = 'NC' AND g.registrant_city = 'DENVER' 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.
N1102EBellanca 7ECA · S/N 1211-77N121VRRaddatz Steven G RV-10 · S/N 40698N155ERGates Learjet 55 · S/N 55-098N155SJGates Learjet 55 · S/N 102N1608CCessna 180 · S/N 30308N1963JPiper PA-32-301T · S/N 328024038N2157NPiper PA-32RT-300T · S/N 32R-7987097N2205YPiper PA-28-201T · S/N 28-7921013N238AXGates Learjet 55 · S/N 030N251TSGates Lear Jet 25B · S/N 201N25870Piper J3C-65 · S/N 3827N270JPGates Learjet 55 · S/N 078N2711WMooney M20E · S/N 1022N275BACirrus Design SR20 · S/N 11344N2946LMooney M20C · S/N 670080Registration pending, pending cancellationN310PECessna 310R · S/N 310R1861N335APRobinson Helicopter R44 II · S/N 13376N3553LCessna 150F · S/N 15062353N355RMGates Learjet 55 · S/N 033N355UAGates Learjet 55 · S/N 114N37315Cessna 340A · S/N 340A0341N3776FCessna 172H · S/N 17255271Registration pending, pending cancellationN3966LCessna 172G · S/N 17254135N4042MPiper PA-31-325 · S/N 31-8112014N429FCGates Learjet 55 · S/N 091N4362XPiper PA-28-180 · S/N 28-7505259N461WWRepublic RC-3-1 · S/N 461N5152RCessna 172M · S/N 17263369N5455MConsolidated Aeronautics LAKE LA-4 · S/N 706N56780Piper PA-28R-200 · S/N 28R-7435041N590RPiper PA-28-140 · S/N 28-21327N704CTCirrus Design SR22T · S/N 9633N717AMGates Learjet 55 · S/N 100N725JSGates Lear Jet 25C · S/N 156N737QRCessna 172N · S/N 17269596N7701LGates Lear Jet 24D · S/N 288N773VMooney M20R · S/N 29-0265N79248Cessna 172K · S/N 17257996N817TCThunder & Colt Airborne Amer COLT 77A · S/N 2462USAN82131Piper PA-32-301 · S/N 32-8006053N833MCirrus Design SR22 · S/N 1338N8388WPiper PA-28-180 · S/N 28-2592N8499WPiper PA-28-180 · S/N 28-2747N905EMPiper PA 46-350P · S/N 4636728N954MLTextron T182T · S/N T18209149N956EACessna 340A · S/N 340A-0085N958RTTurczany Robert VANS RV-9A · S/N 92245
Back to Denver, NC