Gaithersburg, MD
Registered aircraft · 66
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 = 'GAITHERSBURG' 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 = 'GAITHERSBURG' 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.
N108BDScottish SERIES 100 MDL 101 · S/N 108N1157TBeech A36 · S/N E-640N122SStorch John L DEVIOUS · S/N DS-1N1230XMooney M20E · S/N 104N12973Cessna 172M · S/N 17262418N13573Cessna 172M · S/N 17262856N13796Cessna 172M · S/N 17263006N146AVPiper PA-28 · S/N 28-8590010N1519TPiper PA-34-200 · S/N 34-7250337N184MRMark Ross RV-8 · S/N 82212N18JCHelio HT-295 · S/N 1719N1933FCessna 172N · S/N 17273023N20283Cessna 172M · S/N 17261157N20300Cessna 177B · S/N 17702656N2042BBeech V35B · S/N D-10185N205PLMooney M20J · S/N 24-3020N2172DPiper PA-28-161 · S/N 28-7916147N21803Piper PA-28-181 · S/N 28-7990060N2255HCessna T206H · S/N T20608738N23GVCessna 172M · S/N 17264594N2461DCessna 206H · S/N 20608295N2462GCessna 206H · S/N 20608296N249WFPiper PA-28-181 · S/N 28-7690114N251WFPiper PA-28-181 · S/N 287990548N2621ZCessna 172R · S/N 17280559N28250Gulfstream American AA-5B · S/N AA5B0968N2927QPiper PA-28R-201 · S/N 28R-7737043N3020MPiper PA-44-180 · S/N 44-7995220N302VMPiper PA-44-180 · S/N 44-7995322N3054TPiper PA-28-181 · S/N 28-7990325N30YRCessna 172R · S/N 17280043N340PAPiper PA-28-181 · S/N 2843516N34HDCessna 172P · S/N 17276259N363MBRaytheon A36 · S/N E-3143N369PPCessna 172M · S/N 17263099N3703WPiper PA-32-260 · S/N 32-616N38657Piper PA-28-181 · S/N 28-7790574N4366HPiper PA-15 · S/N 15-151N44441Cessna 182K · S/N 18258015N505LPCessna 172S · S/N 172S8546N5157KCessna 172N · S/N 17273993N5215ECessna 172N · S/N 17271774N5244NCessna 182Q · S/N 18267594N5387GHelio HT-295 · S/N 1257N5405VCessna R172K · S/N R1722294N5624KBeech S35 · S/N D-7382N586MAPiper PA-28-181 · S/N 2843297N6269DCessna 172N · S/N 17272680N678RDStinson 108-2 · S/N 108-2598N6964HCessna 172M · S/N 17265668
Back to Gaithersburg, MD