Baltimore, MD
Registered aircraft · 89
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 = 'BALTIMORE' 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 = 'BALTIMORE' 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.
N66047Cessna 150M · S/N 15075799N66439Cessna 150M · S/N 15076051N682HSCessna 680 · S/N 680-0291N6865FCessna 150F · S/N 15063465N689PSLearjet 45 · S/N 473N728TSRobinson Helicopter R44 · S/N 2025N733UACessna 172N · S/N 17268548N73702Cessna 172N · S/N 17267615N7375TCessna 172A · S/N 46975N7436QCessna 182P · S/N 18261076N757XRosenberger R Scott RV-7A · S/N 70497N7618WPiper PA-28-180 · S/N 28-1582N777MUPiper PA-24-400 · S/N 26-83N789WBLancair LC-40-550FG · S/N 40029N80242Akron B · S/N 17N804CPEurocopter AS 350 B3 · S/N 4133N808CPEurocopter AS 350 B3 · S/N 4151N8125APiper PA-28-236 · S/N 28-8011041N81367Grumman American Avn. AA-5B · S/N AA5B0512N815VKKoenigsberg Douglas D ZODIAC 601HD · S/N 6-1339N8170NPiper PA-28-140 · S/N 28-25366N81FCTl-Ultralight S R O TL 2000 STING S4 · S/N 23 ST 503N82FCTl-Ultralight S R O TL 2000 STING S4 · S/N 23 ST 507N8396Rolladen-Schneider LS8-18 · S/N 8378N8417CPiper PA-28-140 · S/N 28-7625114N8432MCessna A150K · S/N A1500132N8444LCessna 172I · S/N 17256644N844VBRobinson Helicopter R44 II · S/N 14132N852AMSocata TBM 700 · S/N 404N8783ABeech B35 · S/N D-2205N89WESkymaster RC Jet Models A-10 · S/N WE002N910MLCessna LC41-550FG · S/N 411031N9111GPiper PA-32-301 · S/N 3206003N91WESkymaster RC Jet Models A-10 · S/N WE001N927ACCessna 680 · S/N 680-0202N9498LAmerican AA-5 · S/N AA5-0238N9914UGrumman American Avn. AA-5A · S/N AA5A0314N99991Cessna 172P · S/N 17276534N99RECessna 525B · S/N 525B0252
Back to Baltimore, MD