Registered aircraft · 21

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'OSPREY' ORDER BY g.n_number

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 = 'OSPREY'
  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 = 'OSPREY'
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.

N12RHRobinson Helicopter R44 II · S/N 13842Built 2015 · Lead Aviation Fl1 LLC N13957Post Aircraft Corp Wiley A · S/N 10Built 1935 · Mcclure Barry N204BRCirrus Design SR22 · S/N 0248Built 2002 · Rand Joseph N225ACAmerican Champion 8KCAB · S/N 774-96Built 1996 · Safeflight Alliance Inc N2448YCessna 172D · S/N 17249748Built 1962 · Tennison William T N26LARobinson Helicopter R44 II · S/N 12591Built 2008 · Lead Aviation Fl2 LLC N273LBenson Lonn R VANS RV-8 · S/N 81666Built 2010 · Benson Lonn R N30763Cessna 177B · S/N 17701450Built 1970 · Stith Gregory C N367HTRobinson Helicopter R66 · S/N 0426Lead Aviation Fl3 LLC N367LARobinson Helicopter R44 II · S/N 13966Built 2016 · Lead Aviation Fl3 LLC N378HPPiper PA-32R-301T · S/N 3257347Built 2004 · Belair Venice Aviation LLC N6127FCessna 210H · S/N 21059027Built 1968 · Smith Phillip N675SCCzech Sport Aircraft A S SPORTCRUISER · S/N P1001097Built 2011 · Rudin Daniel B N689JJJoffe Finance CCK-2000 · S/N CCK-2000-0108Built 2025 · Joffe Finance LLC N79DJParks J L/Dreffin D SEAWIND 3000 · S/N 48Built 2010 · Parks John L N80VRRaytheon 390 · S/N RB-7Built 2001 · Valor Jets Inc N8331YPiper PA-30 · S/N 30-1476Feit Paul N865TLCirrus Design SR22T · S/N 9637Built 2023 · Isle Aviation II LLC N903VBeech A36 · S/N E-562Built 1974 · Crawford Carlos G N913NDMooney M20R · S/N 29-0500Built 2008 · Maurer Alan R N9361MMooney M20E · S/N 1293Built 1966 · R&D Mooney Inc

Back to Osprey, FL