Warrenton, VA
Registered aircraft · 63
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 = 'VA' AND g.registrant_city = 'WARRENTON' 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 = 'VA' AND g.registrant_city = 'WARRENTON' 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.
N10076Cessna 150L · S/N 15074772N1050RMaule MXT-7-180A · S/N 21044CN11506Cessna 177B · S/N 17702343N12BDBeech A45 · S/N G-116N12GWWishon George F JR RANS S-9 · S/N 0589073N131CMMosier Colby RV8A · S/N 81037N134RDBeech T-34B · S/N BG-11N15796Canadian Car & Foundry HARVARD MK IV · S/N CCF4-16N17575Kane Thomas G PULSAR XP · S/N 418N179VBCessna T182T · S/N T18209079N1903RWright Experience WRIGHT KITTY HWK FLR · S/N WE 2N1903UWright Experience WRIGHT KITTY HWK FLR · S/N WE 3N1909WWright Experience 1909 WRIGHT MILITARY · S/N WE-SC1N1911EBurgess-Wright BURGESS-WRIGHT 1911 · S/N F-19N1911KVirginia Avia & Machine WRIGHT MODEL B · S/N VA3N193JKKing John E JR KITFOX IV 1200 · S/N 1888N2080QCessna T182T · S/N T18208450N226GRGrumman HU 16E · S/N 2132N2360BTemco GC-1B · S/N 3660N2515TNavion NAVION H · S/N NAV-4-2515N25TYHoliday G Kent RV-4 SOLUTION · S/N 7001N262WFWigney John R EUROPA XS · S/N 001Sale reportedN26NGPilatus PC-12/47E · S/N 1426N300CPPiper PA-32R-301 · S/N 32R-8413014N314TSShipley Walter R VANS RV8-A · S/N 80877N33554Piper J3C-65 · S/N 14028N346EXDassault MYSTERE-FALCON 50 · S/N 346N3737GAmerican Legend AL3C-100 · S/N AL-1018N3766VCessna 150M · S/N 15076612N3953BBoeing E75 · S/N 75-5568N396DSSteeves David RV-6 · S/N 20980N41052Piper J5A · S/N 5-1243N4236Curtiss JN4D · S/N 33779N43459Taylorcraft BC12-D · S/N 7118First renewal noticeN46592Boeing A75N1(PT17) · S/N 75-2759N46KLBethard Kenneth L RV6 · S/N 60449N48PRPiper PA-28-181 · S/N 2843533N510MPiel Emeraude CP-305 · S/N 1171N523DACirrus Design SR20 · S/N 9999N5277KNavion NAVION B · S/N 2177BN5365SCessna 337A · S/N 337-0465N548TBCovey Thomas A SONEX · S/N 0387N5576ECessna 150 · S/N 17076N601ZASteele Ronald J ZENITH 601XLB · S/N 001N60407Cessna 150J · S/N 15070286N606TBeech A36 · S/N E-1155N61VFAeropro CZ S R O A240 · S/N 722 25N681MBCirrus Design SR22 · S/N 3664N68SDPiper PA-32-300 · S/N 32-7940126N7009TCessna 172 · S/N 46609
Back to Warrenton, VA