Gadsden, AL
Registered aircraft · 29
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 = 'GADSDEN' 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 = 'GADSDEN' 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.
N1353MPiper J3C-65 · S/N 9913N1613VCessna 172M · S/N 17263692N2668UCessna 172D · S/N 17250268N266NGPilatus PC-12/47E · S/N 1266N30LEPiper PA-28R-200 · S/N 28R-7235018N31531Piper PA-28-161 · S/N 28-7816558N3263SCessna 182G · S/N 18255763N33248Cessna 177RG · S/N 177RG0932N345XCirrus Design SR22T · S/N 1958N36LWBeech B36TC · S/N EA-452N3840UBeech A36 · S/N E-1821N38673Piper J3C-65 · S/N 7182N42602Piper J3C-65 · S/N 14887N43707Piper PA-28-151 · S/N 28-7415561N4380YRaytheon B300 · S/N FL-280N47ALCirrus Design SR22T · S/N 10083N632TCBell OH-58C · S/N 72-21376N71LADiamond Aircraft Ind DA 40 · S/N 40.471N7356JPiper PA-28-140 · S/N 28-24708N7514KBell OH-58C · S/N 69-16357N771KKTextron 525B · S/N 525B0559N77KWExtra Flugzeugbau EA 300/L · S/N 053N80XPHiza David K PITTS MODEL 12 · S/N 349N8253PPiper PA-34-200T · S/N 34-8070337N826BRRans Designs S-21LS OUTBOUND · S/N 02210158N9324KPiper PA-28-181 · S/N 28-7690243N933EMark Stokes RV7A · S/N 73947N991ECBell TH-57 · S/N 3729N992ECBell TH-57 · S/N 3694
Back to Gadsden, AL