Annapolis, MD
Registered aircraft · 64
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 = 'ANNAPOLIS' 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 = 'ANNAPOLIS' 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.
N100UKFrank J Salomone RV10 · S/N 41541N123PGMooney M20C · S/N 3154N1326TPiper PA-28-180 · S/N 28-7205286N1497ZRobbers Kenneth V SONEX · S/N 1497Registration pendingN154BJPiper PA-32R-300 · S/N 32R-7780251N15FYMalechek Robert Lee RV7-A · S/N 71328N1880VCessna R172K · S/N R1722218N196RWWatson Ray S AMERICAN SPIRIT · S/N 043N1LVBeech 35-C33A · S/N CE15N2044YCessna 182T · S/N 18281643N205DCMooney M20J · S/N 24-3004N212MMCirrus Design SR22 · S/N 0403N2203VPiper PA-28-161 · S/N 28-7916326N256GRBeech A45 · S/N G-754N268JCCessna R182 · S/N R18200213N274VFCessna 182E · S/N 18253792N279JSCessna 182Q · S/N 18266499N27AWRyan NAVION B · S/N 4-2172BN281CTGary Wilcox RV 7 · S/N 71082N2897WPiper PA-28-236 · S/N 28-7911234N291PCAviat A-1B · S/N 2340N29HHColumbia Aircraft Mfg LC41-550FG · S/N 41580N2ZTDowner REPUBLIC RC-3 · S/N 671N3132PPiper PA-23 · S/N 23-1056N32209Piper PA-28-180 · S/N 28-7505037N331DJJones David B VANS RV-10 · S/N 40331N3383APiper PA-22-135 · S/N 22-1646N355BLBRM Aero S R O BRISTELL LSA · S/N 355/2018N3757WPiper PA-32-260 · S/N 32-672N3830VJames D Winkler PA 18 REPLICA · S/N JA2109170N383RLRaytheon 1900D · S/N UE-383N390JDPiper PA-31T · S/N 31T-7820061N401LVSocata TBM 700 · S/N 588N403MPiper PA-31T1 · S/N 31T-8004033N4232VCessna 170 · S/N 18588N43650Piper PA-28-151 · S/N 28-7415551N43DJEmbraer S A EMB-505 · S/N 50500557N488RVRaymond Bruce E VANS RV-8 · S/N 81705N505SBell Helicopter Textron Canada 505 · S/N 65124N518LADiamond Aircraft Ind DA 40 NG · S/N 40.NC131N5197SPiper PA-28-180 · S/N 28-7105048N52321Cessna 182P · S/N 18262526N535LRobert C Richardson IV SEAREY · S/N 1LK535CN53UPBeech 95-B55 (T42A) · S/N TC-708N554NRBell OH-58A+ · S/N 70-15198N562TUCostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1562N56GRRicciotti Gerard F RV-8 · S/N 82350N582VAVans RV-12IS · S/N 120988N58GDGeorge L Daelemans III SE-RG · S/N 001001N5YLRepublic RC-3 · S/N 330
Back to Annapolis, MD