Livingston, TX
Registered aircraft · 69
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'LIVINGSTON' 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 = 'LIVINGSTON' 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.
N101PFCobb Chris SUPER SPORT · S/N KA08015118N1192DAmerican General Acft AG5B · S/N 10024N122PPMamula Ronald G GLASAIR · S/N 526N17GKGMK Ventures AL18 · S/N AL-331N180XZCessna 180H · S/N 18051449N188BSBeech B19 · S/N MB-873N200TCessna 150E · S/N 15060991N2099HEngineering & Research ERCOUPE 415-C · S/N 2722N227SBBehrends Steven R VANS RV-6 · S/N 24839N2337QBeech 23 · S/N M-402N236EKPiper PA-28-236 · S/N 28-7911083N2611EAeronca 7AC · S/N 7AC-6193N2628ZRobinson Helicopter R22 BETA · S/N 0773N2793EAeronca 7AC · S/N 7AC-6376N2944DCessna 170B · S/N 26887N2960ACessna 180 · S/N 30160N2983FCessna 182J · S/N 18257083N32173Shannon J E J-BIRD II · S/N 001N3259ACessna 170B · S/N 25903N3388XMooney M20E · S/N 1099N34SBBreezy RLU-1 · S/N TD-1N350XMooney M20C · S/N 670140N3920RCessna 172H · S/N 17255420N4462APiper PA-22-150 · S/N 22-3795N451TAmerican Legend AL18 · S/N AL-1220N4639LCessna 172G · S/N 17254634N46472Cooper Tom KITFOX IV · S/N 001N4784XCessna 150G · S/N 15064834N5149ZPiper PA-22-108 · S/N 22-8797N5158MBeech C23 · S/N M-2042N515CBAeronca 7AC · S/N 7AC-2629N525LGNiebauer Craig W RV7 · S/N 72333N53MKPiper PA-34-200T · S/N 34-7670135N55920Piper PA-28-140 · S/N 28-7325529N58BZBeech J35 · S/N D-5423N5964PPiper PA-24-250 · S/N 24-1055N60119Cessna 150J · S/N 15070083N614SMEagle Research & Devlpmnt HELICYCLE · S/N 3-39-E2-29N6187ECessna 172 · S/N 46287N6742LBeech B36TC · S/N EA-385N6785RCessna T210F · S/N T210-0185N714WWCessna 152 · S/N 15279499N72SKKPH Investments CALIDUS · S/N C00548N733TVCessna 172N · S/N 17268544N737MACessna 310N · S/N 310N-0093N7474BChampion 7EC · S/N 7EC-532N7516VCessna 177RG · S/N 177RG0813N751CHColeman W Wood JUST ACFT HIGHLANDER · S/N JA235-04-11N7649GCessna 150L · S/N 15074710N77282Cessna 120 · S/N 11724
Back to Livingston, TX