Registered aircraft · 18

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 = 'WY' AND g.registrant_city = 'NEWCASTLE' 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 = 'WY' AND g.registrant_city = 'NEWCASTLE'
  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 = 'WY' AND g.registrant_city = 'NEWCASTLE'
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.

N264XSmith Chris GLASAIR II SRG · S/N 2114Built 2002 · Wignall Fred J N2856ZPiper PA-22-150 · S/N 22-6853Built 1959 · Cooksey Donald R N3716VCessna 150M · S/N 15076598Built 1975 · Borton Garrett J N37991Piper J4E · S/N 4-1485Built 1941 · Bayne Clyde O N38181Piper J4E · S/N 4-1545Bayne Clyde O N3933ZPiper PA-18-150 · S/N 18-7757Built 1962 · Ryan Alan Parks N405BCRainbow Skyreach BUSHCAT · S/N CH249CBuilt 2021 · Harley Daniel G N5280ECessna 172N · S/N 17271810Built 1978 · Streeter Byrand DBA N58773Cessna 182P · S/N 18262286Built 1973 · Ranchers Skylane LLC N6357PPiper PA-24-180 · S/N 24-1467Built 1959 · Borton Garrett J N6883BPiper PA-18A 150 · S/N 18-5070Built 1956 · Slagle Allen E N7045WPiper PA-28-180 · S/N 28-800Built 1962 · Cooksey Don R N8070KUniversal Stinson 108-2 · S/N 108-3070Parks Alan D N8495JCessna 150G · S/N 15066395Built 1967 · Parks Ryan Alan N8735ABeech A35 · S/N D-2157Built 1949 · Rhoades Randal W N8947KStinson 108-1 · S/N 108-1947Parks Alan D N9077XCessna 182D · S/N 18253477Built 1961 · Tmax Aviation LLC N97770Stinson 108 · S/N 108-770Built 1946 · Parks Alan D

Back to Newcastle, WY