Doral, FL
Registered aircraft · 67
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 = 'DORAL' 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 = 'DORAL' 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.
N122ADassault MYSTERE FALCON 900 · S/N 88N124KTBeech 200 · S/N BB-124N149MRAmerican Legend AL11 · S/N AL-1055N17KDCirrus Design SR22T · S/N 2065N1822QCessna 177RG · S/N 177RG0222N1830MBeech A36 · S/N E575N193SGRaytheon HAWKER 800XP · S/N 258627N194LGCirrus Design SR22 · S/N 2179N199ANBoeing 757-223 · S/N 32393N200KMMaule MXT-7-180 · S/N 14109CN212WTRobinson Helicopter R44 II · S/N 11941N225PGBoeing 737-400 · S/N 25247N2506Cessna T337H · S/N 33701871N2578UPiper PA-34-200T · S/N 34-7970453N2HSPiper PA-34-200T · S/N 34-8070022N3046MPiper PA-28-161 · S/N 28-7816331N304MPAmerican Eurocopter AS350B3 · S/N 7153N305MPEurocopter France AS 350 B3 · S/N 4759N306MPAirbus Helicopters AS350B3 · S/N 9526N307MPAirbus Helicopters AS350B3 · S/N 9531N308MPAirbus Helicopters AS350B3 · S/N 9574N309MPAirbus Helicopters AS350B3 · S/N 9597N30ASBoeing 737-76N · S/N 30050N30LFBeech A36TC · S/N EA-122N319AVSocata TB20 · S/N 707N319SGHawker Beechcraft 4000 · S/N RC29N335CMCessna 414A · S/N 414A0418N345CPPilatus Britten-Norman BN2B-20 · S/N 2244N374RLCirrus Design SR22 · S/N 9026N400ASBoeing 737-82R · S/N 30658N4110WPiper PA-32-300 · S/N 32-40173N4458ABeech V35B · S/N D-9145N489BRBoeing 757-2G5 · S/N 29489N5055GBellanca 7GCBC · S/N 1135-79N50960Cessna 150J · S/N 15069675N540FCRobinson Helicopter R22 BETA · S/N 3858N545LKRaytheon A36 · S/N E-3348N5833SBeech S35 · S/N D-7744N584HPBeech 58 · S/N TH-1365N599HGGulfstream Aerospace G-V · S/N 599N604AABoeing 757-223 · S/N 27055N62030Cessna 182T · S/N 18282096N6554HPiper J3C-65 · S/N 19746N6739YPiper PA-23-250 · S/N 27-4073N678CCPilatus Britten-Norman BN-2B-21 · S/N 858N6908ACessna 172 · S/N 29008N692AABoeing 757-223 · S/N 26972N705GBDouglas DC3C · S/N 13854N716UMDJI PHANTOM PRO PLUS · S/N 11UCF770A50877N7201PMooney M20J · S/N 24-0599
Back to Doral, FL