Registered aircraft · 17

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 = 'AL' AND g.registrant_city = 'TRUSSVILLE' 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 = 'AL' AND g.registrant_city = 'TRUSSVILLE'
  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 = 'AL' AND g.registrant_city = 'TRUSSVILLE'
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.

N11AWLinn Robert LANCAIR IV-PROPJET · S/N LIV-537Built 2004 · Roseland LLC N14UACessna 414 · S/N 414-0605Milam Equipment LLC N190N190 AL-18 · S/N AL-408Built 2026 · N190 LLC N1PNHanson James B VANS RV-7 · S/N 72349Hastings David B N236MSSylvester Michael L KR2S · S/N 1276Built 2016 · Sylvester Michael L N23AGBeech V35B · S/N D-9834Built 1975 · Parker Robert B N278GJUnander Gary D VELOCITY 173 RG · S/N DMO 275Unander Gary D N3184BCessna 170B · S/N 25426Built 1952 · Cerisano Kevin N4051ACessna 195 · S/N 7318Built 1949 · Vintage Sky LLC N50531Cessna 150J · S/N 15069377Built 1968 · Davies Patrick R N50967Cessna 172M · S/N 17264221Sellers Raymond L N5221SPiper PA-32-300 · S/N 32-409153a LLC N5784FPiper PA-28-140 · S/N 28-25090Built 1968 · Crocker James Fuller N6173BNorthwing NAVAJO · S/N 001Built 2005 · Long Johnny P N6776DBell 47G-2 · S/N 2439Built 1959 · Milam Inc N93067Bell 47D1 · S/N 5501Built 1965 · Milam Inc N9JKSchweizer SGS 1-35 · S/N 18Built 1975 · Stewart James D

Back to Trussville, AL