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 = 'CA' 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 = 'CA' 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 = 'CA' 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.

N1559RGrumman American Avn. AA-5B · S/N AA5B-0059Built 1975 · Moore Kira G N16222Cessna 150L · S/N 15073554Built 1972 · Thumser Douglas Francis N29MKKoblis Martin H BABY ACE D · S/N 1Built 1986 · Nelson Gregory J N3187CCessna 180 · S/N 30986Built 1954 · Hemm Colby L N3961TPiper PA-28R-180 · S/N 28R-30306Built 1967 · Martin Noah R N44WTTimmons W S/Timmons N A VANS RV 6A · S/N 23178Built 2002 · Moore Arlon A N52156Cessna 177RG · S/N 177RG1180Built 1977 · Rbl Missions LLC N5463DBeech H35 · S/N D-4959Built 1957 · Blanco Austin N5926DPiper PA-22-150 · S/N 22-4589Built 1956 · Toste Greg N7380WPiper PA-28-180 · S/N 28-1263Built 1963 · Rohlfes David M N7398LCessna A152 · S/N A1520815Built 1978 · Nelson Gregory J N7684FPiper PA-28-151 · S/N 28-7715238Lettunich Mitchell C N7954GCessna 172L · S/N 17259654Built 1970 · No Squawks LLC N8134QCessna 414 · S/N 414-0034Built 1969 · Paul Morrill Excavating Inc N8392DBeech J35 · S/N D-5519Built 1958 · Thumser Douglas F N8450SPiper PA-28-181 · S/N 28-8290043Built 1981 · Kyle Steven L N95DRRoss Dan G RV8A · S/N 82434Built 2010 · Ross Dan G N96BWJones R C/Spratford W KITFOX III · S/N 1209Built 1996 · Hunter Kinerly E N

Back to Newcastle, CA