Falls Church, VA
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 = 'VA' AND g.registrant_city = 'FALLS CHURCH' 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 = 'FALLS CHURCH' 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.
N144MECessna 172S · S/N 172S8428N153MKPiper PA-32-301 · S/N 32-8406009N155EAmerican General Acft AG5B · S/N 10155N1613WAmerican AA-5 · S/N AA5-0073N16286Aeronca C-3 · S/N A-662N1935TPiper PA-28-180 · S/N 287105153N2016KBeech 95-B55 (T42A) · S/N TC-2163N22373Cessna 182T · S/N 18281928N236DCCirrus Design SR22 · S/N 3836N26770Gulfstream American AA-5A · S/N AA5A0705N2942LMooney M20C · S/N 670076N30892Cessna 177B · S/N 17701529N3549WPiper J3C-65 · S/N 6398Registration pendingN370JSRolladen-Schneider LS-4 · S/N 4370N440NCurtiss Wright TRAVEL AIR E-4000 · S/N 1345N451HMBombardier BD-100-1A10 · S/N 20444N4837Waco GXE · S/N 1996N490ELElectra.Aero.Inc SACOS DEMONSTRATOR 1 · S/N 1N5168MHerlihy Michael F RANS S-12 · S/N 0692241N613KGene Rambo TRAVEL AIR MYSTERY S · S/N R-2002N62818Piper PA-23-250 · S/N 27-7754051N65503Beech C23 · S/N M2378N6624HCessna 172M · S/N 17265515N675BWBeech V35B · S/N D-10134N697KTravel Air 4-D · S/N 1320N7010FPiper PA-32R-300 · S/N 32R-7780051N703RMHawker Beechcraft B200GT · S/N BY-74N70497Piper J3C-65 · S/N 17500N7131LGrumman American Avn. AA-5 · S/N AA5-0631N7241TCessna 172A · S/N 46841N738ASCessna TR182 · S/N R18200904N766EWaco ASO · S/N A-120N77MDBeech A36 · S/N E-234N8085ECessna 172N · S/N 17272137N82SACirrus Design SR22 · S/N 0902N8471Stinson SM-2AA · S/N 1069N8811XCessna 182D · S/N 18253211N8853Travel Air Mfg 2000 · S/N 928N970DSDiamond Aircraft Ind DA 40 · S/N 40.928N984PGCirrus Design SR20 · S/N 1959
Back to Falls Church, VA