OpenAirDocs.org
San Juan, PR

Registered aircraft · 173

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 = 'PR' AND g.registrant_city = 'SAN JUAN'
  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.

N10562Partch Gale E RV-6 · S/N 21910Built 2016 · La Presteza LLCN107CGCessna 172P · S/N 17275826Built 1982 · Colon OrlandoN107VCAero Commander 500-B · S/N 893-1Built 1960 · Lopez Hidaldo VicenteN114PRPiper PA-31-350 · S/N 31-8152088Built 1981 · C W 3 LLCN11HUAviat A-1C-180 · S/N 3430Built 2024 · C5 Holding LLCN1217DVans RV-12 · S/N 121000Irizarry RafaelN121DWBritten-Norman BN-2A-8 · S/N 312Built 1972 · Flight World IncN123HTRockwell International 500-S · S/N 3300Reyes Carlos EN123PRFlores Pedro Rodriguez ES · S/N ES-019Built 2006 · Aerotransporters IncN124JRCessna 172M · S/N 17262637Built 1973 · Flight World IncN130PRHawker Beechcraft G58 · S/N TH-2338Puerto Rico Police DepartmentN13429Cessna 172M · S/N 17262746Built 1973 · Mercado CarlosN1348LCessna 172S · S/N 172S9939Built 2005 · Flight World IncN137PDBell 407 · S/N 53431Built 2000 · Puerto Rico Police DepartmentN138PDBell 407 · S/N 53630Built 2004 · Puerto Rico Police DepartmentN139PDBell 407 · S/N 53631Built 2004 · Puerto Rico Police DeptN13VLEurocopter Deutschland MBB-BK 117 C-2 · S/N 9442Built 2011 · Heli Transport CorpN142RCBell Textron Canada 429 · S/N 57441Built 2022 · Rc Aviation Services IncN149PDBell Helicopter Textron Canada 407 · S/N 54143Administracion De Los Servicios GeneralesN151ECGarlick Helicopters OH-58A · S/N MB-1Built 1969 · Ecolift CorpN159PDBell Helicopter Textron Canada 429 · S/N 57160Built 2013 · Administracion De Los Servicios GeneralesN15YPPiper PA-23-250 · S/N 27-3966Built 1968 · Departamento De Educacion PramiN165PDBell Helicopter Textron Canada 429 · S/N 57163Built 2013 · Administracion De Los Servicios GeneralesN168PDBell Helicopter Textron Canada 429 · S/N 57161Built 2013 · Administracion De Los Servicios GeneralesN171KSCessna 210N · S/N 21063167Built 1979 · Vida Vibrante LLCN1852VGulfstream Aerospace GV-SP (G550) · S/N 5146Built 2007 · G200 LLCN190PDCessna T206H · S/N T20609161Built 2015 · Commonwealth Of Puerto Rico Policia Of Puerto RicoN1951VCessna 120 · S/N 14162Built 1947 · Linero Jose JN196DMRobinson Helicopter R44 II · S/N 11329Built 2006 · Benitez Aviation IncN19793Cessna 177B · S/N 17702598Built 1976 · Lopez VicenteN2061Textron T206H · S/N T20609710Built 2022 · Ramos SammyN206RRCessna T206H · S/N T20609102Built 2013 · 206 Adventures LLCN208JJTextron 208B · S/N 208B5666Built 2022 · Puerto Rico Land And Fruit SeN208PETextron 208B · S/N 208B5357Rc Aviation Services IncN2107UCessna 172S · S/N 172S9603Built 2004 · Flight World IncN223HCCessna 206H · S/N 20608269Built 2006 · G206 LLCN225HMPiper PA-23-250 · S/N 27-2341Built 1963 · Smithart Eric WN237CDCirrus Design SR22T · S/N 11582Built 2026 · C5 Holding LLCN23TAPiper PA-23-250 · S/N 27-7854114Built 1978 · Cor YanN245DAMooney M20E · S/N 879Built 1965 · Reyes Carlos EN2464CCessna T206H · S/N T20608584Built 2005 · Cantera La Rita IncN25023Piper PA-38-112 · S/N 38-79A0984Built 1979 · Linero Jose JN25315Socata TAMPICO TB 9C · S/N 1003Ifr IncN254MVPiper PA-32-260 · S/N 32-117Built 1965 · Flight World IncN255PDBell Textron Canada 429 · S/N 57529Registration pendingBuilt 2024N2614LCessna 402C · S/N 402C0092Built 1979 · Charter Flights Caribbean IncN270RCCessna 402C · S/N 402C0269Built 1980 · Eagle 1-N270rc LLCN27PYCirrus Design SR22T · S/N 11456Built 2026 · 27py LLCN288SPCessna 206H · S/N 20608282Built 2006 · Glass Cockpit Aviation IncN3002BPiper PA-28-161 · S/N 28-7916123Built 1978 · Denton Charles W
Back to San Juan, PR