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 = 'TX' AND g.registrant_city = 'BORGER' 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 = 'TX' AND g.registrant_city = 'BORGER'
  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 = 'TX' AND g.registrant_city = 'BORGER'
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.

N1479RGrumman American Avn. AA-1B · S/N AA1B-0579Built 1975 · Rosebecke Jason Eugene N1626JPiper PA-28-140 · S/N 28-24013Built 1967 · Lawrence Gavin N291FRCessna T182T · S/N T18209082Con Air Aviation LLC N3068VBeech 35 · S/N D-482Burgin Lee N410TWCessna LC41-550FG · S/N 411044Built 2008 · Rice Dwight L N4143RPiper PA-32-300 · S/N 32-40462Built 1968 · Con Air Aviation LLC N475BBeech 35 · S/N D-1493Built 1948 · Vinyard Robert L Jr N4876SPiper PA-32-300 · S/N 32-7140057Built 1971 · Ledford Roland S N554JFBeech 95-B55 (T42A) · S/N TC-1286Rhoton Joel S N6423QMooney M20F · S/N 670502Built 1967 · Downs Jimmy N695DBeech C35 · S/N D-2973Burgin Lee N70802Cessna 182M · S/N 18259369Built 1968 · Brandvik Pipe & Equipment Inc N761ZECessna T210M · S/N 21062642Brandvik Pipe & Equipment Inc N7641TDJI PHANTOM 2 VISION + · S/N BG241203255180City Of Borger N7871VMooney M20C · S/N 2834Built 1964 · Edwards Eddie E N794JWJackie C Watts VANS RV-6 · S/N 20160Watts Jackie C

Back to Borger, TX