Bethesda, 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 = 'BETHESDA' 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 = 'BETHESDA' 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.
N102GBBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1424N11247Waco QCF · S/N 3487N1222BCessna 425 · S/N 425-0060N135JBCessna 170B · S/N 26850N15391Piper PA-28-180 · S/N 28-7305068N164PSOwen John R VLOCTY LRG WG FXD GR · S/N 3FE030N19414Cessna 150L · S/N 15074407N20748Beech C23 · S/N M-2077Registration pendingN233JBMooney M20K · S/N 25-0598N24TEPiper PA-39 · S/N 39-53N279SBNarkunas Dana A FOKKER TRIPLANE · S/N 2079N29552Cessna 172M · S/N 17264118N301MLHawker Beechcraft HAWKER 900XP · S/N HA-0094N314VDBell Helicopter Textron Canada 505 · S/N 65101N360BEGulfstream Aerospace GIV-X (G450) · S/N 4054N36304Piper PA-28-181 · S/N 28-7890504N405JHCessna R182 · S/N R18201790N431KFleet 2 · S/N 154N4814ECessna A185F · S/N 18503879N5053TPiper PA-28-180 · S/N 28-7205243N518DMTitan TORNADO · S/N D95XXXCOHK0156N5993ECessna 172N · S/N 17271981N612JDTextron 680 · S/N 680-0585N624KRCirrus Design SR20 · S/N 1314N64390Cessna 172P · S/N 17275552N695RCGulfstream AM Corp Comm Div 695A · S/N 96087N711GGIsrael Aerospace Industriesltd G200 · S/N 184N720JDCirrus Design SR22T · S/N 1798N72WTBeech A36 · S/N E-2165N7360XCessna 150B · S/N 15059460N738PKCessna TR182 · S/N R18200950N74818Grumman American Avn. AA-5B · S/N AA5B0364N7856VMooney M20C · S/N 2819N787SEMooney M20K · S/N 251042N80282Cessna 172M · S/N 17266493N80299Cessna 172M · S/N 17266505N80722Beech F33A · S/N CE-295N81094Grumman American Avn. AA-5B · S/N AA5B0427N8831MBeech D95A · S/N TD-574N8948CPiper PA-28-181 · S/N 28-7690172N931SJCessna 182S · S/N 18280931N97148Cessna 182Q · S/N 18266992N992WWCessna 172R · S/N 17280717N9TQQuicksilver MXL II SPORT · S/N 000812
Back to Bethesda, MD