Jasper, AL
Registered aircraft · 86
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 = 'JASPER' 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 = 'JASPER' 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.
N10597North American AT-6C · S/N 88-13364N12PHHardy Patrick S SMITH MINIPLANE · S/N 001N1314UCessna 210N · S/N 21064685N13KKCessna 172N · S/N 17268760N150MHCessna 150L · S/N 15074821N151CEGarverick Thomas J KR-2 · S/N TJG1N1577SBeech B95A · S/N TD-513N162FCExtra Flugzeugbau EA 300/L · S/N 135N176FCBoeing E75N1 · S/N 758251N1773FCessna 172H · S/N 17255168Registration pendingN183TXCessna 525A · S/N 525A0183N190STFleeman James E FLEEMAN FA-11 · S/N 1932N2086WBeech D95A · S/N TD-644N23443Cessna 150H · S/N 15068949N26HDCirrus Design SR22T · S/N 10892N272TLCessna 172N · S/N 17270719N2760YBeech 95 · S/N TD-126N297GRBell OH-58C · S/N 69-16312N298GRBell OH-58C · S/N 70-15061N299GRBell OH-58C · S/N 69-16162N3030VCessna 150M · S/N 15076359N30JVBeech D95A · S/N TD-597N3255CBeech E35 · S/N D-3920N338GSTextron 172S · S/N 172S13326N350RTRaytheon B300 · S/N FL-512N3519EAeronca 7AC · S/N 7AC-6886N364EBEdwin B Banks HUMMEL H5 · S/N 220N401RMEurocopter France AS 350 B3 · S/N 3837N415RWBeech D55 · S/N TE-643Sale reportedN41FGCessna T-41B · S/N R1720093N423HLHutchison Hubert L ZENITH CH 750 · S/N 75-8664N440RMEurocopter EC 130 B4 · S/N 7017N45364Cessna 150M · S/N 15076876N464RMEurocopter AS 350 B3 · S/N 3962N47182Aeronca 0-58B · S/N 13284N4759GCessna 172N · S/N 17273341N485JMTextron 172S · S/N 172S13465N488SBCessna 550 · S/N 550-1026N50152Alliant DESTINY 2000 · S/N 2C0315N5067HCessna 172M · S/N 17265326N5138ECessna 172N · S/N 17271731N517DFCessna L-19E · S/N 24517N5194FCessna 172N · S/N 17273125N51WKDuncan W G LANCAIR 235 · S/N 16N52155Cessna 180J · S/N 18052524N5408UBeech D95A · S/N TD-698N5457DCessna 172N · S/N 17272574N5466UBeech D95A · S/N TD-702N5546TCessna 172E · S/N 17251446N558MAAmerican Champion 8KCAB · S/N 991-2005
Back to Jasper, AL