Registered aircraft · 23

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 = 'FORT SCOTT' 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 = 'FORT SCOTT'
  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 = 'FORT SCOTT'
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.

N1071GLiming Gary CH 801 · S/N 8-4396Registration pending N111DQKellenberger Ricky Don GLASAIR I TAILDRGGER · S/N 652Built 1995 · Medical Surgical Clinic West Bend Pc N1486YCessna 172C · S/N 17249186Built 1962 · Post Greg N164DHHarris Dwain VANS RV-6 · S/N 22370Built 1997 · Self Maxwell N2362XCessna 182H · S/N 18256262Built 1965 · Fort Scott Family Medicine Pa N250HCPiper PA-32R-300 · S/N 32R-7880037Built 1977 · Cornerstone Air Holdings LLC N26533Cessna 421C · S/N 421C0686Built 1979 · Txoperation LLC N30875Piper J3F-65 · S/N 5168Built 1940 · Emmerson James E N3228PPiper PA-24-250 · S/N 24-294Built 1958 · Popejoy Marc N345TETimothy H Emerson STOL CH750 · S/N 75-8068Emerson Timothy H N35401Cessna 172I · S/N 17256748Built 1968 · American Aviation Training LLC N36434Bellanca 7GCAA · S/N 275-73Built 1973 · Phillips Aaron W N421DGCessna 421C · S/N 421C0456Built 1978 · Txoperation LLC N4957DCessna 182A · S/N 51057Built 1958 · Cummings Roy E N51629Maule M-5-220C · S/N 5017CPhillips Aaron W N62979Bellanca 8KCAB · S/N 36-72Built 1972 · Cummings Roy E N6695DBeech A36 · S/N E-1657Built 1980 · Extrusions Inc N7576WPiper PA-28-180 · S/N 28-1448Built 1963 · Davenport Larry L N7655XCessna 172B · S/N 17248155Built 1960 · Medical Surgical Clinic LLC N83869Emmerson PIETENPOL AIRCAMPER · S/N 4Built 1977 · Emmerson Fred G N90159Ikrus L · S/N 50-133Perry Richard H N95084Piper PA-28-140 · S/N 28-25801Built 1969 · Lyons Nathaniel R N992AWDJI AGRAS T40 · S/N 64TBKBL002004SMuddy Water Farms LLC

Back to Fort Scott, KS