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.
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
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.
N111ASBoeing 757-2G5 · S/N 29488N1186TCessna 182T · S/N 18281879N129GDEmbraer-Empresa Brasileira De EMB-505 · S/N 50500053N12VBCessna 501 · S/N 501-0078N133MBRobinson Helicopter R44 II · S/N 14369N1350SBeech 58 · S/N TH868N1511WBeech 58 · S/N TH-217N153MADiamond Aircraft Ind DA20-C1 · S/N C0261N157MPMooney M20L · S/N 26-0029N158ASAirbus A320-214 · S/N 1578N179RMPiper PA-31-325 · S/N 31-7912074N182ANBoeing 757-223 · S/N 29592N188JGDehavilland DHC-2 MK.I · S/N 1103N18ZKTextron 208B · S/N 208B5513N213WJDiamond Aircraft Ind DA 42 · S/N 42.AC053N2148LBeech A36 · S/N E-897N237WCCessna 550 · S/N 550-0129N2411ACessna 650 · S/N 650-0103N242MECessna 206H · S/N 20608112N255WTCirrus Design SR22T · S/N 2411N261AWAirbus Helicopters AS350B2 · S/N 7869N263JMBombardier BD-700-1A10 · S/N 60112N267RFSikorsky S-92A · S/N 920260N272AYAirbus Industrie A330-323 · S/N 0333N2749GAero Commander 681 · S/N 6047N279DCessna 525B · S/N 525B0070N27RGCirrus Design SR22T · S/N 9245N28LPiper PA-28-140 · S/N 28-20841N305YWPiper PA-31-350 · S/N 31-7852016N3095MCessna 500 · S/N 500-0250N315ECSocata TB 30 EPSILON · S/N 73N31ATBell 206B · S/N 918N323MKGulfstream Aerospace GIV-X (G350) · S/N 4077N324BKPilatus PC-12/47E · S/N 1021N333XPRaytheon C90A · S/N LJ-1609N350HJBombardier BD-100-1A10 · S/N 20504N351CCCessna 208B · S/N 208B2351N353ASAirbus Industrie A320-214 · S/N 553N353PABoeing 727-225 · S/N 20622N366WWGulfstream Aerospace GV-SP (G550) · S/N 5032N3684HBeech E-55 · S/N TE-1180N36AJBeech B36TC · S/N EA-532N375MJCirrus Design SR22T · S/N 9605N38088Beech 95-B55 (T42A) · S/N TC-2366N3PCBombardier BD-700-1A10 · S/N 9399N4038WRobinson Helicopter R44 II · S/N 14438N408MLBeech 400A · S/N RK-108N414CDCessna 414 · S/N 414-0357N4159APiper PA-18-150 · S/N 1809106N4274RCessna 182S · S/N 18280027
Back to Coral Gables, FL