Spring, TX
Registered aircraft · 258
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 = '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.
N103JDSocata TBM 700 · S/N 619N103TNMooney M20TN · S/N 31-0103N1066UMooney M20R · S/N 29-0005N10UJJonker Sailplanes CC JS 1B · S/N 1B-010N111AKTextron 182T · S/N 18283325N112GJRobinson Helicopter R44 · S/N 0455N1141UCessna 172M · S/N 17266870N11554Cessna 150L · S/N 15075516N118BWWester Barry C ASAP CHINOOK PLUS 2 · S/N 02129N119AKDassault-Breguet FALCON 50 · S/N 76N11SDCirrus Design SR22 · S/N 4957N122RRBeech N35 · S/N D-6706N125SESmith AEROSTAR 601 · S/N 61-0027N1285ZBeech 95-55 · S/N TC-100N1319ECessna 182R · S/N 18268173N1322LCirrus Design SR22 · S/N 0022N1332ZBeech 95-55 · S/N TC-141N1420ECessna 182R · S/N 18268177N144BYMooney M20J · S/N 24-0034N147UBeech V35 · S/N D-8533N1492UCessna 182T · S/N 18281962N16356Bell 47D1 · S/N 536N169GRBeech B36TC · S/N EA-580N16MSCessna 182Q · S/N 18267267N170MADiamond Aircraft Ind DA 40 · S/N 40.272N1714ASpring Fling RV-14A · S/N 140318N172GFCessna 172F · S/N 17252903N17520Beech A36 · S/N E-974N1800TPiper PA-28-140 · S/N 28-7125152N1805VBeech 77 · S/N WA-270N18290Beech A36 · S/N E-1076N182ETCessna 182R · S/N 18268180N185RECessna A185E · S/N 185-1524N1919UTextron 172S · S/N 172S13295N19290Cessna 150L · S/N 15074308N1966FCessna 172N · S/N 17273578N1993HPiper PA-28-181 · S/N 28-7790367N2058KBeech 58TC · S/N TK-66N205KTBeech 58 · S/N TH-1286N2082HAircraft Mfg & Development CH 2000 · S/N 20-0045N20RRORR Ronnie M PITTS S1S · S/N 5-28-35N21489Piper PA-28-181 · S/N 28-7990050N226DBeech D95A · S/N TD-542N22RACirrus Design SF50 · S/N 0270N2329WBeech A23-19 · S/N MB-20N2345LBeech 23 · S/N M-177N234AKCirrus Design SR22 · S/N 2878N23703Stinson HW75 · S/N 7150N24006Beech B19 · S/N MB-835N242RBeech F33A · S/N CE1001
Back to Spring, TX