Springtown, TX

Registered aircraft · 41

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N143JDMaule M-5-180C · S/N 8083CHarris Steven VN15DLBeech 35-A33 · S/N CD-375Schlund Bradley DN2005QCessna 177RG · S/N 177RG0405Built 1973 · Coon Roger EN2133MPiper J3C-65 · S/N 20920Built 1946 · Crosswell Joe DN2363ZBeech 23 · S/N M-77Built 1962 · Black Thomas LN252CEEllis Steven D SELLIS RV-4 · S/N 4166Registration pendingBuilt 2003N279PAPiper PA46-500TP · S/N 4697366Built 2008 · Lamont Air LLCN2880TPiper PA-28R-200 · S/N 28R-7235151Built 1972 · Vuppala KavyaN32MEEaster STARDUSTER TOO SA300 · S/N 1733Built 1984 · Harris Steve VN3438RCessna 182L · S/N 18258738Built 1967 · Dauenhauer ColbyN34819Porterfield LP-65 · S/N 921Built 1941 · Giles Forrest DN35128Cessna 177B · S/N 17702224Built 1974 · Lambo Air LLCN35839Piper J3L-65 · S/N 6609Giles Forrest DN4325TPiper PA-28-180 · S/N 28-7205141Built 1971 · Bledsoe Randell WN434CCBeech B36TC · S/N EA-321Built 1982 · Lambo Air LLCN440EZHanson David VARI EZE · S/N 62048Crabtree William DN5056JGordon D L/Vance G E JR SKYSTAR CLASSIC IV · S/N C9810-0229Kelley William P JrN520DDBeech 200 · S/N BB-738Built 1980 · Thomas Asset Group LtdN53125Boeing A75N1(PT17) · S/N 75-2227Built 1942 · Giles Forrest DN5543JPowrachute PEGASUS · S/N A012ULSDauenhauer Ricky LN56436Boeing A75N1(PT17) · S/N 75-4870Potter AaronN6093SBeech V35B · S/N D-9826Built 1975 · Farmer ScottN6515XCessna 210 · S/N 57515Built 1960 · Dauenhauer Steven MN6537ECessna 175 · S/N 56037Dittmer Michael CN674TGMaule M-6-235 · S/N 7426CBuilt 1983 · Stallion Air LLCN696NSalisbury AEROBAT SPECIAL · S/N 1-AGiles Forrest DN6979UMooney M20E · S/N 339Built 1964 · Giles Forrest DN7600FChampion 7KCAB · S/N 245-70Giles Forrest DN78HYAviat A-1B · S/N 2048Built 1999 · D A Lamont Public Adjusters LLCN7959KBeech 35-B33 · S/N CD-782Built 1964 · Ron Arnold Dpe LLCN7985ABell 47G · S/N 1022Built 1958 · Giles Forrest DN802GLGreat Lakes 2T-1A-2 · S/N 0802Giles Forrest DN82924Aeronca 7AC · S/N 7AC1574Built 1946 · Guarino Charles EN88278Bellanca 8KCAB · S/N 167-75Built 1974 · Crosswell Joe DN8906UBeech S35 · S/N D-7906Kelley WilliamN8919UBeech 35-C33 · S/N CD-943Built 1965 · Crosswell Joe DN90993Bellanca 7GCBC · S/N 441-73Built 1973 · Crosswell JoeN9253PPiper PA-24-260 · S/N 24-4751Built 1967 · Conway BrandonN925ERBellanca 7GCBC · S/N 385-72Crosswell Joe DN9466HBeech D17S · S/N 6688Built 1944 · Giles Forrest DN95HCWaco Classic 2T-1A-2 · S/N 1210Built 2016 · Crosswell Joe
Back to Springtown, TX