Registered aircraft · 21

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 = 'ACKERLY' 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 = 'ACKERLY'
  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 = 'ACKERLY'
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.

N128CFRichards David Stanley III Z701 · S/N 75203Snell Marion Lea N2538ZBellanca 8KCAB · S/N 342-77Built 1977 · Snell Marion Lea N256MPMatthew Snell And Pamla Snell M16 XTREME · S/N 16256136Snell Matthew L N322MGGreg W Gremminger MAGNI M22 · S/N 22138124Snell Marion Lea N402BFCessna 402B · S/N 402B1010Built 1975 · Snell Marion Lea N5077FMarcks Noel L RAF 2000 · S/N H2-05-16-649Snell Marion Lea N585USNil Rotorcraft Club MAGNI M24 · S/N 24106104Built 2011 · Rebel Reds Gyros LLC N6112TCessna 150E · S/N 15060812Built 1964 · Snell Matthew N611CRBeech C90A · S/N LJ-1234Built 1990 · V J Coleman And Son N61MJSchweizer 269C · S/N S1483Built 1990 · Snell Matthew Lea N6363SCessna 150G · S/N 15067163Snell Matthew L N707NMFrancik Michael E HARMON ROCKET II · S/N 124Built 2003 · Dyer Marvin N76185Cessna A185F · S/N 18503013Snell Marion Lea N800MGCessna 310Q · S/N 310Q0937Built 1974 · Snell Marion Lea N80688Robert R Smura HAWK ARROW II · S/N HA-II-153-503-TRIBuilt 2025 · Snell Marion L N816MJMarion Snell M24 PLUS · S/N 24255886Rebels Reds Gyros LLC N8600PPiper PA-24-400 · S/N 26-133Built 1965 · Dyer Marvin N862WTHeimberger Robert MAGNI M16 · S/N 16105774Built 2010 · Rebel Red'S Gyros LLC N912MGSport Flight Inc/Marshall R D MAGNI M-16 · S/N 16-01-1783Built 2002 · Rebel Reds Gyros LLC N9253RCessna TR182 · S/N R18200674Built 1978 · Dr Equipment LLC N9572WCessna 172R · S/N 17280544Built 1998 · Dr Equipment LLC

Back to Ackerly, TX