Registered aircraft · 22

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

N1223TBeech C23 · S/N M-2272Built 1980 · Beech Club LLC N1860SSheets De/Sheets Re FLIGHTSTAR II · S/N 001Sheets Douglas E N1915APiper PA-18S-125 · S/N 18-1756Built 1952 · Mercatoris Robert B N20572Beech V35B · S/N D-10247Built 1979 · Shaw Brian N2895SCessna 150G · S/N 15066795Built 1967 · Maur Karandeep N2895TPiper PA-28R-200 · S/N 28R-7235156Built 1972 · Sr Patel LLC N3073LCessna 310J · S/N 310J0073Built 1965 · Sheakley John W DBA N38091Piper J3F-65 · S/N 6776Built 1941 · Yanacek Steve J N41313Piper J3C-65 · S/N 7988Built 1941 · Hunter Tim W N46RWWest EAA BIPLANE P-2 · S/N 21430Built 1976 · Shaw Brian D N475KVCirrus Design SR20 · S/N 1155Built 2001 · Alexander John Charles N47FBTeasdale Frederic A FREDBIRD · S/N 001Built 2020 · Teasdale Frederic A N47FTFrederic A Teasdale SONERAI 2L · S/N 030309-1007Built 2012 · Teasdale Frederic A N6582DPegasus QUANTUM SS · S/N 7759Built 2001 · Hasbrouck David E N666JVCessna 172L · S/N 17260737Built 1972 · Walter Jack N N6913UMooney M20D · S/N 245Built 1964 · Shaw Brian D N7007JPiper PA-28-180 · S/N 28-3162Keltner Kody M N7074CRotorway International EXEC 162-F KIT · S/N 6746Built 2003 · Sheets Douglas E N72573Piper PA-18-135 · S/N 18-2772Built 1954 · Hunter Tim W N83055Head Balloons AX8-88 · S/N 251Miller Roger W N894ARMooney M20M · S/N 27-0034Built 1989 · Layke Tool And Manufacturing Co N9083BPiper PA-28-181 · S/N 28-8590076Built 1985 · North Coast Flight School Inc

Back to Meadville, PA