Registered aircraft · 39

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 = 'IOWA PARK' 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 = 'IOWA PARK'
  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 = 'IOWA PARK'
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.

N102MWood Larry LANCAIR 320 · S/N 175Built 2002 · Ok Av8r LLC N1218JAero Commander 112 · S/N 218Weeks Wesley J N143DMDavid E Mcgehee CALIDUS · S/N C00373Built 2015 · Ok Av8r LLC N173CPSmiltneek Martin M SONEX · S/N 173Built 2003 · Lewis Larry R N180CFHarris Sam E RV-4 · S/N 452Hooker John L N1997MDJI T40 · S/N 64TBL5D0020013Mahler Matthew R N2039ZCessna 150C · S/N 15059839Built 1963 · Bradberry Charles G N2131VCessna 120 · S/N 14356Kelley Edward T N2290GCessna 182B · S/N 51590Built 1958 · Hooker John L N27ATAnthony Terrell SKYOTE · S/N 17-113Terrell Anthony K N2941PPiper PA-22-150 · S/N 22-3210Built 1955 · Weddle Curtis Eugene N29714Taylorcraft BC12-65 · S/N 2560Stade Joel T N30535Segerson James M A · S/N 001Terrell Anthony K N320CYYeager Donald LANCAIR 320 · S/N 384-320-139Moldenhauer Curtis N3225EAeronca 11AC · S/N 11AC-1553Stade Joel T N351VRVashon RANGER R7 · S/N 10203Built 2022 · Murray Aaron N3748PPiper PA-22-150 · S/N 22-3468Stade Joel T N3762TPiper PA-28R-180 · S/N 28R-30073Built 1967 · Benson Robert W N388GRTalos Drones TALOS T60X · S/N 78KBN1L00A0177Mahler Enterprises LLC N39266Taylorcraft BC12-D · S/N 6520Stade Joel T N3931FCessna 172 · S/N 36831Stade Joel T N401MRCessna 401 · S/N 401-0159Built 1967 · Ok Av8r LLC N44305Taylorcraft BC12-D1 · S/N 10105Built 1946 · Stade Joel T N46TJBurch Terry VANS ACFT RV-6 · S/N 23030Built 1998 · Lile John G N517SMCessna 172K · S/N 17257318Built 1968 · Mcelvain Pete R N53TCSornson John W PITTS S-1 · S/N 1144Built 1984 · Terrell Anthony K N5554ZPiper PA-22-108 · S/N 22-9347Built 1962 · Weddle Curtis E N5852CJohn H Knowles JK2 · S/N 01Built 2014 · Knowles Aviation LLC N627BJCopeland Billy RV-6 · S/N 24222Ok Av8r LLC N678BHBonner Paul S RV10 · S/N 40516Built 2009 · Hooker John L N68TRBellanca 17-30A · S/N 75-30749Built 1975 · Naim Danial Shelby N69VTaylorcraft BL12-65 · S/N 3278Built 1941 · Stade Joel T N78410Piper J3C-65 · S/N 23151Built 1947 · Stevens Jim N856DCTextron T206H · S/N T20609657Built 2021 · Valley Aviation LLC N87928Piper L-21B · S/N 18-3926Terrell Anthony K N87996Piper PA-18-135 · S/N 18-4026Built 1954 · Terrell Anthony K N926BBeech 35-A33 · S/N CD-366Built 1961 · Weddle Curtis E N93619Bellanca 17-30A · S/N 74-30644Built 1973 · Bradberry Charles G N99HTBenson Thomas L LANCAIR 235 · S/N 099Knowles John H

Back to Iowa Park, TX