OpenAirDocs.org
Columbia, MD

Registered aircraft · 85

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

N112HTRockwell International 112TCA · S/N 13254Built 1978 · Taffel Sherman D DBAN1191LAmerican General Acft AG5B · S/N 10016Built 1991 · Knotts JamesN135MHEurocopter Deutschland EC135T1 · S/N 0131Built 2000 · Bay Life Services CorpN138MHEurocopter Deutschland EC 135 T2+ · S/N 0417Built 2005 · Bay Life Services CorpN18167Cessna 150L · S/N 15073838Built 1972 · Be Chara Niz Ar EN202GFGlaser-Dirks Flugzeugbau DG-200 · S/N 2-144/1740Built 1981 · Jones Thomas CN228EECirrus Design SR22T · S/N 1979Built 2019 · Yankee Alpha LLCN242MZMoravan Z242L · S/N 0732Built 1999 · Bechara Nizar EN317FRAirbus A320-251N · S/N 7835Built 2017 · Wells Fargo Trust Co Na TrusteeN318FRAirbus A320-251N · S/N 7946Built 2017 · Wells Fargo Trust Co Na TrusteeN33294Boeing 737-824 · S/N 34000Built 2005 · Wells Fargo Trust Co Na TrusteeN332FRAirbus A320-251N · S/N 8307Built 2018 · Wells Fargo Trust Co Na TrusteeN335FRAirbus A320-251N · S/N 8320Built 2018 · Wells Fargo Trust Co Na TrusteeN337FRAirbus A320-251N · S/N 8380Built 2018 · Wells Fargo Trust Co Na TrusteeN341FRAirbus A320-251N · S/N 8516Built 2018 · Wells Fargo Trust Co Na TrusteeN343FRAirbus A320-251N · S/N 8580Built 2018 · Wells Fargo Trust Co Na TrusteeN34LRPilatus PC-12/47E · S/N 2369Built 2024 · Lr2 Holdings LLCN3539UPiper PA-31-310 · S/N 31-7912120Built 1979 · Bechara Nizar EN363PHBombardier DHC-8-202 · S/N 520Built 1998 · Wells Fargo Trust Co Na TrusteeN375HAAirbus A330-243 · S/N 1606Built 2015 · Wells Fargo Trust Co Na TrusteeN377ARBoeing 737-86J · S/N 37753Built 2010 · Wells Fargo Trust Co Na TrusteeN379HAAirbus A330-243 · S/N 1672Built 2015 · Wells Fargo Trust Co Na TrusteeN380CDCirrus Design SR22 · S/N 1380Built 2005 · Tomlinson Consulting LLCN400GDGlaser-Dirks DG-400 · S/N 4-98Built 1984 · Blacklin Peter AN400HBSchempp-Hirth DISCUS B · S/N 550Built 1995 · Kautter William JN404AVBombardier DHC-8-402 · S/N 4010Built 2001 · Wells Fargo Trust Co Na TrusteeN4113BBellanca 17-31A · S/N 74-32-145Built 1974 · Rishell Charles GN412BNMyers Larry A VANS RV-6 · S/N 60400Built 2003 · Bythrow Peter FN4152RPiper PA-32R-301 · S/N 3246179Built 2000 · Roby Richard JN418AVDehavilland DHC-6-300 · S/N 521Built 1977 · Wells Fargo Trust Co Na TrusteeN428KRBeech V35B · S/N D-9306Built 1972 · Lilly James DN434JRBeech T-34B · S/N 140839Mentor Holdings LLCN437YVDehavilland DHC-8-202 · S/N 437Wells Fargo Trust Co Na TrusteeN4595BCessna 180 · S/N 31494Built 1955 · Bartusek Donald L TrusteeN477AVAirbus A320-214 · S/N 5477Built 2013 · Wells Fargo Trust Co Na TrusteeN505VLAirbus A320-233 · S/N 4798Built 2011 · Wells Fargo Trust Co Na TrusteeN509VLAirbus A320-233 · S/N 5062Built 2012 · Wells Fargo Trust Co Na TrusteeN512VLAirbus A320-233 · S/N 5308Built 2012 · Wells Fargo Trust Co Na TrusteeN513VLAirbus A320-233 · S/N 5322Built 2012 · Wells Fargo Trust Co Na TrusteeN514VLAirbus A320-233 · S/N 5337Built 2012 · Wells Fargo Trust Co Na TrusteeN526VLAirbus A320-233 · S/N 6470Built 2015 · Wells Fargo Trust Co Na TrusteeN52RABeech C23 · S/N M-1626Built 1974 · Rennenkampf Erik JN536AVAirbus A320-214 · S/N 5360Built 2012 · Wells Fargo Trust Co Na TrusteeN561AVBombardier CL-600-2B19 · S/N 7561Wells Fargo Trust Co Na TrusteeN599AVAirbus A320-214 · S/N 4599Built 2011 · Wells Fargo Trust Co Na TrusteeN605NKAirbus A320-232 · S/N 4548Built 2011 · Wells Fargo Trust Co Na TrusteeN606NKAirbus A320-232 · S/N 4592Built 2011 · Wells Fargo Trust Co Na TrusteeN611NKAirbus A320-232 · S/N 4996Built 2012 · Wells Fargo Trust Co Na TrusteeN619NKAirbus A320-232 · S/N 5517Built 2013 · Wells Fargo Trust Co Na TrusteeN630NKAirbus A320-232 · S/N 6304Built 2014 · Wells Fargo Trust Co Na Trustee
Back to Columbia, MD