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.
N1017TAero Commander 112 · S/N 403N106ATPiper PA-32R-300 · S/N 32R-7780326N1113GSchreder HP-14 · S/N PJ-29N113MHome Built DOODLE BUG · S/N A-1N120JHCessna U206G · S/N U20603636N124BXVans RV-12 · S/N 120395N127RMMcshane Richard C LANCAIR 360 · S/N 0002N149CCBeech 300 · S/N FA-145N15050Piper PA-28-140 · S/N 28-7225569N158RMBeech 58 · S/N TH-1543N1750JPiper PA-28-140 · S/N 28-24169N20204Cessna 177B · S/N 17702644N22GLLeake SKYBOLT · S/N GL-1N22MSCirrus Design SR22T · S/N 2080N234JKEmbraer EMB-550 · S/N 55000022N2473GCessna 172R · S/N 17281019N2544CSexton Jerry T KOLB FIRESTAR · S/N JS002N256BDRobert A Nicholson JR ROTORWAY A600 · S/N 6922N284XKKoenigsberg Douglas D SKY RANGER · S/N 24-1972N30713Cessna 177B · S/N 17701417N313XFlightstar FS-IISC · S/N 377N33621Boeing E75 · S/N 75-5865N353ACPiper PA-28-181 · S/N 2843161N378NSPiper PA 46-350P · S/N 4636236N3797YCessna 210D · S/N 21058297N410CKEurocopter AS 350 B2 · S/N 3793N415CAPiper PA-28-181 · S/N 2843215N422LTCirrus Design SR22 · S/N 0730N4385HButler Gaylord A TUKAN · S/N 6235601N43DNPiper PA-28-235 · S/N 28-7310036N445BCCastaneda Bismarck G CAST-AIR · S/N 1N44MGSchempp-Hirth MINI-NIMBUS HS7 · S/N 11N451FAirbus Helicopters AS350B3 · S/N 9250N452FAirbus Helicopters AS350B3 · S/N 9293N453FAirbus Helicopters AS350B3 · S/N 9317N4552XPiper PA-32R-300 · S/N 32R-7680027N460SJDassault FALCON 2000EX · S/N 168N4654KCessna 182P · S/N 18263656N472CBTextron 680A · S/N 680A0219N47498Piper PA-28R-201 · S/N 28R-7737169N493CFDassault FALCON 900EX · S/N 189N4DHBeech D18S · S/N A-260N5072VVarga 2150A · S/N VAC-61-76N5111SPiper PA-28-180 · S/N 28-7105130N5270VNorth American T-6G · S/N 49-3086N562PWTurner W Edward VANS RV 4 · S/N 967N589PSLearjet 45 · S/N 473N6210FCessna 182P · S/N 18264123N6239WSchlitter Randy RANS S-12 AIRAILE · S/N 08950642N6242WPiper PA-28-140 · S/N 28-20239
Back to Baltimore, MD