Hunt Valley, MD
Registered aircraft · 32
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 = 'HUNT VALLEY' 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 = 'HUNT VALLEY' 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.
N1418ACessna 172S · S/N 172S10670N242UVAai Corp DBA Textron Systems U SHADOW RQ-7B · S/N 242N245USAai Corp DBA Textron Systems U SHADOW RQ-7B · S/N 245N284UVAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 284N287TSAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 287N292TSAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 292N310UVAai Corp DBA Textron Systems U SHADOW RQ-7B · S/N 310N315UVAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 315N317TSAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 317N325STPiper PA-46-600TP · S/N 4698138N354BBRM Aero S R O BRISTELL LSA · S/N 354/2018N379TSAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 379N403USAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 4003N404USAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 4004N404UVAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 404N405UVAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 405N418JWTextron Systems Unmanned Systs AEROSONDE MK 4.7G · S/N 4018N428UVAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 428N429UVAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 429N430UVAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 430N457UVAai Corp DBA Textron Systs UNM AEROSONDE MK 4.7G · S/N 457N521BUCessna 680 · S/N 680-0330N631TJCessna 525C · S/N 525C0031N701UVAai Corp DBA Textron Systems U SHADOW RQ-7B M2 · S/N 701N703UVAai Corp DBA Textron Systems U SHADOW RQ-7B · S/N 703N705UVAai Corp DBA Textron Systems U SHADOW RQ-7B M2 · S/N 705N721TSAuen Jeffery G AIR CAM · S/N AC026N775QCDJI PHANTOM 3 PROFESSION · S/N P76DCH23010824N775UCDJI PHANTOM 3 PROFESSION · S/N P76DCF12016906N914NXEmbraer EMB-550 · S/N 55020190N939PHSikorsky S-92A · S/N 920202N961NXPilatus PC-12/47E · S/N 2466
Back to Hunt Valley, MD