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 = 'SC' AND g.registrant_city = 'NORTH AUGUSTA' 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 = 'SC' AND g.registrant_city = 'NORTH AUGUSTA'
  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 = 'SC' AND g.registrant_city = 'NORTH AUGUSTA'
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.

N16HPAir Creation GTE 582S · S/N 91440Built 1996 · Prescott Paul H N2170RPiper PA-28-180 · S/N 28-5753Built 1970 · Kotz Dennis M N227HPHarden Gary RV9A · S/N 90760Built 2008 · Britt Joseph A N2573DBlaser Robert H RANS S-12XL · S/N 03000911Coenen Lance G N41HBAmerican AA-1 · S/N AA1-0277Built 1969 · Walsh Bowen S N5259CMooney M20J · S/N 24-3094Mcsorley John A N5530JPiper PA-32-260 · S/N 32-992Built 1967 · Sellers Justin Kennedy N6435RPiper PA-28-140 · S/N 28-21616Built 1966 · Spears Travis L N7186XCessna 150A · S/N 15059286Smith Calvin E N7215SCessna 150H · S/N 15067915Built 1967 · Hitt Bruce A N7351HPiper J3C-65 · S/N 20610Built 1946 · Walsh Bowen S N742CAColumbia Aircraft Mfg LC42-550FG · S/N 42544Built 2007 · Eagle Talon Inc N79191Cessna 172K · S/N 17257947Built 1969 · Kirkland Patrick C Sr N821TDiamond Aircraft Ind DA 40 · S/N 40.1154Built 2012 · Colquhoun Steven N87034Ercoupe 415-C · S/N 207Built 1945 · Prescott Paul H N973LCostruzioni Aeronautiche Tecna P2004 BRAVO · S/N 118Built 2007 · Prescott Paul H N98377Piper PA-28-140 · S/N 28-26198Built 1969 · Sloan Allen Lee

Back to North Augusta, SC