Skip to content

Registered aircraft · 36

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

N11PXMuehlberg Stephen E PANTHER LS · S/N 011Built 2018 · Muehlberg Stephen E N1273TPiper PA-28-140 · S/N 28-7225415Built 1972 · Zulu Aviation LLC N1611Erco 415-C · S/N 1537Built 1946 · Hibler Kenith R N1EMMuehlberg Stephen E AVENGER · S/N A0065Built 2008 · Muehlberg Stephen E N2053VCessna 140 · S/N 14266Built 1947 · Shores Toby L N2135ZCessna 180F · S/N 18051235Built 1963 · Capps Boyce Daniel N230WMZenith ZODIAC 601XL · S/N 6-6477Built 2007 · Muehlberg Stephen E N250WBProgressive Aerodyne SEAREY LSA · S/N 1006Built 2014 · Brown Jeffrey N2959GStadler STITS PLAYBOY SA3A · S/N P-623Built 1967 · Hubbert Stephen A N304RTCGS CLASSIC · S/N 892Built 2007 · Hartpence Darian K N3281FMooney M20F · S/N 670374Capps Daniel Boyce N333RJBeech V35B · S/N D10188Built 1978 · Addco Aviation Services Inc N36676Hall TAYLOR MONOPLANE JT- · S/N 1LHBuilt 1974 · Hall Larry D N3854MPiper PA-12 · S/N 12-2767Built 1947 · Mischel Scott N404ZMuehlberg Stephen E ZENITH STOL CH 750 · S/N 75-10404Built 2025 · Muehlberg Stephen E N4052BBellanca 17-30A · S/N 76-30813Built 1976 · Hatter Ronnie N4065SBeech E-55 · S/N TE-1025Built 1975 · Alpha 3 LLC N4102UCessna 150D · S/N 15060102Hartpence Damian K N4262NCessna 120 · S/N 13733Built 1947 · Capps Steve N4427LCessna 172G · S/N 17254516Built 1966 · Hatter Ronnie A N4715ZPiper PA-22-108 · S/N 22-8259Built 1961 · Muehlberg Stephen E N5684ZPiper PA-22-108 · S/N 22-9514Built 1962 · Muehlberg Stephen E N5844PPiper PA-24-250 · S/N 24-925Koniar Steven L N6221XPiper PA-28-140 · S/N 28-24307Alpha 3 LLC N626EStephen E Muehlberg ZENITH CH 750 CRUZER · S/N C75-11626Muehlberg Stephen E N6468PPiper PA-24-250 · S/N 24-1583Tevis Aviation Enterprises LLC N650SLRichard G Stevens ZODIAC CH 650B · S/N 65-7794Muehlberg Stephen E N71201Luscombe 8A · S/N 2628Built 1946 · Hatter Ronnie A N7408KPiper PA-20 · S/N 20-317Built 1950 · Capps Steven N80LCCopland George V THORP S-18 · S/N 38Built 1993 · Hubbert Stephen A N8249WPiper PA-28-180 · S/N 28-2397Built 1965 · Hartpence Damian K N87SDDavis STARDUSTER SA100 · S/N 1Built 1977 · Hubbert Stephen A N95LCessna 140A · S/N 15383Hubbert Stephen A N96674Taylorcraft BC12-D · S/N 8974Built 1946 · Capps Steven N991HCButtles Timothy L HUSKY-CHASER · S/N HC1Rohr Bryan N99530Ercoupe 415-C · S/N 2153Built 1946 · Hibler Kenith R

Back to Newcastle, OK