Huntsville, TX
Registered aircraft · 64
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 = 'HUNTSVILLE' 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 = 'HUNTSVILLE' 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.
N109WABoeing E75 · S/N 75-5484N111BZBreezy Flight RLU-1 · S/N 427N1130JRaytheon C90A · S/N LJ-1467N128GTToth George RAND/ROBINSON KR-2 · S/N 6735N129DSCress David George GLASAIR SII RG · S/N 2335N142BJRaytheon G36 · S/N E-3713N1917YMooney M20D · S/N 212N200RRBeech B200 · S/N BB-1282N2037ZBeech A36 · S/N E-1370N21465Cessna 182P · S/N 18261648N2172RCessna 182G · S/N 18255372N221XCSmalley Charles T RV-14A · S/N 140302N2310RCessna 182G · S/N 18255410N2416APiper PA-22 · S/N 22-782N2455BTemco GC-1B · S/N 3755N247BRRobert A Reed TRI-R TECH TR-4 · S/N 4044N2694SCessna 337D · S/N 337-0994N295LCessna 525A · S/N 525A-0073N30009Piper PA-28-161 · S/N 28-7816539N3051KBeech B200 · S/N BB-1495N310HBCessna T310R · S/N 310R1876N31TBSocata TB-20 TRINIDAD · S/N 483N3244FMooney M20E · S/N 670037N33RFDoug Raby SONEX · S/N 1189N3446CCessna 170B · S/N 26489N3503VCessna 150M · S/N 15076526N377DBeech A36 · S/N E-2087N4493FPiper PA-28-151 · S/N 28-7715041N4649HHylio HYL-150 · S/N 17906110381Sale reported, pending cancellationN550BNCessna 182Q · S/N 18265609N5586ZPiper PA-22-108 · S/N 22-9395N5618NGolden Circle Air T-BIRD II · S/N 995438N5658VPiper PA-28R-201 · S/N 28R-7737067N565GGCessna 550 · S/N 5500643N595LMLorne D Montgomery RV-6 · S/N 20557N605JCPiper PA-28R-180 · S/N 28R-31088N6230HPiper PA-34-200T · S/N 34-7870059N6383KCessna 150M · S/N 15077677N65937Cessna 182T · S/N 18281492N67292Cessna 152 · S/N 15281728N6735PBeech A36 · S/N E-2104N70345Piper J3C-65 · S/N 17330N704YXCessna 150M · S/N 15078989N714LXCessna 150M · S/N 15079268N7575VCessna 177RG · S/N 177RG0866N757FECessna 152 · S/N 15279698N759ATCessna 182Q · S/N 18265845N772RVWeinzettle Bryan K RV-7 · S/N 70027N78204Globe GC-1B · S/N 2204N80644Globe GC-1B · S/N 1049
Back to Huntsville, TX