Frederick, MD

Registered aircraft · 100

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 = 'FREDERICK'
  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.

N503WBell 206B · S/N 823Built 1972 · L&T Aviation IncN528MJCessna 182T · S/N 18280991Built 2001 · Aircraft Owners & Pilots AssociationN52RFAviat A-1C-200 · S/N 3440Built 2024 · Aircraft Owners And Pilots AssocN53010Cessna 172P · S/N 17274659First renewal noticeBuilt 1981 · L & T Aviation IncN530DCPiper PA 46-350P · S/N 4636690Built 2016 · Crosswind Air LLCN531Beech D35 · S/N D-3676Built 1953 · Martz G RodneyN5323PCessna 150L · S/N 15073223Built 1972 · Carls Phillip GN5447KCessna 172P · S/N 17274114Built 1980 · Fly For Fun LLCN54858Piper PA-23-250 · S/N 27-7554158Built 1975 · Advanced Aviation Group LLCN55198Fairchild M-62C(PT-23A) · S/N T43-5482Built 1945 · Van Kirk Malcolm RN56PECirrus Design SR22 · S/N 3634Built 2010 · Hart Everett TN5845PPiper PA-24-250 · S/N 24-926Built 1959 · Griffel Brandon TN60CKBombardier BD-100-1A10 · S/N 20512Built 2014 · Jurie Jet LLCN60KKCostruzioni Aeronautiche Tecna P2006T · S/N 296/USBuilt 2020 · Krusty Kaptin LLCN61DDCessna 340A · S/N 340A1037Kissner Mark EN6392GCessna 172N · S/N 17273592Built 1979 · Jtw Aero Leasing LLCN6437LAmerican AA-1A · S/N AA1A-0437Built 1972 · Martz G RooneyN65329Cessna 172S · S/N 172S9702Built 2004 · Advanced Aviation Group LLCN65JWVans RV-12 · S/N 12055Built 2015 · Aircraft Owners And Pilots AssociationN664PBCessna 182S · S/N 18280156Built 1998 · Thomas Anthony Robert JrN70596Piper J3C-65 · S/N 17606Built 1946 · Cumberland Curtis LN70800Cessna 182M · S/N 18259367Gangloff William A JrN710PXEPP Ron VANS RV-8 · S/N 81788Built 2006 · Aura LLCN717VCCalo Robert V VANS RV-7A · S/N 70230Built 2010 · Calo Robert VN72664Cessna 172R · S/N 17280818Built 1999 · Advanced Aviation Group LLCN75229Piper PA-28-140 · S/N 28-7625208Built 1976 · Krump David JN76617Cessna 140 · S/N 11057Martz Gary RodneyN77312Cessna 120 · S/N 11754Built 1946 · Van Lehn Sethany AN7782SSchweizer SGS 2-33A · S/N 152Built 1969 · Mid Atlantic Soaring Assoc IncN7799ZPiper PA-25-235 · S/N 25-4002Built 1966 · Mid Atlantic Soaring AssociationN801SPDG Flugzeugbau DG-808 S · S/N 8-301S57X4Built 2004 · Nuckolls Robert LanceN8027LCessna 172H · S/N 17256227Built 1967 · Van Kirk Malcolm RN82096Piper PA-18-150 · S/N 18-7909053Built 1979 · Mid Atlantic Soaring AssocN85EXVan Lehn Richard Glenn HATZ CLASSIC · S/N 194Built 2022 · Van Lehn Richard GlennN8658LPiper PA-25-235 · S/N 25-5104Built 1969 · Mid Atlantic Soaring Association IncN8897UCessna 150M · S/N 15078018Built 1976 · Robison Stephen KN899MAAlexander Schleicher ASK 21 · S/N 21945Built 2017 · Mid Atlantic Soaring AssociationN899SAAlexander Schleicher ASK 21 · S/N 21946Built 2017 · Mid Atlantic Soaring Association (M-Asa)N9163SBeech C23 · S/N M-1778Registration pendingBuilt 1976N9307SBeech B24R · S/N MC-337Built 1975 · Rearick Scott PN9311JPiper PA-28-180 · S/N 28-3404Built 1966 · Sentelle Amanda LN9344PPiper PA-24-260 · S/N 24-4843Built 1969 · Wheeler R TysonN936BGBurkhart Grob Flugzeugbau G102 CLUB ASTIR IIIB · S/N 5649CBMid-Atlantic Soaring Association IncN937SACessna 172S · S/N 172S9377Built 2003 · Advanced Aviation Group LLCN93BSReese David PITTS SPECIAL S-1-C · S/N PDR-1Built 1979 · Cumberland Curtis L JrN9548UGrumman American Avn. AA-1C · S/N AA1C0044Built 1977 · Charlton Daniel BN954JACessna 172S · S/N 172S10500Advanced Aviation Group LLCN9979CCessna R182 · S/N R18200495Built 1978 · Van Lehn Sethany AN998EKCirrus Design SR22 · S/N 4353Built 2016 · Aopa Foundation IncN9WRBeech B200 · S/N BB-913Built 1981 · J P W Investments Inc
Back to Frederick, MD