Registered aircraft · 18

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 = 'AR' AND g.registrant_city = 'AUSTIN' 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 = 'AR' AND g.registrant_city = 'AUSTIN'
  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 = 'AR' AND g.registrant_city = 'AUSTIN'
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.

N1245DCessna 170A · S/N 19799Built 1950 · Chism Jerry N1753DCessna 170A · S/N 20196Built 1951 · Klein John T N1800SRussell William M HP-18M · S/N 171Built 1982 · Edwards Joseph C N2188YPiper J3C-65 · S/N 13992Built 1945 · Groat Stanley G N2292CCessna 180 · S/N 30592Built 1953 · Klein John T N23710Stinson HW75 · S/N 7173Built 1939 · Klein John T N2435JCessna 150G · S/N 15065535Built 1966 · Witherspoon Jason C N2481JX-Air T VERSION · S/N WLB121959Built 2003 · May John D N3248QRogers Kenneth J FLAGLOR SCOOTER · S/N 347May John D N49535Piper J3C-65 · S/N 8862Built 1942 · Klein John T N5147Boredom Fighter W11 · S/N 1Built 2001 · Groat Stanley G N56LAConsolidated Aeronautics LAKE LA-4-200 · S/N 973Built 1979 · Groat Stanley G N595RVMeans Randy J RV 10 · S/N 40818Built 2009 · Yellow Bird Aviation LLC N620KJD-Fly UL STORK · S/N 002May John D N6712ECessna 175 · S/N 56212Built 1959 · Edwards Joseph C N68662Cessna 175 · S/N 55543Built 1958 · Edwards Joseph C Trustee N8082BBailey Richard L HIPERLIGHT · S/N 728Built 2000 · May John D N9948HAeronca L-3 · S/N 058B-4562Built 1943 · Edwards Joseph C Trustee

Back to Austin, AR