Frederick, MD
Registered aircraft · 100
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 = 'FREDERICK' 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 = 'FREDERICK' 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.
N503WBell 206B · S/N 823N528MJCessna 182T · S/N 18280991N52RFAviat A-1C-200 · S/N 3440N53010Cessna 172P · S/N 17274659First renewal noticeN530DCPiper PA 46-350P · S/N 4636690N531Beech D35 · S/N D-3676N5323PCessna 150L · S/N 15073223N5447KCessna 172P · S/N 17274114N54858Piper PA-23-250 · S/N 27-7554158N55198Fairchild M-62C(PT-23A) · S/N T43-5482N56PECirrus Design SR22 · S/N 3634N5845PPiper PA-24-250 · S/N 24-926N60CKBombardier BD-100-1A10 · S/N 20512N60KKCostruzioni Aeronautiche Tecna P2006T · S/N 296/USN61DDCessna 340A · S/N 340A1037N6392GCessna 172N · S/N 17273592N6437LAmerican AA-1A · S/N AA1A-0437N65329Cessna 172S · S/N 172S9702N65JWVans RV-12 · S/N 12055N664PBCessna 182S · S/N 18280156N70596Piper J3C-65 · S/N 17606N70800Cessna 182M · S/N 18259367N710PXEPP Ron VANS RV-8 · S/N 81788N717VCCalo Robert V VANS RV-7A · S/N 70230N72664Cessna 172R · S/N 17280818N75229Piper PA-28-140 · S/N 28-7625208N76617Cessna 140 · S/N 11057N77312Cessna 120 · S/N 11754N7782SSchweizer SGS 2-33A · S/N 152N7799ZPiper PA-25-235 · S/N 25-4002N801SPDG Flugzeugbau DG-808 S · S/N 8-301S57X4N8027LCessna 172H · S/N 17256227N82096Piper PA-18-150 · S/N 18-7909053N85EXVan Lehn Richard Glenn HATZ CLASSIC · S/N 194N8658LPiper PA-25-235 · S/N 25-5104N8897UCessna 150M · S/N 15078018N899MAAlexander Schleicher ASK 21 · S/N 21945N899SAAlexander Schleicher ASK 21 · S/N 21946N9163SBeech C23 · S/N M-1778Registration pendingN9307SBeech B24R · S/N MC-337N9311JPiper PA-28-180 · S/N 28-3404N9344PPiper PA-24-260 · S/N 24-4843N936BGBurkhart Grob Flugzeugbau G102 CLUB ASTIR IIIB · S/N 5649CBN937SACessna 172S · S/N 172S9377N93BSReese David PITTS SPECIAL S-1-C · S/N PDR-1N9548UGrumman American Avn. AA-1C · S/N AA1C0044N954JACessna 172S · S/N 172S10500N9979CCessna R182 · S/N R18200495N998EKCirrus Design SR22 · S/N 4353N9WRBeech B200 · S/N BB-913
Back to Frederick, MD