Jackson, MI
Registered aircraft · 106
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 = 'JACKSON' 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 = 'JACKSON' 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.
N45251Cameron Balloons US V-77 · S/N 5893N45APHurst Anthony P RAF 2000 · S/N H2-92-3-54N4685FCessna P206A · S/N P206-0285N46WHPiper PA 46-350P · S/N 4622141N4922BCessna 152 · S/N 15283706N49RDPiper PA-23-250 · S/N 27-3192N504EEXag P100 PRO · S/N 8219418Q3Y02N5140ACessna 172 · S/N 28140N51571Maule M-5-210C · S/N 6026CN51636Maule M-5-210C · S/N 6045CN523PDPiper PA-31T1 · S/N 31T-7904044N5422SPiper PA-28-140 · S/N 28-7125118N5614WPiper PA-28-160 · S/N 28-754N56224Piper PA-28-180 · S/N 28-7305554N578FLPiper PA-28-140 · S/N 28-7125430N5877FPiper PA-28-151 · S/N 28-7715155N58BSBeech 58 · S/N TH-1142N60032Cessna 150J · S/N 15070019N620WSRandy J Wilhite WS600 · S/N 001N626WDRans S-6LS · S/N 05071809-LSAN63858Beech 58 · S/N TH-1360N66ADBeech B90 · S/N LJ-380N674BBeech A35 · S/N D-1675N68812Cessna 152 · S/N 15285339N68APBeech V35A · S/N D-8899N69263Grumman G-21A · S/N 1132N70414Piper J3C-65 · S/N 17405N706FNBalony Kubicek Spol Sro BB26Z · S/N 1017N739HXCessna 172N · S/N 17270566N73APHurst A P SUMMIT 23 · S/N 9202N744JKMillard Kenneth L CH650B · S/N 10482N7491Grumman G-44 · S/N 1240N750JSTimothy J Sparks STOL CH 750 · S/N 75-8217N750TZSparks Timothy J CH 750 CRUZER · S/N 75-10076N757MPCessna 152 · S/N 15279851N7700RCameron Balloons US Z-77 · S/N 6559N78846Cessna 172K · S/N 17257788N800TYCessna 152 · S/N 15282202N8019QBuckeye DREAM MACHINE · S/N 4641N805NDCameron Balloons ZL-84 · S/N 6755N81142Funk B85C · S/N 272N819PPInfinity Power Parachutes CLASSIC · S/N A189 INFN81BBBeech F33A · S/N CE-449N8263EPiper PA-32-301T · S/N 32-8024046N844CSBeech V35B · S/N D-9247N85948Aeronca 11AC · S/N 11AC-360N86051Aeronca 11AC · S/N 11AC-471N862DWHonda HA-420 · S/N 42000283N9074UGrumman G-21A · S/N 1129N928SVCirrus Design SR20 · S/N 10635
Back to Jackson, MI