Bel Air, MD
Registered aircraft · 29
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 = 'BEL AIR' 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 = 'BEL AIR' 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.
N1222EAeronca 7AC · S/N 7AC-4780N136AVPiper PA-28-181 · S/N 28-8590004N1808MCessna 170B · S/N 25952N240WBColt Balloons 240A · S/N 673N2638PDJI AGRAS T40 · S/N 52LBL6M002001AN264ADDJI AGRAS T40 · S/N 52LBL6M002001RN2758ALankford Edwin E QUICKSILVER SPORT II · S/N 1080759N29836Taylorcraft BC12-65 · S/N 2687First renewal noticeN3587BAerostar International S-60A · S/N S60A-3133N4339WPiper PA-32R-301 · S/N 32R-8413008N4515FPiper PA-32R-300 · S/N 32R-7680456N4521PDJI AGRAS T50 · S/N 63YBM4L002008NN5296LAerostar International RXS-8 · S/N RXS8-3107N6129GCessna 150K · S/N 15071629N6409VAerostar International RX-7 · S/N RX7-3037N6453KAerostar International S-60A · S/N S60A-3045N6484EAerostar International RX-7 · S/N RX7-3100N65850Aerostar International S-66A · S/N S66A-3023N7097BAerostar International RXS-8 · S/N RXS8-3047N713KMKelley G Martin SLING TSI · S/N 441SKN7827UCessna 172F · S/N 17251827N7846NPiper PA-28-180 · S/N 28-5302N84246Aeronca 7AC · S/N 7AC-2938N875PJTextron 182T · S/N 18282460N8986UCessna 150M · S/N 15078036N90653Piper J3C-65 · S/N 20086N9254WPiper PA-28-235 · S/N 28-10926N9380MMooney M20F · S/N 670004N9BWMooney M20J · S/N 24-1513
Back to Bel Air, MD