Easton, MD
Registered aircraft · 39
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 = 'EASTON' 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 = 'EASTON' 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.
N115MCStinson 10A · S/N 7781N204NGCirrus Design SR20 · S/N 2271N2081CPiper PA-28-161 · S/N 28-7916128N21167Piper PA-28-161 · S/N 28-7916028N211ECDassault-Breguet FALCON 10 · S/N 166N211TAIsrael Aircraft Industries GULFSTREAM G150 · S/N 223N2194DBeech D35 · S/N D-3541N248PCCirrus Design SR20 · S/N 2287N273QBeech 95-B55 (T42A) · S/N TC-1020N27NGHonda HA-420 · S/N 42000027N301AGDJI INSPIRE 2 · S/N 09YDE6UL040192N30SDSocata TB 30 EPSILON · S/N 89N315HRExtra Flugzeugproduktions-Und EA 300/LT · S/N LT033N3289QPiper PA-28-161 · S/N 28-7716146N32990Piper PA-28-151 · S/N 28-7515285N33576Piper J3C-65 · S/N 14053N34VYBeech D-45 · S/N BG-41N36583Piper PA-28-161 · S/N 28-7816647N36CDHawker Beechcraft HAWKER 900XP · S/N HA-0180N379ZFlightstar SLII · S/N 9230601-24N4098JCessna 150G · S/N 15065398N47882Piper PA-28-161 · S/N 28-7816152N48HUAviat A-1C-200 · S/N 3438N524NDiamond Aircraft Ind DA 40 · S/N 40.235N5343FPiper PA-28-151 · S/N 28-7715103N604ECBritish Aerospace BAE JETSTREAM 3101 · S/N 646N615DACirrus Design SR20 · S/N 1853N630CDCirrus Design SR22 · S/N 0962N6667FPiper PA-28-151 · S/N 28-7715174N707BGGerman William Brian KITFOX MODEL 4 · S/N 1470N766HKDassault-Breguet FALCON 50 · S/N 161N8223TPiper PA-28-161 · S/N 28-8216170N831JSBritish Aerospace BAE JETSTREAM 3101 · S/N 716N8345ZPiper PA-28-161 · S/N 28-8116167N8394DPiper PA-28-161 · S/N 28-8116238N909PTBoeing PT-17 · S/N 75-4246N9163ZPiper PA-28-161 · S/N 2841056N96MBTextron C90GTI · S/N LJ-2157N972MACessna 150H · S/N 15067551
Back to Easton, MD