Registered aircraft · 16

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 = 'NC' AND g.registrant_city = 'ROCKINGHAM' 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 = 'NC' AND g.registrant_city = 'ROCKINGHAM'
  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 = 'NC' AND g.registrant_city = 'ROCKINGHAM'
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.

N18718Cessna 150L · S/N 15074058Built 1972 · Layton Garner W N1969XCessna 182H · S/N 18256069Built 1965 · Crouch Jeffrey L N2021ZCessna 150C · S/N 15059821Built 1963 · Mclean Jr Rufus C N250JETextron B200GT · S/N BY-355Built 2019 · Everett Air LLC N2760UCessna 172D · S/N 17250360Anderson Justin Charles N3791UCessna 182G · S/N 18255191Built 1964 · Harway Inc N38NHHunsucker Arthur Reynolds TITAN TORNADO II · S/N D99220JS0HK0329Pressley Jeffrey W Jr N42714Cessna 182L · S/N 18259157Built 1968 · Crouch Jeffrey Lane Sr N4646LQuicksilver MXL II SPORT · S/N 000711Built 1996 · Pressley Jeff N4823HPiper PA-17 · S/N 17-121Pressley Jeffrey W N56879Ferguson FERGY F-IIB · S/N F-2B-01-008Pressley Jeffrey W N7017CInfinity IPP4 · S/N 214Locklear Delton Ray N701VCCraddock Vernon C ZENAIR STOL CH 701 · S/N 7-3173Built 2000 · Craddock Vernon C N717JCGulfstream Aerospace G-IV (G400) · S/N 1513Built 2003 · Rees Aviation LLC N89117Infinity Power Parachutes INFINITYCLASSIC · S/N IPP4-250Built 2004 · Locklear Delton Ray N9241LAmerican AA-1A · S/N AA1A-0141Built 1971 · Murray Bradley R

Back to Rockingham, NC