Registered aircraft · 19

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 = 'RED OAK' 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 = 'RED OAK'
  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 = 'RED OAK'
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.

N10956Cessna 150L · S/N 15075166Built 1973 · Flying Toad LLC N111RVBeech 95-C55 · S/N TE-292Built 1966 · Rawson Keith L N13EFCessna 337C · S/N 337-0794Built 1967 · Mcgough Julie Eileen N1833ZCessna 210-5(205) · S/N 205-0033Built 1962 · Eastwood Gregory S N2214BLuscombe T-8F · S/N 6641Built 1949 · Wilhite John R N24161Beech V35B · S/N D-10103Built 1978 · Diamond Scenery LLC N2417QCessna 182J · S/N 18257617Mcgough Julie Eileen N2957QCessna 421A · S/N 421A0057Built 1969 · Generals International Inc N33661Piper PA-28-180 · S/N 28-7505163Built 1975 · Baker Justin Robert N3564ECessna 172N · S/N 17271590Built 1978 · Generals International Inc N46001Cessna 172I · S/N 17256980Built 1968 · Df Kitcar LLC N494SHRobinson Helicopter R44 II · S/N 10878Built 2005 · Ihde Investments Lp N566WMBeech G33 · S/N CD-1304Built 1972 · Rawson Keith L N777SMBeech G35 · S/N D-4400Built 1955 · Johnson Paul T N7904BCessna 172 · S/N 29704Built 1957 · Wagoner Darrin G N83887Trager PIETENPOL GN-1 · S/N BT-1Built 1977 · Eastwood Gregory S N881TAPiper PA-28-180 · S/N 28-3023Built 1966 · Mcgough Julie E N9037JPiper PA-28-180 · S/N 28-3067Built 1966 · Mcgough Julie E N92MBCoster Michael J VANS RV7A · S/N 71459Owen Evan

Back to Red Oak, TX