Pensacola, FL
Registered aircraft · 507
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 = 'FL' AND g.registrant_city = 'PENSACOLA' 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 = 'FL' AND g.registrant_city = 'PENSACOLA' 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.
N101SWDiamond Aircraft Ind DA 42 NG · S/N 42.N214N101XLLewis John T KITFOX XL · S/N GCX-010N102CSBurkhart Grob Flugzeugbau G102 STANDARD III · S/N 5616SN102HYAviat A-1B · S/N 2324N106ZZBell 206A · S/N 508N1075BSikorsky UH-60A · S/N 86-24512N1079GSikorsky UH-60A · S/N 79-23295N108UBSikorsky UH-60L · S/N 86-24544N109GHSikorsky UH-60L · S/N 88-26031N10RFBell UH-1H · S/N 73-21715N1114RPitts Special S-1 · S/N 102N111ZYCessna 172P · S/N 17276611N1145QBell UH-1H · S/N 66-16355N1216EAeronca 7AC · S/N 7AC-4776N1241UCessna 172M · S/N 17266936N12473Cessna 172M · S/N 17262003N12630Cessna 172M · S/N 17262126N126VMagniflight M26 VICTOR · S/N 26234506N130FNLou Toth Aviation Services SONEX · S/N 1520N1311XBell 47G-5 · S/N 7823N131SBWolff Charles L VELOX REV 1 · S/N 001N133Bell UH-1H · S/N 65-09847N133BHHughes 369HS · S/N 990122SN134BHSikorsky UH-60L · S/N 93-26527N135BHSikorsky S70A-27 · S/N 701825N136BHSikorsky S70A-27 · S/N 701835N137BHSikorsky S70A-27 · S/N 702127N13BRPiper PA-23-235 · S/N 27-532N1409JRockwell International 112B · S/N 510N143PSJordan BJ DEFIANT · S/N 045N147FAero Commander 500-B · S/N 1432-152N1481RGrumman American Avn. AA-1B · S/N AA1B-0581N14861Bell 47G-5A · S/N 25089N14GBGlen C Bradley THATCHER CX5 · S/N 001N150BHCirrus Design SF50 · S/N 0255N151GPNorth American P-51D · S/N 44-63791N152BHSikorsky UH-60A · S/N 82-23667N152TDAerostar YAK-52TD · S/N 844103First renewal noticeN153BHSikorsky UH-60A · S/N 79-23277N155WBAmerican Legend AL3 · S/N AL-1172N157WBAmerican Champion 8KCAB · S/N 1139-2014N159ZZHawker Beechcraft C90GTI · S/N LJ-1991N161JKCirrus Design SR22 · S/N 2462N162BHSikorsky UH-60A · S/N 79-23313N162DBLee Dean ROTORWAY EXEC 162F · S/N 6054N1631ECessna 172N · S/N 17271073N1676HPiper PA-28-161 · S/N 28-7716041N167SWVans RV-12 · S/N 120038N169ABPiper PA-25-260 · S/N 25-4517N171ACSikorsky UH-60L · S/N 88-26051
Back to Pensacola, FL