Registered aircraft · 31

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'GARNER' ORDER BY g.n_number

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 = 'GARNER'
  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 = 'GARNER'
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.

N1420UCessna 172M · S/N 17267088Built 1976 · Wall Corey N154EFCessna 210J · S/N 21059089Built 1968 · Adams Donald C N169TGRaytheon A36 · S/N E-3627Built 2005 · Nordic Sun LLC N27WHAmerican Champion 8KCAB · S/N 1045-2007Built 2007 · Aviators Unlimited Aviation Holdings LLC N2953ZPiper PA-22-150 · S/N 22-6926Built 1959 · Everette John H N3050WPiper PA-28-201T · S/N 28-7921006Nordic Sun LLC N3244TCessna 177 · S/N 17700544Caicedo Oscar E N32951James E Duncan 069 · S/N 042249Lattin Thomas N3889RCessna 172H · S/N 17255389Built 1966 · Adams Donald C N5013LAerostar International S-57A · S/N S57A-3205Built 1998 · Lattin Thomas K N5246RAerostar International S-57A · S/N S57A-3249Built 2006 · Lattin Thomas K N5277ZAerostar International S-57A · S/N S57A-3220Built 2000 · Lattin Thomas K N5762KBeech S35 · S/N D-7550Built 1964 · Bagwell Jason R N5888ZPiper PA-22-108 · S/N 22-9752Built 1963 · Goldberg David C N6117TInfinity Powered Parchutes 2005 · S/N IPP5292Cole William H N6344YCessna T210N · S/N 21064344Built 1981 · Cole William G N64VWRubic Baloes RUBIC BUS · S/N 106Built 2022 · Shapes Aloft LLC N65793Aerostar International RX-7 · S/N RX7-3163Built 1988 · Lattin Thomas K N692MMDiamond Aircraft Ind DA 62 · S/N 62.C013Built 2019 · Sunset Key Ventures LLC N6HGCessna T210M · S/N 21062624Built 1978 · Bagwell Harold G N7259HPiper J3C-65 · S/N 18692Bagwell Harold G N79847Mooney M20E · S/N 511Built 1964 · Woodring Jay M N822PMNorwood Thomas R RV-6A · S/N 24058Built 2019 · Norwood Thomas R N88HGAviat A-1C-200 · S/N 3011Built 2008 · Bagwell Harold G N91JCCarraway James VARI EZE · S/N 1357Built 1990 · Adams Rodney M N921VAircraft Mfg & Development CH601XL SLSA · S/N 601-052SBuilt 2008 · Cole William H N926JSEmbraer S A EMB-505 · S/N 50500078Built 2012 · N926js LLC N92TPAviat PITTS S-2B · S/N 5246Built 1992 · Pearce Michael Brett N965BSCessna 560 · S/N 560-0793Built 2008 · Rgb Enterprises LLC N99BDBeech A36 · S/N E-1147Built 1977 · Ocm Aviation LLC N9DEErtel Dick SKYBOLT 1-A · S/N 3789Built 1982 · Adams Beverly B

Back to Garner, NC