Registered aircraft · 21

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 = 'IN' AND g.registrant_city = 'SALEM' 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 = 'IN' AND g.registrant_city = 'SALEM'
  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 = 'IN' AND g.registrant_city = 'SALEM'
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.

N10MUAvions Mudry ET Cie CAP 10B · S/N 201Morgan Daniel R N11657Bellanca 7GCBC · S/N 347-72Built 1972 · Morgan Jacob R N1257PTextron 182T · S/N 18283193Built 2022 · 812 Aviation LLC N1468NPiper J-3 · S/N 23001Built 1947 · Depoy Lowell K N17670Piper/Michmerhuizen P J E-2 · S/N 1335Depoy Lowell N1778YPiper PA-28-140 · S/N 28-22261Built 1966 · Wade Jason E N24992Piper J3F-50 · S/N 3590Built 1939 · Depoy Lowell N3457KPiper J3C-65 · S/N 22147Built 1946 · Neff Michael K N34809Cessna 177B · S/N 17702017Built 1973 · Grassmyer Richard M N3535APiper PA-22-135 · S/N 22-1807Built 1953 · Depoy Lowell K N3946SCessna 172E · S/N 17251146Built 1964 · Depoy Lowell K N5136PPiper PA-24 · S/N 24-150Built 1958 · Dunn James F N552ZMDJI AGRAS T20 · S/N 35PBIBS0010X5KOpen Fly Aeronautics LLC N553ZMDJI AGRAS T20 · S/N 35PBIBR0010X55Open Fly Aeronautics LLC N554ZMDJI AGRAS T20 · S/N 35PBIBR0010X54Open Fly Aeronautics LLC N6133LAmerican AA-1 · S/N AA1-0333Built 1970 · Barnett George W N745MSBellanca 8KCAB · S/N 126-74Schamel Michael A N7MMorgan Jeffrey G MD DENNEY KITFOX · S/N 173Built 1989 · Morgan Jeffery G N87426Engineering & Research ERCOUPE 415-C · S/N 599Safety-Net LLC N88242Piper J3C-65 · S/N 15859Built 1946 · Depoy Lowell N8880KStinson 108-1 · S/N 108-1880Built 1947 · Metz Arnold L

Back to Salem, IN