Fuquay Varina, NC
Registered aircraft · 40
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 = 'FUQUAY VARINA' 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 = 'FUQUAY VARINA' 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.
N1051ZMaule M-7-235C · S/N 25021CN110KMCessna T210N · S/N 21064800N115WMMilbauer Wayne N GS-2 SPORTSMAN · S/N 7106N1187CCessna 177B · S/N 17702683N154SCirrus Design SR20 · S/N 10517N1573SBeech 35-B33 · S/N CD-528N1607HCessna 177RG · S/N 177RG0780N212ZTextron T206H · S/N T20609228N228TTCirrus Design SR22T · S/N 9314N2569VFantasy Air Sro ALLEGRO 2007 · S/N 07-237N256CBBennett Charles P GLASTAR · S/N 5427N2667DDJI AGRAS T40 · S/N 64TBK78001008EN281YADJI AGRAS T40 · S/N 64TBK7H001010AN2880GChampion 7ECA · S/N 457N289PRChristen Industries PITTS S-2B · S/N 5173N316HJCirrus Design SR22T · S/N 2358N335WMMilbauer Wayne N BEARHAWK · S/N 112-215/216-1088N38324Piper PA-28-181 · S/N 28-7790535N415BBCirrus Design SR22 · S/N 2083N461BBeech A35 · S/N D-1631N4829NCessna 182Q · S/N 18267399N528EWBeech F33A · S/N CE-1375N545APCostruzioni Aeronautiche Tecna P2008 · S/N 149N54SSPiper PA-32RT-300 · S/N 32R-7885254N55593Piper PA-28-180 · S/N 28-7305400N5812BCessna 182 · S/N 33812N5982UPiper PA-28-140 · S/N 28-26757N60APPiskarev Andrey A JUST ACFT HIGHLANDER · S/N JA516-01-18N612PAPiper PA-28-181 · S/N 28-7790518N614GVVouga Greg M RV-7A · S/N 71607N617KMWayne N Milbauer SUPER STOL · S/N JA275-09-12N6337VCessna 172RG · S/N 172RG0633N6WFBeech 95-B55 (T42A) · S/N TC-794N711FLPiper PA-28-140 · S/N 28-7225327N7432QCessna 182P · S/N 18261072N762KGAmerican Champion 7GCAA · S/N 469-2002N8368JCessna 150G · S/N 15066268N84HMCirrus Design SR22 · S/N 10118N908EWVans RV-12 · S/N 120599N990JCBombardier BD-100-1A10 · S/N 20421
Back to Fuquay Varina, NC