OpenAirDocs.org
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.

N1004PPiper PA-23 · S/N 23-6Built 1954 · Vankirk Malcolm RN1023KPiper PA-18-150 · S/N 18-3942Built 1954 · Bushak Aviation LLCN112VAVans RV-12 · S/N 12004Built 2012 · Aircraft Owners And Pilots AssociationN119CKKlimt Claudius AIR CAM · S/N AC0100Built 2004 · Cilliers Carlo RN1525TMooney M20R · S/N 29-0211Built 2000 · Hamilton John DN159PCAmerican Champion 7GCBC · S/N 1418-2006Built 2006 · Aircraft Owners And Pilots AssocN163MECessna 172S · S/N 172S8444Built 2000 · Aircraft Owners And Pilots Association IncN168GSTextron 560XL · S/N 560-6309Built 2021 · G Delaplaine Enterprises LLCN1822HPiper PA-28-181 · S/N 28-7790345Built 1977 · Advanced Aviation Group LLCN1893DJI PHANTOM 3 PROFESSION · S/N P76DCE27016098Hood CollegeN1910CCessna 170B · S/N 26055Built 1953 · Stagnito KollinN195GMMoman Guy E JR GLASAIR III · S/N GM-4Built 1994 · Stickell Rutherford DN19783Cessna 177B · S/N 17702595Built 1976 · Sky Hi IncN1979LGulfstream Aerospace G-IV · S/N 1480Cabana Air LLCN20261Piper J-3 · S/N 2061Built 1938 · Vankirk Malcolm RN2166HEngineering & Research 415-C · S/N 2789Built 1946 · Crone Janice CN219DSDiamond Aircraft Ind DA 40 · S/N 40.219Built 2002 · Jojo & Dino LtdN22640Robinson Helicopter R22 BETA · S/N 0502Advanced Helicopter Concepts IncN2342URobinson Helicopter R22 BETA · S/N 2181Built 1992 · Advanced Helicopter Concepts IncN24380Taylorcraft BC-65 · S/N 1716Built 1946 · Harrington Aaron MN2542ZBellanca 8KCAB · S/N 344-77Built 1977 · Greenway Jonathan JN2584FRobinson Helicopter R22 BETA · S/N 0674Built 1987 · Advanded Helicopter Concepts IncN261VAVans RV-12 · S/N 12034Built 2014 · M&J Aircraft Services LLCN26499Cessna 172R · S/N 17280730Built 1999 · Advanced Aviation Group LLCN292RTTrout Robert E BENSEN B80M · S/N RT 11984 ABuilt 1992 · Trout Robert EN29CXVans RV-12 · S/N 120185Hays William DN3006HErcoupe 415-C · S/N 3631Built 1946 · Dream Flight Aviation LLCN3047NCessna 140 · S/N 13305Built 1947 · Stagnito KollinN30RDRolladen-Schneider LS-4 · S/N 4209Built 1982 · Mid-Atlantic Soaring AssocN3328APiper PA-22-135 · S/N 22-1603Built 1953 · Tulis DavidN335DPRobinson Helicopter R22 BETA · S/N 2372Built 1993 · Advanced Aviation Group LLCN3439HEngineering & Research 415-C · S/N 4064Built 1946 · Dream Flight Aviation LLCN3591VCessna 140 · S/N 14859Built 1948 · Veteran Aviation Services LLCN372CHTitan TORNADO II · S/N CH1952Built 2007 · Mckelvey Lawrence JN3737TPiper PA-28R-180 · S/N 28R-30046Built 1967 · Kenny David JackN3772EChampion AERONCA 7AC · S/N 7AC7046Built 1947 · Fisher Frederick DN37BPCarlo Cilliers BEARHAWK PATROL · S/N P502Cilliers Carlo RN37GHLuscombe 8E · S/N 4683Built 1947 · Ackland Gordon SN3916UCessna 150E · S/N 15061316Built 1965 · Ganvini Christian Adrian RomanN394GACessna 525 · S/N 525-0807Built 2013 · Aircraft Owners And Pilots AssociationN40484Cessna 310Q · S/N 310Q-0735Built 1973 · Sunland Air IncN4353VStokes Clive V VANS RV-4 · S/N 1996Built 1993 · Diehl David S B JrN462MCCarlo Cilliers MUSTANG II · S/N 1865Built 2011 · Cilliers Carlo RN46574Cessna 152 · S/N 15283076Built 1978 · Martz G RodneyN471MRCessna 172R · S/N 17281078Advanced Aviation Group LLCN47694Piper PA-28-181 · S/N 28-7890119Built 1977 · Aircraft Owners And Pilots AssnN4960CDJI AGRAS T50 · S/N 63YBM9B00200EMCalico Ag Services LLCN4973KNavion NAVION A · S/N NAV-4-1973Built 1949 · Mccutcheon Michael RN49PKPiper PA 46-350P · S/N 4622050Built 1989 · Malibu Associates IncN4GABeech A36 · S/N E-2466Built 1989 · Aircraft Owners And Pilots Association
Back to Frederick, MD