Registered aircraft · 25

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 = 'SATELLITE BEACH' 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 = 'SATELLITE BEACH'
  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 = 'SATELLITE BEACH'
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.

N2040YBeech V35B · S/N D-10181Built 1978 · Cappel Eric H N2214XCirrus Design SR20 · S/N 1319Built 2003 · Elm Air LLC N224MBCessna 177RG · S/N 177RG0935Built 1976 · Barker Ballard M N25DRDavid Harold Blackburn ZENITH STOL 750 · S/N 75-10771Built 2021 · Blackburn David H N321GFGary R Cunningham II M24 PLUS · S/N 24255946Cunningham Gary R II N323CKMeadows Denny SKYBOLT · S/N DM6Hanrahan Sean K N3372SCessna 210J · S/N 21059172Built 1969 · Bmf Services USA LLC N355MBQuest KODIAK 100 · S/N 100-0247Built 2018 · Mio LLC N428RVSean P Stephens STEPHENS RV-10 · S/N 40303Built 2014 · Cunningham Gary R II N4349TPiper PA-28-180 · S/N 28-7205147Built 1972 · Jrh Avgroup Inc N43FMMooney M20R · S/N 29-0139Built 1998 · Baseline Digital Inc N457DTRaytheon A36 · S/N E-3095Built 1997 · Mathew Reggie T N4797MBeech 95-B55 (T42A) · S/N TC-2146Registration pendingBuilt 1978 N5059WPiper PA-28 · S/N 28-68Built 1961 · Smith Michael L N541DSDiamond Aircraft Ind DA 40 · S/N 40.797Built 2007 · Scrappy Air LLC N5592VPiper PA-28-181 · S/N 28-7790482Built 1977 · Black Dog Air LLC N63LLPopcat 4 · S/N 001First renewal noticeBuilt 2009 · Pocap Inc N700MFSmith AEROSTAR 601P · S/N 61P-0282-064Built 1976 · Etavan LLC N739AFCessna 172N · S/N 17270384Built 1978 · Silver Isaac M N808MBBell Helicopter Textron Canada 429 · S/N 57150Built 2013 · Marbina Interests Office LLC N808PAWhisler Robert J RV-7A · S/N 72158Compton Andrew J M N8218UCessna 172F · S/N 17252118Built 1964 · Salley Ronald C N8813CPiper PA-32R-300 · S/N 32R-7680140Built 1976 · Ulrich Helmut Wiegand N93WSWhitley Wesley F HIGHLANDER · S/N JAESC0095Built 2012 · Whitley Wesley F N989RSchempp-Hirth VENTUS 2CM · S/N 139Built 2003 · Bostik Industries LLC

Back to Satellite Beach, FL