Haslet, TX
Registered aircraft · 59
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 = 'HASLET' 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 = 'HASLET' 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.
N168TBBell 407 · S/N 53434N16SHCessna 150L · S/N 15073404N184HPBeech 95-B55 (T42A) · S/N TC-2248N2138BCessna T206H · S/N T20608437N2179QCessna 177RG · S/N 177RG0579N234UCessna 206H · S/N 20608230N2370XCessna T206H · S/N T20608026N2378YCessna T206H · S/N T20608025N26069Grumman American Avn. AA-5A · S/N AA5A0412N2638UCessna T206H · S/N T20608061N271JLTextron T206H · S/N T20609778N334WDCessna 206H · S/N 20608334N3421JCessna 150G · S/N 15066121N373MBExtra Flugzeugproduktions EA 300/L · S/N 1178N3898BBeech G35 · S/N D-4376N4338GBell Textron Canada 407 · S/N 56358N4372FPiper PA-46-310P · S/N 46-8408086N4395VCessna 195 · S/N 7323N4479VBeech 35 · S/N D-1297Registration pendingN447LSCessna T206H · S/N T20609156N450MFBoeing A75N1(PT17) · S/N 75-6618N458LCTextron T206H · S/N T20609805N478LDBeech B300C · S/N FM-5N49CABeech 95-A55 · S/N TC-214N501GWCessna T206H · S/N T20609157N50648Cessna 208 · S/N 20800191N519RSBell Helicopter Textron Canada 407 · S/N 54843N546YRRaytheon B300 · S/N FL-162N555RABeech E-55 · S/N TE-1066N55722Piper PA-28-180 · S/N 28-7305451N621SRBoeing A75N1(PT17) · S/N 75-3092N623RVVans RV-12 · S/N 120881N643RLTextron T206H · S/N T20609739N6452UMooney M20C · S/N 2199N64TPAmerican Legend AL3 · S/N AL1131N6929LCessna 310K · S/N 310K0029N72338Cessna 120 · S/N 9522N7250PPiper PA-24-250 · S/N 24-2426N74887Cessna 170B · S/N 25853N752LCessna T206H · S/N T20608595N798CRAerospatiale/Alenia ATR 42-320 · S/N 358N798NGCessna T206H · S/N T20609153N79JAHead Balloons AX8-88B · S/N 514N816FTextron T206H · S/N T20609777N819VKKoehn Vincent VANS RV-6A · S/N 60200N8209LCessna 172H · S/N 17256409N823TBeech V35B · S/N D-9521N861MTBell 407 · S/N 53693N9077ACessna 170A · S/N 18836N9195BTextron T206H · S/N T20609195
Back to Haslet, TX