Morgantown, WV
Registered aircraft · 50
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 = 'WV' AND g.registrant_city = 'MORGANTOWN' 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 = 'WV' AND g.registrant_city = 'MORGANTOWN' 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.
N100FACessna 150L · S/N 15072670N11814Piper J3C-65 · S/N 23048N142FBeech 95-C55 · S/N TE-221N158RFBeech 58 · S/N TH-941N1637ECessna 172N · S/N 17271077N1751UDJI AGRAS T40 · S/N 1581F574B235K00100N3N186ARCessna 150M · S/N 15077554N18752Beech 58 · S/N TH-877N213SMCessna 206H · S/N 20608206N2237APiper PA-32RT-300T · S/N 32R-7987016N2268SCessna R182 · S/N R18201317N25303Balloon Works FIREFLY 8B-15 · S/N F8B-412N2586EBalloon Works FIREFLY 7B-15 · S/N F7B-360N2611DCessna 170B · S/N 20763N3227CCessna R182 · S/N R18200258N333SHCessna 150J · S/N 15070617N34285Cessna 177B · S/N 17701750N35298Piper J5A · S/N 5-618N3578FCessna 182J · S/N 18257578N38718Piper PA-28R-201 · S/N 28R-7737111N4355FPiper PA-28-235 · S/N 28-7610097N4683LCessna 172G · S/N 17254678N475RSRaytheon HAWKER 800XP · S/N 258674N488RWLast Robert W QUICKIE Q200 · S/N 2718N50UPScottish BULLDOG MDL 120/121 · S/N BH120/328N5315TCessna 172E · S/N 17251215N55HBMoudy PITTS · S/N MB001N58HCessna 414A · S/N 414A0314N6175GCessna 172N · S/N 17273574N6735XCessna 310F · S/N 310-0035N68507Bellanca 7ACA · S/N 55-72N6FTPiper PA-32-260 · S/N 32-336N701DRobert N Eli STOL CH-701 · S/N 7-5253N70MEBeech V35B · S/N D-10123N714QSCessna 150M · S/N 15079356N720LSCook Lynn S VELOCITY ELITE · S/N DMO-383N733PYCessna 172N · S/N 17268454N734EJCessna U206G · S/N U20604828N7532NCessna TU206G · S/N U20603664N7856LBeech V35 · S/N D-8289N7959WPiper PA-28-180 · S/N 28-2008N820APTextron 182T · S/N 18283251N8315PPiper PA-24-250 · S/N 24-3565N88446Bellanca 7ECA · S/N 1064-75N88524Piper J3C-65 · S/N 16149N96TRKlenoski Brian PITTS S1-C · S/N BK2N97170Cessna 182Q · S/N 18267002N991FACameron Balloons US A-105 · S/N 5990N996MJMooney M20J · S/N 24-3390N99906Engineering & Research 415-C · S/N 2529
Back to Morgantown, WV