Coral Gables, FL

Registered aircraft · 95

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 = 'CORAL GABLES'
  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.

N111ASBoeing 757-2G5 · S/N 29488Aersale IncN1186TCessna 182T · S/N 18281879Built 2007 · Map Aviation LLCN129GDEmbraer-Empresa Brasileira De EMB-505 · S/N 50500053Dij Air LLCN12VBCessna 501 · S/N 501-0078Built 1978 · Cruce Aircraft Services LLCN133MBRobinson Helicopter R44 II · S/N 14369Built 2019 · Hover Holdings LLCN1350SBeech 58 · S/N TH868Built 1976 · Lo Pilato Family Flights IncN1511WBeech 58 · S/N TH-217Built 1972 · Florida Float Plane LLCN153MADiamond Aircraft Ind DA20-C1 · S/N C0261Built 2004 · Glide Air LLCN157MPMooney M20L · S/N 26-0029Mar J Enterprises IncN158ASAirbus A320-214 · S/N 1578Aersale IncN179RMPiper PA-31-325 · S/N 31-7912074Built 1979 · Raven Air LLCN182ANBoeing 757-223 · S/N 29592Built 1999 · Aersale IncN188JGDehavilland DHC-2 MK.I · S/N 1103Built 1957 · Mach Dhc-2 IncN18ZKTextron 208B · S/N 208B5513Built 2019 · Happy Cat Cay LLCN213WJDiamond Aircraft Ind DA 42 · S/N 42.AC053Diamond N213wj IncN2148LBeech A36 · S/N E-897Built 1976 · L&M Cleared2land LLCN237WCCessna 550 · S/N 550-0129Built 1980 · Miro Aviation Holdings LLCN2411ACessna 650 · S/N 650-0103Puerto Rico Air Management Services IncN242MECessna 206H · S/N 20608112Built 2000 · Mike Echo Ventures LLCN255WTCirrus Design SR22T · S/N 2411Built 2021 · Redsky Capital Partners LLCN261AWAirbus Helicopters AS350B2 · S/N 7869Built 2014 · All Wool Aviation LLCN263JMBombardier BD-700-1A10 · S/N 60112Built 2023 · Valhalla Aviation LLCN267RFSikorsky S-92A · S/N 920260Built 2014 · Msp Recovery Aviation LLCN272AYAirbus Industrie A330-323 · S/N 0333Built 2000 · Aersale IncN2749GAero Commander 681 · S/N 6047Built 1971 · Lo Pilato Family Flights IncN279DCessna 525B · S/N 525B0070Built 2006 · Ldt Aviation LLCN27RGCirrus Design SR22T · S/N 9245Built 2023 · Reya Sunshine LLCN28LPiper PA-28-140 · S/N 28-20841Arkad Ventures LLCN305YWPiper PA-31-350 · S/N 31-7852016Built 1977 · Richard L Richards P A TrusteeN3095MCessna 500 · S/N 500-0250Built 1976 · Vsp Citation Holdings LLCN315ECSocata TB 30 EPSILON · S/N 73Built 1985 · Ttp Aviation LLCN31ATBell 206B · S/N 918Built 1972 · Helicopter Leasing IncN323MKGulfstream Aerospace GIV-X (G350) · S/N 4077Built 2007 · Mkre Equipment LLCN324BKPilatus PC-12/47E · S/N 1021Built 2008 · Blue Water Express LLCN333XPRaytheon C90A · S/N LJ-1609Built 2000 · Richard L Richards Pa TrusteeN350HJBombardier BD-100-1A10 · S/N 20504Built 2014 · Lr60 296 Florida Holdings IncN351CCCessna 208B · S/N 208B2351Built 2012 · Seamour Express LLCN353ASAirbus Industrie A320-214 · S/N 553Aersale IncN353PABoeing 727-225 · S/N 20622Aersale IncN366WWGulfstream Aerospace GV-SP (G550) · S/N 5032Built 2004 · Veritaire LLCN3684HBeech E-55 · S/N TE-1180Built 1981 · Avex X CorpN36AJBeech B36TC · S/N EA-532Built 1992 · Furst A JN375MJCirrus Design SR22T · S/N 9605Built 2023 · Jerez MarioN38088Beech 95-B55 (T42A) · S/N TC-2366Toledo Jorge AN3PCBombardier BD-700-1A10 · S/N 9399Built 2010 · Juniper Aviation III LLCN4038WRobinson Helicopter R44 II · S/N 14438Built 2021 · Charlie Delta Rotors IncN408MLBeech 400A · S/N RK-108Aem Air LLCN414CDCessna 414 · S/N 414-0357Built 1972 · Repinter (Delaware) IncN4159APiper PA-18-150 · S/N 1809106Built 1994 · Hauser Associates IncN4274RCessna 182S · S/N 18280027Built 1997 · Catset Funding LLC
Back to Coral Gables, FL