Huntsville, AL
Registered aircraft · 207
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 = 'AL' 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 = 'AL' 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.
N106EHRobinson Helicopter R22 BETA · S/N 1475N106ZYDJI PHANTOM 3 PROFESSION · S/N FK3018193S1700N10SZSchempp-Hirth VENTUS-2C · S/N 88N113AJAerotechnik L-13 SEH VIVAT · S/N 900408N113LSBeech 58 · S/N TH1531N115PMPajares Frank S RV6A · S/N 60348N1218BGary A Barnes RV-7A · S/N 72061N121YPRaytheon A36 · S/N E-3359N124RWCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 08SC189N128DSTextron 208B · S/N 208B5326N128EPCessna 172P · S/N 172-76482N129PWVans RV-12 · S/N 120942N12RVVans RV-12IS · S/N 12197N149BHHamiter Harold W WAG-A-BOND TRAVELER · S/N 1949N15765Piper PA-28R-200 · S/N 28R-7335090N16134Cessna 177B · S/N 17702485N1628HPiper PA-28-161 · S/N 28-7716029N181AEPiper PA-28-181 · S/N 28-7890235N19208Cessna 150L · S/N 15074238Registration pendingN19476Cessna 150L · S/N 15074438N1969MBombardier CL-600-2B16 · S/N 5910N199RBMooney M20J · S/N 24-3244N208LNTextron 208B · S/N 208B5413N20DYSocata TB-20 TRINIDAD · S/N 614N210PWCessna T210N · S/N 21064343N211GDSibi Aldo J T-211 THORPEDO · S/N 0803D0414N217SCRaytheon A36 · S/N E-3221N2197TPiper PA-28-180 · S/N 28-7205048N21TVCessna 560 · S/N 560-0337N231KQMooney M20K · S/N 25-0287N2339BTemco GC-1B · S/N 3639N2345RPiper PA-23-250 · S/N 27-8154019N23800Piper PA-38-112 · S/N 38-79A1055N241RVDavis Alan RV-7 · S/N 70988N2496BAirborne OUTBACK · S/N 582-813N24PVUrban UFM 13 LAMBADA · S/N 64/13N256CMChristopher J Madsen SONEX · S/N 1485N256KTBell UH-1H · S/N 69-15075N256PFCirrus Design SR20 · S/N 11366N2608KSilvaire LUSCOMBE 8A · S/N 5335N26387Grumman American Avn. AA-5A · S/N AA5A0555N26BRBeech A36 · S/N E-2072N2729KFricke Karl E RANS S-12XL · S/N 09970815N27FSSchleicher ASW-27 · S/N 27067N2858FCessna 182J · S/N 18256958N2870TPiper PA-32-260 · S/N 32-7200028N293KDKodiak KODIAK 100 · S/N 100-0293N2966LMooney M20C · S/N 670100N2969KLuscombe 8A · S/N 5696N29ATTolle Alan E RV-3 · S/N 2
Back to Huntsville, AL