Registered aircraft · 20

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

N142ATRupp Tim A VIRUS SWIS · S/N 586 SWN 100 ISBuilt 2017 · Rupp Tim A N145RVGoodwin David Carl IV RV-10 · S/N 003Built 2011 · Coleman Ronald N172AWAtec Vos ATEC 322 FAETA · S/N F 420508 LSABuilt 2008 · Gambino Andrew N1845NCessna 120 · S/N 12089Built 1946 · Loucks Donald A N1847QCessna 177RG · S/N 177RG0247Built 1972 · Dye Michael M N250JGGross Jeffrey M RV-8A · S/N 81185Built 2005 · Gross Jeffrey M N2869TPiper PA-28R-200 · S/N 28R-7235149Built 1972 · Boone Susan J N3750HDyal Jane C POWRACHUTE PC 2000 · S/N A246 POWBuilt 2001 · Williams Terrence A N415LPiper PA-32-300 · S/N 32-7740073Built 1977 · Lost Pines Tours LLC N57NGMooney M20TN · S/N 31-0119Built 2008 · Air 500 LLC N606RLXag P150 · S/N 1863FPEG8223512NT196Ag Fertilizer LLC N6296XAero Commander 500-A · S/N 500A-1254-78Built 1962 · Dye Michael M N6691HPiper J3C-65 · S/N 19901Built 1946 · Sills Joseph G N7149ACessna 172 · S/N 29249Steffanic Matthew R N819EBCessna 150F · S/N 15063984Built 1966 · Walker Kyle V N831KTBeech C23 · S/N M-1548Built 1974 · Pilot Network Flyers LLC N86772Bellanca 14-13-2 · S/N 1133Sills Joseph G N94437Williams Terrence A POWRACHUTE PC 2000 · S/N A119POWWilliams Terrance A N9661XCessna 210B · S/N 21057961Mangan Communications Inc N978RACessna 182S · S/N 18280213Built 1998 · Bdk Pegasus LLC

Back to Bastrop, TX