Panama City, FL
Registered aircraft · 120
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 = 'PANAMA CITY' 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 = 'PANAMA CITY' 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.
N100NNBeech V35B · S/N D-9465N100XRPiper PA-31-350 · S/N 31-8152169N1102TCostruzioni Aeronautiche Tecna P2010 · S/N 130/USN1140LMooney M20J · S/N 24-1158N11587Cessna 150L · S/N 15075543N1188YPiper PA-30 · S/N 30-403N1766MCessna 182P · S/N 18264431N18337Beech V35B · S/N D-10047N1961Beech D50E · S/N DH318N19RSCessna T240 · S/N T24002018N1GFBeech C90 · S/N LJ1031N2028JSchweizer 269D · S/N 0003N202PHBell 206L-3 · S/N 51076N205TDGlasair Aviation USA SPORTSMAN GS-2 · S/N 7429N206BXBell 206B · S/N 2872N230FWGarlick Helicopters OH-58A+ · S/N 70-15649N231BBBell 206L-3 · S/N 51540N231CAMooney M20K · S/N 25-0026N232FWBell OH-58A · S/N 68-16858N234FWBell OH-58A · S/N 69-16130N236FWBell OH-58A · S/N 71-20715N240FWBell OH-58A · S/N 70-15470N242FWBell 206L-3 · S/N 51506N248BWWayne Miller SLING TSI · S/N 328SKN256AWCirrus Design SR22 · S/N 3465N26CHBell 407 · S/N 53312N270Beech D50E · S/N DH-308N2816MMichael Ringenberg VANS RV10 · S/N 42239N281SPGarlick Helicopters OH-58A+ · S/N 73-21912N2837SCessna 150G · S/N 15066737N31FGBell 47G-3B-1 · S/N 3834N327CXMarples John R CX-4 · S/N 0327N346LEKing Erwin T CHRISTEN EAGLE II · S/N KING 0001Registration pendingN348TCCessna 182T · S/N 18281434N4080YCessna 185A · S/N 1850280N40920Bell OH-58A · S/N 71-20774N4092FBell OH-58A · S/N 70-15318N4092YBell OH-58A · S/N 71-20569N4113JPiper PA-28-140 · S/N 28-22429N42947Cessna 182L · S/N 18259262N429ZABell Helicopter Textron 206L-1 · S/N 45375N430GSJMB Aircraft S R O VL-3E-1 · S/N VL-3-216N4610YPiper PA-18-150 · S/N 18-8940N46282Cessna 172I · S/N 17257154N489JEEckdahl Jack L RV-9A · S/N 90508N49612Coffman James W RV-7 · S/N 06201208N50RCCessna 177B · S/N 177-02087N5122PCessna 152 · S/N 15284882N5192VCessna 172RG · S/N 172RG0464N51MTBeech 58 · S/N TH-1485
Back to Panama City, FL