Rockville, MD
Registered aircraft · 44
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 = 'MD' AND g.registrant_city = 'ROCKVILLE' 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 = 'MD' AND g.registrant_city = 'ROCKVILLE' 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.
N100CXCessna 414A · S/N 414A0623N1065DPiper PA 46-350P · S/N 4636401N1119ASteven B Gross RV-9A · S/N 91322N1158KMooney M20J · S/N 24-1349N142ACAmerican Champion 8KCAB · S/N 683-92N17807Boyle Joseph E JD PIET · S/N BM001N20174Cessna 177B · S/N 17702640N201CZMooney M20J · S/N 24-0445N207STPilatus PC-12/45 · S/N 107N21059Cessna 182P · S/N 18261388N2128ECessna 172N · S/N 17271165N220AFPilatus PC-24 · S/N 557N2210ASteven Bradley Gross RV-10 · S/N 40377N228RJSpringer Ronald R COZY MARK IV · S/N 1334N264WDDJI MAVIC 3 ENTERPRISE · S/N 1581FHE23B2002008BN30134Waco UPF-7 · S/N 5516N3222PBeech B36TC · S/N EA-573N3982KPiper PA-28-140 · S/N 28-23871N400LMAmerican General Acft AG5B · S/N 10061N412RSRichard Spatz RV-14A · S/N 140253N4181XRobinson Helicopter R44 · S/N 1948N46EZEvans VARIEZE · S/N 449N472KDassault FALCON 2000EX · S/N 603N487SADiamond Aircraft Ind DA 40 NG · S/N 40.NC147N48CJChris Jansen RV-14A · S/N 140684N4900UPiper PA-28-161 · S/N 2842240Registration pendingN523CHFlight Design General Avn F2-LSA · S/N T-21-02-01N53SLDiamond Aircraft Ind DA 40 · S/N 40.519N5798ECessna 150 · S/N 17298N5938YPiper PA-23-250 · S/N 27-3103N6020RCessna 172G · S/N 17253689N6193LCessna 152 · S/N 15284373N6500SCessna 150H · S/N 15067300N7518QRobinson Helicopter R44 II · S/N 10281Expired dealerN7885HPiper PA-12 · S/N 12-788N8174HPiper PA-34-200T · S/N 34-8070155N87FBCirrus Design SR22T · S/N 9587N88UUVans RV-12IS · S/N 121204N901EJDJI PHANTOM 4 PRO+ · S/N 11USH63R710089N9045KPiper PA-28-181 · S/N 28-7890173N947BMDJI PHANTOM 4 PRO V2.0 · S/N 11UDH32R710395N965XMCirrus Design SR22 · S/N 4848N975PSCzech Sport PIPER SPORT · S/N P1001092N994BCPiper PA-28R-200 · S/N 28R-7135036
Back to Rockville, MD