Southlake, TX
Registered aircraft · 92
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 = 'SOUTHLAKE' 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 = 'SOUTHLAKE' 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.
N1133GCessna LC41-550FG · S/N 411126N115EPLehto Esa PULSAR XP · S/N 411N122BHBoeing D75N1 · S/N 75-3858N13419Waco UBF · S/N 3762N14YBPiper PA-28-181 · S/N 28-7990461N152AWCessna 152 · S/N 15285977N173PKCessna 172K · S/N 17257364N1825JRockwell International 112TC · S/N 13015N182VTCessna 182T · S/N 18281215N1894XCessna 182H · S/N 18255994N1896BCessna 182T · S/N 18281731N1897LBeech 95-B55 (T42A) · S/N TC-1971N1979Beech A36 · S/N E-1568N200LSBombardier CL-600-2B16 · S/N 5911N200VPMooney M20R · S/N 29-0231N206LECessna T206H · S/N T20608810N2163EAeronca 7AC · S/N 7AC-5734N2224ZPiper PA-28RT-201T · S/N 28R-7931171N24673Cessna 182T · S/N 18281745N25VNValmet VALMET L70 VINKA · S/N 25N26071Grumman American Avn. AA-5A · S/N AA5A0413N2673VCessna 177RG · S/N 177RG0650N26822Gulfstream American AA-5A · S/N AA5A0742N273JFCessna 172M · S/N 17261732N282TMCirrus Design SR22T · S/N 1468N28GWNorth American T-28A · S/N 51-7792N28JKPiper PA 46-350P · S/N 4636164N2907DPiper PA-34-200T · S/N 34-7970348N294KPPiper PA-28-236 · S/N 28-7911287N301WAlexander Schleicher ASH 31 MI · S/N 31150N30CBNavion NAVION B · S/N NAV-4-2202BN311RSLockheed 1329-25 JETSTAR II · S/N 5222N314VARichard A Grue VANS RV14 · S/N 140773N3204DCessna 180 · S/N 32002N332KCPiper PA-32R-301T · S/N 3257332N333VRLawrence Wilson WILSON RV-10 · S/N 41228N3430LCessna 182P · S/N 18263459N35543Cessna 172I · S/N 17256824N3615NMooney M-20G · S/N 680012N363WDRobinson Helicopter R44 II · S/N 14656N369LKBoeing A75N1 · S/N 75-6021N3719LCessna 172G · S/N 17253888N373DNDassault/Sud FAN JET FALCON SER F · S/N 324N397CTWoods David RV-8 · S/N 1N416WMGulfstream Aerospace G-1159A · S/N 487N4265QCessna 172L · S/N 17260165N426ACCirrus Design SR22T · S/N 10080N4564NBoeing A75 · S/N 75-6896N46078Cessna 172I · S/N 17257030N46119Cessna 172I · S/N 17257052
Back to Southlake, TX