Deerfield Beach, FL
Registered aircraft · 34
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 = 'DEERFIELD 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 = 'DEERFIELD 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.
N166RLIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 047N199WSHonda HA-420 · S/N 42000193N231RBMooney M20K · S/N 25-0016N32JGCirrus Design SR22 · S/N 9477N349GXPilatus PC-12/47E · S/N 2349N37BTPiper PA-32R-301 · S/N 32R-8113083N400EXExtra Flugzeugbau EA-400 · S/N 24N406RSPiper PA-31T · S/N 31T-7920048N429ARBell Textron Canada 429 · S/N 57411N492MMCirrus Design SR22T · S/N 10671N49809Rockwell International 114 · S/N 14055N4BKPiper PA-28-180 · S/N 28-4052N533SFGulfstream Aerospace GVII-G500 · S/N 72017N5403FPiper PA-28-140 · S/N 28-7725055N54DKHonda HA-420 · S/N 42000265N55182Cessna 172P · S/N 17275129N5521RCessna 172F · S/N 17253098N555LXExtra Flugzeugproduktions-Und EA 300/LC · S/N LC059N571BAIcon A5 · S/N 00145N5731XCessna 320 · S/N 320-0031N626HJDassault-Breguet FALCON 50 · S/N 180N6285NBeech A36 · S/N E-2005N685LMRaytheon 390 · S/N RB-186N739TUCessna 172N · S/N 17270800N7602QCessna 310Q · S/N 310Q0102N777BMCessna T210N · S/N 21063156N807WSCessna 401 · S/N 4010300N8341PPiper PA-24-250 · S/N 24-3596N837JMBombardier BD-100-1A10 · S/N 20918N838JMBombardier BD-100-1A10 · S/N 20997N839JMBombardier BD-100-1A10 · S/N 21047N8459NBeech V35A · S/N D-8796N892ABBombardier BD-100-1A10 · S/N 20950N9186NAero Commander 500 S · S/N 3131
Back to Deerfield Beach, FL