Lusby, MD
Registered aircraft · 31
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 = 'LUSBY' 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 = 'LUSBY' 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.
N107DRDaniel C Schneider JR DR-107 · S/N 94-0200N11HRPiper PA-34-200T · S/N 34-7970233N134TGProgressive Aerodyne SEAREY LSA · S/N 1072N16182Stinson SR-8C · S/N 9756N19KSSmith Kent R RV-9A · S/N 90214N22GWTemco GC-1B · S/N 3726N2356UCessna 172D · S/N 17249956N24611Piper PA-38-112 · S/N 38-79A1137N26057Piper J3C-65 · S/N 3999N26383Sidney M Wood JR CHALLENGER II LSS · S/N CH2-0507-LSS-0128N28188Piper J3C-65 · S/N 4638N2917SCessna 150G · S/N 15066817N29TPPatric Thomas L RV-8 · S/N 80547N31899Aeronca 65-CA · S/N CA-11981N36MTAviat PITTS S-2B · S/N 5324N4563KRyan NAVION A · S/N NAV-4-1563N48044Dehavilland DHC-1 CHIPMUNK · S/N WD-384N4822NCessna 182Q · S/N 18267394N4LBaumgartner PITTS S-1 · S/N 151-HN5356TCessna 172E · S/N 17251256N5736UPiper PA-28-140 · S/N 28-26552N69211John Nelson RV-8 · S/N 81632N7003VBolkow BOLKOW JUNIOR 208 · S/N 540ZN7046NBeech V35A · S/N D-8634N784SRProgressive Aerodyne SEAREY LSA · S/N 1055N8453UCessna 172F · S/N 17252353N8GDDe Lort WITTMAN TAILWIND W-8 · S/N 243N909MHBritish Aerospace HARRIER T8 · S/N 212046N911UTBeech 95-B55 (T42A) · S/N TC-928N9158VMooney M20F · S/N 690040N94422British Aerospace SEA HARRIER FA2 · S/N XZ439
Back to Lusby, MD