Registered aircraft · 19

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 = 'PA' AND g.registrant_city = 'BERNVILLE' 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 = 'PA' AND g.registrant_city = 'BERNVILLE'
  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 = 'PA' AND g.registrant_city = 'BERNVILLE'
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.

N1146XSchempp-Hirth SHK1 · S/N 20Built 1966 · Kramer Dean E N17483Aeronca K · S/N K3Built 1937 · Kramer Dean E N195CLMccormick David C KITFOX CLASSIC IV · S/N C97060195Built 2001 · Hunter Charles P N20701Rearwin 9000-L · S/N 601DBuilt 1938 · Kramer Nathan A N2117MPiper J3C-65 · S/N 20900Built 1946 · Kramer Dean E N2152Scheibe L SPATZ-55 · S/N 01/745Built 1961 · Kramer Dean E N2411WSchweizer SGU 2-22E · S/N 249Built 1966 · Kramer Dean E N24185Frankfort GLIDER B · S/N B-1-4Built 1942 · Kramer Dean E N335RYDJI AGRAS T40 · S/N 1581F574B238500100AHYounker Steve B N377CZPiper PA-18-150 · S/N 18-7448Built 1960 · Kramer Dean E N37HHSchweizer SGU-1-20 · S/N 37Built 1946 · Kramer Nathan A N5747SSchweizer SGS 1-26C · S/N 384Built 1968 · Kramer Dean E N5895ZPiper PA-22-108 · S/N 22-9761Built 1963 · Merrick Richard W N655WAeronca C-2 STANDARD · S/N 301-35Built 1930 · Kramer Dean E N8645RSchweizer SGU 2-22C · S/N 147Built 1962 · Kramer Dean E N91883Schweizer SGU-1-19 · S/N 44Built 1946 · Kramer Dean E N918LMAlexander Schleicher ASW 27-18 · S/N 29026Built 2007 · Mcdonald Louis N III N964RSSnyder Ronald L BEARHAWK PATROL · S/N P318Built 2020 · Snyder Ronald L N98RFCirrus Design SR22 · S/N 0520Built 2003 · Dabosa LLC

Back to Bernville, PA