Spring, TX
Registered aircraft · 258
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 = 'SPRING' 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 = 'SPRING' 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.
N25456Rearwin 8135 · S/N 811N27969Moon Marcus D PARASON MDM-1 · S/N 01930N2816GPiper PA-28-181 · S/N 28-7990451N2830DAeronca 11AC · S/N 11AC-275N2833DPiper PA-28-161 · S/N 28-7916451N2916TAero Commander 200D · S/N 322N2DVPiper PA-24-250 · S/N 24-1679N2PYCirrus Design SF50 · S/N 0782N30117Piper PA-28-161 · S/N 28-7916077N301RAS.O.C.A.T.A. RALLYE 235E · S/N 12875N303SDCessna 182P · S/N 18261849N30794Cessna 177B · S/N 17701469N31091Piper J3L-65 · S/N 5374N312SDEurocopter AS 350 B3 · S/N 4101N31770Johnson Wally RV-4 · S/N 2085N3189VCessna 150M · S/N 15076413N322HBCirrus Design SR22T · S/N 10686N32615Piper J3C-65 · S/N 5487N329ECCrouse Edward R CROUSE-CHALLNGR II · S/N CH210941237N3422Cessna TU206F · S/N U20602920N350DPiper PA 46-350P · S/N 4636845N35782Piper J3C-65 · S/N 6582N35BRCessna 182P · S/N 18264274N36575Piper PA-32RT-300 · S/N 32R-7885195N369RJCessna 172N · S/N 17273068N36DSCessna 172K · S/N 17259145N373HCessna 210L · S/N 21060190N3750FCessna 172H · S/N 17255245N378MHPilatus PC-12/47E · S/N 1295N381EJCirrus Design SF50 · S/N 0409N3930PPiper PA-22 · S/N 22-3605N41608Air Tractor AT-502B · S/N 502B-2613N420SSCirrus Design SR22 · S/N 8750N42497Piper J3C-65 · S/N 14768N4262KRyan NAVION · S/N NAV-4-1262N429DMBeech F90 · S/N LA-102N4361KPiper PA-32R-301T · S/N 32R-8429015N4378NPiper PA-28-181 · S/N 28-8590012N4396LCessna 172G · S/N 17254479N43CRCub Crafters CC18-180 · S/N CC18-0002N43YBeech A36 · S/N E-576N4428KRyan NAVION · S/N NAV-4-1428N442BSFred Harper VANS RV-7A · S/N 71669N444FGPiper PA-28-181 · S/N 28-8190283N4497XPiper PA-28-181 · S/N 28-7690023N44ALRotorsport UK MTOSPORT 2017 · S/N RSUK-M01835N4553LGulfstream American AA-5B · S/N AA5B1206N4655ECessna 182R · S/N 18268255N4665JPiper PA-28R-180 · S/N 28R-30563N4734ECessna 182R · S/N 18268263
Back to Spring, TX