Registered aircraft · 17

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 = 'KS' AND g.registrant_city = 'MEADE' 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 = 'KS' AND g.registrant_city = 'MEADE'
  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 = 'KS' AND g.registrant_city = 'MEADE'
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.

N184BTJohnny Dean Borth VANS RV-8 · S/N 82015Built 2014 · Borth Johnny D N211MKMaynard Bryon T RV-6A · S/N 23481Built 2000 · Wk Construction LLC N4254KRyan NAVION · S/N NAV-4-1254Built 1948 · Rankin Gary L N4426SAir Tractor AT-301 · S/N 301-0086Built 1977 · Crop-Serv Inc N4442KRyan NAVION A · S/N NAV-4-1442Built 1948 · Judy Ronald W N4468WBeech V35B · S/N D-9604Built 1974 · Borth John D N4934MPiper-Flaig FLAIG PIPER · S/N 11-1567Built 1970 · Kane Logan G N502BAAir Tractor AT-502B · S/N 502B-2699Built 2010 · Crop-Serv Inc N5293RMooney M20K · S/N 25-1196Delissa Leighton A N55RSBeech 95-C55 · S/N TE-151Built 1966 · Crop-Serv Inc N74768Mooney M20B · S/N 1805Delissa Leighton A N80186Cessna 172M · S/N 17266430Built 1975 · J J Jenkinson Inc N828GRDJI AGRAS T30 · S/N 3U5BJ4J00100UGDrone Dusters Lc N834ESTalos Drones T60X · S/N 2104F7EZW255Q001NYG3Ediger Seed LLC N8915HNorth American NAVION · S/N NAV-4-915Built 1947 · Judy Ronald W N9347DDJI AGRAS T30 · S/N 3U5BJ4B0010063Drone Dusters Lc N9889DPiper PA-18-150 · S/N 18-6914Built 1959 · Borth Johnny D

Back to Meade, KS