Registered aircraft · 28

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 = 'MO' AND g.registrant_city = 'BATES CITY' 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 = 'MO' AND g.registrant_city = 'BATES CITY'
  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 = 'MO' AND g.registrant_city = 'BATES CITY'
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.

N116PGRobinson Helicopter R22 BETA · S/N 3547Built 2004 · Unusual Attitudes LLC N1209EAeronca 7AC · S/N 7AC-4766Built 1946 · Karaty Joseph N1327Luscombe 8A · S/N 801Anderson Mark A N1356KLuscombe 8A · S/N 4083Anderson Andrew A N1451KLuscombe 8A · S/N 4178Anderson Mark A N1521BLuscombe 8E · S/N 6148Anderson Andrew A N1639BLuscombe 11A · S/N 11-145Anderson Mark A N17741Waco ZKS-7 · S/N 4667Built 1937 · Anderson Andrew A N1960AAnderson Mark PIETENPOL SCOUT · S/N 3ABuilt 2005 · Anderson Mark A N1968KLuscombe 8E · S/N 4695Anderson Mark A N2015BLuscombe 8A · S/N 6442Built 1954 · Anderson Mark A N2212BLuscombe 8F · S/N 6639Anderson Mark A N236JPBeech A36 · S/N E-211Built 1970 · Lauderdale Thomas J N31485Robinson Helicopter R22 BETA · S/N 4088Built 2006 · Unusual Attitudes LLC N39034Luscombe 8A · S/N 1795Anderson Mark A N503RJPowrachute AIRWOLF 912 · S/N A108ULSBuilt 2009 · Thomas Jack E N5143PPiper PA-24-250 · S/N 24-159Built 1958 · Unusual Attitudes LLC N599Mckinney John P PIETENPOL AIRCAMPER · S/N 1989-1Built 1989 · Anderson Mark A N688PDCirrus Design SR22 · S/N 2398Built 2007 · Unusual Attitudes LLC N71586Luscombe 8A · S/N 3013Built 1946 · Anderson Mark A N71983Silvaire LUSCOMBE 8A · S/N 3410Sale reported N7463JPiper PA-28R-180 · S/N 28R-30815Unusual Attitudes LLC N81704Aeronca 7AC · S/N 7AC-323Built 1945 · Anderson Mark A N8313YPiper PA-30 · S/N 30-1452Built 1967 · Unusual Attitudes LLC N85NRBrunner-Winkle BIRD A · S/N 1040Anderson Mark A N88CYHuey-Smith MINIPLANE · S/N H1Anderson Mark N94981Cessna T240 · S/N T24002042Built 2014 · Schatz Aviation LLC N9932CLuscombe 8F · S/N S-36Anderson Andrew A

Back to Bates City, MO