Mason, MI
Registered aircraft · 53
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 = 'MI' AND g.registrant_city = 'MASON' 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 = 'MI' AND g.registrant_city = 'MASON' 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.
N10439Cessna 150L · S/N 15074860N1306NBoeing E75N1 · S/N 75-5255N1454PPiper PA-23 · S/N 23-517N1491TPiper PA-28-180 · S/N 28-7205308N1855PKoons Douglas/Purosky William GLASTAR · S/N 5493N19044Cessna 150L · S/N 15074121N1932NBeech F33A · S/N CE-417N200PMMills Peter L STEEN SKYBOLT · S/N 001N2073ECessna 172N · S/N 17271144N2479FDJI AGRAS T40 · S/N 64TBK7H00100B9N2806TPiper PA-28-180 · S/N 28-7205223N2833NPiper PA-28-161 · S/N 28-7916453N31024Head Balloons AX8-88B · S/N 305N3284RPiper PA-28R-180 · S/N 28R-31261N33149Piper PA-28-151 · S/N 28-7515323N3541PPiper PA-22-150 · S/N 22-3297N40213Head Balloons AX8-88B · S/N 324N4035YAdams Balloon A55S · S/N 145N444PHRobinson Helicopter R22 BETA · S/N 1578N4502JCameron Balloons US C-80 · S/N 6315N4989RCessna 172H · S/N 17256343N50076Boeing A75N1 · S/N 75-955N5055RCessna 172M · S/N 17263295N507LSStephens A L DDS PITTS S 1C · S/N ALS001AN511LBLindstrand Balloons 90A · S/N 5034N527DBDehavilland DHC-2 MK 1 · S/N 1507N59746Boeing A75N1(PT17) · S/N 75-451N6000SAdams Balloon A55S · S/N 56C200N6088GCessna 150K · S/N 15071588N613JPPinter John M SLIPSTREAM REVLATN · S/N RE9910002N624MPHawker Siddeley BH.125-400A · S/N NA-756N62705Boeing A75N1(PT17) · S/N 75-3054N6298Curtiss Wright TRAVEL AIR C-4000 · S/N 745N7021WPiper PA-28-180 · S/N 28-703N7131YPiper PA-30 · S/N 30-153N7164YPiper PA-30 · S/N 30-185N751JDJ Vandermolen/D M Vandermolen ZENITH 750 STOL · S/N 8753N79650Boeing E75N1 · S/N 75-5770N79652North American SNJ-5 · S/N 44002N7975ZCessna 150C · S/N 15060075N7FHBeech A36 · S/N E-1142N8086GPiper PA-28-181 · S/N 28-8090084N8113MCessna 310I · S/N 310I0113N828EMMourning Samuel L DARWIN SPECIAL · S/N 001N829HTTenniswood Rod L KITFOX MODEL 3 · S/N 829N8318JCessna 150G · S/N 15066218N8356VChampion 7ECA · S/N 478N83762Piper PA-28RT-201 · S/N 28R-8118065N83PSAerotek PITTS S-2A · S/N 2143N88259Drew G Seguin CCK-2000 · S/N CCK-2000-0045
Back to Mason, MI