Registered aircraft · 16

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 = 'WI' AND g.registrant_city = 'BIRCHWOOD' 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 = 'WI' AND g.registrant_city = 'BIRCHWOOD'
  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 = 'WI' AND g.registrant_city = 'BIRCHWOOD'
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.

N216DCCessna 182S · S/N 18280898Built 2000 · Dornink Steven R N3267HEngineering & Research ERCOUPE 415-C · S/N 3892Built 1946 · Zemaitis Richard A N35431Piper J3C-85 · S/N 6337Built 1941 · Jankowski Philip J N38464Piper J3C-65 · S/N 7036Built 1941 · Ovans Ronald J N3HCChristianson JODEL F 12 3 · S/N F8031Built 1979 · Ovans Ronald J N4704JBradley J Jilek CHALLENGER II · S/N CH2-1005-2688Built 2006 · Jilek Bradley J N47322Taylorcraft DCO-65 · S/N 4264Built 1942 · Bergstrom Donald E N5191MTaylorcraft BC12-D1 · S/N 10491Built 1954 · Kittinger Russell P N6770ACessna 172 · S/N 28870Built 1956 · Hele David A N6897Cessna 305A · S/N 22728Built 1955 · Bergstrom Donald E N7081BSchrock Ronald R RV4 · S/N 2858Built 1993 · Ovans Ronald J N7370Billie D Carter STOL CH 750 · S/N DB-003Built 2012 · Kittinger Russell P N8088SCessna 150F · S/N 15061688Built 1965 · Rutherford Thom J N813RPRyan R Peters JUST ACFT HIGHLANDER · S/N JA311-08-13First renewal noticePeters Ryan R N98LHHefel Lyle L RV-8 · S/N 82054Built 2007 · Ovans Ronald J N998KTTrontvet Kent A RANS S-12 AIRAILE · S/N 0493402Built 1994 · Dakins Bruce

Back to Birchwood, WI