Skip to content

Registered aircraft · 21

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('0540104')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('0540104')
ORDER BY 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.

N246EZZisman Edward D · Tarpon Springs, FLBuilt 1968 · S/N B-288 N281DBMac Mic Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N B-281 N5452FRients Randall T · Virginia Beach, VABuilt 1967 · S/N B-252 N5455FHoye Charlie L · Rimrock, AZBuilt 1967 · S/N B-255 N5457FWehrly Phoenix O · Elbow Lake, MNBuilt 1967 · S/N B-257 N5458FMorgan Scott E · Allen, NEBuilt 1967 · S/N B-258 N5459FDavis James A · Astoria, ORBuilt 1967 · S/N B-259 N5464FTiger Flight Foundation Inc · Rome, GABuilt 1967 · S/N B-264 N5473F8s1-51 LLC · Polson, MTBuilt 1968 · S/N B-273 N5474FRaymond Patrick H · Jerseyville, ILBuilt 1968 · S/N B-274 N5475FWinger Christopher W · Maplewood, MNBuilt 1968 · S/N B-275 N5476FHeacock Anthony A · Chino Hills, CABuilt 1968 · S/N B-276 N5478FTompkins Robert George · Frankfurt Am MainBuilt 1968 · S/N B-278 N5482FDahlberg David F · Basking Ridge, NJBuilt 1968 · S/N B-282 N5483FGray Melvin D Trustee · Appleton, WIBuilt 1968 · S/N B-283 N5485FGarretson Frederick M · Gardners, PABuilt 1968 · S/N B-285 N5486FSchmitt Kenneth R · Springfield, ORBuilt 1968 · S/N B-286 N5489FBraden John H · Watseka, ILBuilt 1968 · S/N B-289 N5650FMcdonald Ryan · Sugarland, TXBuilt 1967 · S/N B-250 N5675FSpurlock Bill C · Elk City, OKBuilt 1966 · S/N A-175 N818SWAbbott Don W · Sanibel, FLBuilt 1968 · S/N B-279

Back to Alon A-2A