Woodbridge, VA
Registered aircraft · 33
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 = 'WOODBRIDGE' 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 = 'WOODBRIDGE' 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.
N119JTSchilder Jon SONERAI II LS · S/N 0215980226N18483Beech F33A · S/N CE-735N200ZAZenair CH 2000 · S/N 20-0003N222HCBeech A36TC · S/N EA-259N2324FCessna 210E · S/N 21058524N3054KPiper PA-34-200T · S/N 34-7970102N3065RPiper PA-28R-200 · S/N 28R-35626N325TSColumbia Aircraft Mfg LC41-550FG · S/N 41589N33848Piper PA-28-180 · S/N 28-7505187N345TLGuay Marc VAN'S RV 6A · S/N 21655N419SKFlaglor Kenneth E SONEX · S/N 972N429SDDavid M Fenstermacher RV-8 · S/N 82219N43892Taylorcraft BC12-D · S/N 7551N47567Cessna 152 · S/N 15283236N499RACessna LC41-550FG · S/N 411042N511PRPfaff Joseph G RV-7 · S/N 72252N5611HGilley Jeffrey QUICKSILVER SPORT II · S/N 001JGN58294Piper PA-18-150 · S/N 18-7909055N658JJabiru USA Sport J230-SP · S/N 562N66615Cessna 150M · S/N 15076157N72567Beech A36 · S/N E-2280N7274QCessna 182S · S/N 18280533N734TDCessna 172N · S/N 17269093N7445YPiper PA-30 · S/N 30-509N7911RBeech D55 · S/N TE-622N80762Globe GC-1B · S/N 165N812CSCirrus Design SR22 · S/N 3931N8410WPiper PA-28-180 · S/N 28-2629N8460YPiper PA-28-181 · S/N 28-8290057N847DDBeech A36 · S/N E-2498N8513CPiper PA-32R-300 · S/N 32R-7680121N9465JPiper PA-28-180 · S/N 28-3579N99WVCentrair 101A · S/N 101A0126
Back to Woodbridge, VA