Skip to content

Registered aircraft · 394

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 = 'DC' AND g.registrant_city = 'WASHINGTON' 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 = 'DC' AND g.registrant_city = 'WASHINGTON'
  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 = 'DC' AND g.registrant_city = 'WASHINGTON'
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.

N1007GAirbus Helicopters AS350B3 · S/N 9164Built 2022 · Department Of Homeland Security N108CTCessna 206H · S/N 20608212Built 2004 · Department Of Homeland Security N108FHawker Beechcraft B300C · S/N FM-53Built 2012 · Dept Of Homeland Security N10LWAero Vodochody L-39 · S/N 232224Built 1982 · Girardi Mike R N1132FCessna 208B · S/N 208B0741Built 1999 · US Government N11476Cessna 177B · S/N 17702340Built 1975 · Shannon Kenneth H N11561Cessna 150L · S/N 15075522Marsh John E N115HTextron B300C · S/N FM-66Built 2016 · Department Of Homeland Security N116NTextron B300C · S/N FM-102Built 2021 · Department Of Homeland Security N119NABoeing 757-223 · S/N 24487Built 1989 · United States Government N12011Maule M-4 · S/N 21Marsh John Edward N128JTextron B300C · S/N FM-90Built 2020 · Department Of Homeland Security N13006Sikorsky UH-60A · S/N 78-23010Department Of Homeland Security N1319UCessna 172M · S/N 17267008Marsh John E N131GBucker Jungmann C.A.S.A. 1.131 · S/N E3B-391Built 1959 · Dunkerley Mark B N140PDCessna 140A · S/N 15414Built 1950 · Coulouris George L N141USAviat A-1C-200 · S/N 3059Dunkerley Mark N143NTextron B300C · S/N FM-103Built 2021 · Department Of Homeland Security N1451XPiper PA-34-200T · S/N 34-7570248Built 1975 · Trb Aviation Inc N151QBeechcraft B300C · S/N FM-59Built 2015 · Department Of Homeland Security N152VPGippsaero PTY GA8 · S/N GA8-11-160Built 2011 · Conservation Aviation LLC N154MUMueller MUELLER -54 · S/N 2008-54Built 2008 · Mueller James J N1565JPiper PA-28-140 · S/N 28-23969Built 1967 · Hermann Michael S N157KSchempp-Hirth DISCUS 2A · S/N 15Built 1998 · Shelton Steven D N161VHawker Beechcraft B300C · S/N FM-52Built 2011 · Department Of Homeland Security N161VPCessna U206F · S/N U20601719Built 1971 · Conservation Aviation LLC N162GTextron B300C · S/N FM-72Built 2017 · Department Of Homeland Security N162VPCessna TU206G · S/N U20606215Virunga Airwing LLC N164VPCessna U206F · S/N U20601942Conservation Aviation LLC N167CTextron B300C · S/N FM-86Built 2020 · Department Of Homeland Security N172AEEurocopter AS 350 B3 · S/N 3839Built 2004 · US Department Of Homeland Security N173BTextron B300C · S/N FM-84Built 2019 · Dept Of Homeland Security N1770KLuscombe 8E · S/N 4497Built 1946 · Flip Turn LLC N180QAirbus Helicopters AS350B3 · S/N 8815Built 2020 · Department Of Homeland Security N1812Pitts Special SC-1 · S/N RG-1Marsh John E N1822SBeech 95-B55 (T42A) · S/N TC-2357Built 1981 · Snider Nancy J N18344Beech E-55 · S/N TE-1123Built 1978 · Ab Aviation Sales & Rental LLC N183AEEurocopter AS 350 B3 · S/N 3852U S Dept Of Homeland Security N184RAirbus Helicopters AS350B3 · S/N 9158Built 2022 · Department Of Homeland Security N185NUCessna A185E · S/N 18502003Built 1972 · Snider Nancy J N186AEEurocopter AS 350 B3 · S/N 3872Built 2004 · US Department Of Homeland Security N187AEEurocopter AS 350 B3 · S/N 3846Built 2004 · US Department Of Homeland Security N187VHawker Beechcraft B300 · S/N FL-679Built 2009 · Department Of Homeland Security N192AAmerican Eurocopter AS350B3 · S/N 7184Built 2011 · Department Of Homeland Security N192FHawker Beechcraft B300 · S/N FL-770Built 2012 · Department Of Homeland Security N1964LAirbus Helicopters AS350B3 · S/N 9179Built 2022 · Department Of Homeland Security N196BTextron B300C · S/N FM-79Built 2019 · Department Of Homeland Security N196GXMooney M20R · S/N 29-0414Built 2006 · Rhodes David N19773Cessna 172L · S/N 17260740Built 1972 · Burtch Timothy J N1977GAirbus Helicopters AS350B3 · S/N 9192Built 2022 · Department Of Homeland Security

Back to Washington, DC