Registered aircraft · 24

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 = 'WA' AND g.registrant_city = 'LAKE TAPPS' 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 = 'WA' AND g.registrant_city = 'LAKE TAPPS'
  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 = 'WA' AND g.registrant_city = 'LAKE TAPPS'
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.

N122AARobinson Helicopter R44 II · S/N 11228Built 2006 · Cnt Aviation LLC N18015Cessna 150L · S/N 15073732Built 1972 · Little Bird 150 LLC N220XPCessna T310Q · S/N T310Q01020Oleary Patrick G N222EKSchweizer SGU 2-22EK · S/N 258Built 1967 · Wave Soaring Adventures Inc N2513DCessna 170B · S/N 20665Built 1952 · Petite Randall L N2731ZSchweizer SGS 1-26B · S/N 251Built 1964 · Wave Soaring Adventures Inc N2753LCessna 172H · S/N 17255953Mccartney Matthew T N2756WMooney M20E · S/N 1048Built 1966 · Johnson Stephen C N2857RCessna 182K · S/N 18258457Built 1967 · Wilson Gary C N3068JCessna 150E · S/N 15061168Built 1965 · Wave Soaring Adventures Inc N33010Piper J3C-85 · S/N 5769Built 1940 · Thomson Kathryn Personal Representative N347TBeech P35 · S/N D-7058Built 1962 · Mccartney Matthew T N501JBBowen James Austin JR RV-8 · S/N 81786Nelson Jill N5298BAerostar International S-57A · S/N S57A-3231Dill Cooper M N6087PPiper PA-24-250 · S/N 24-1186Built 1959 · Brandner Paul D N7127NBeech D55 · S/N TE-516Built 1968 · Graber Loren N727TBeech 95-B55 (T42A) · S/N TC-753Built 1964 · Beechair LLC N7692BBellanca 14-19-2 · S/N 4043Built 1957 · Snodgrass Randall W N81275Fairchild 24W-46 · S/N W46175Built 1946 · Thomson Kevin N825LLBloomquist Jeffrey L RV-7A · S/N 72923Built 2011 · Bloomquist Jeffrey L N85311Aeronca 7BCM · S/N 7AC4050Built 1946 · Mccartney James P N92128Piper J3C-65 · S/N 16569Built 1946 · Wester Zachary N923KMMiller Keith W RV-6A · S/N 20008Built 1993 · Williams Zackery N982SFCessna P206E · S/N P20600644Built 1970 · Bauermeister Matthew

Back to Lake Tapps, WA