Jackson, MI
Registered aircraft · 105
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.
N10BQGrumman G-44 · S/N 1327N1109BLuscombe 8E · S/N 5736N131TUCostruzioni Aeronautiche Tecna P2008 · S/N 131N13897Waco UKC · S/N 3842N150HCessna 150F · S/N 15063910N15ZSZephyr Systems ARK-350 · S/N 2022001N172VWCessna 172C · S/N 17249058N1802ZCessna 210-5 · S/N 205-0002N1804WBeech E-55 · S/N TE-893N1RJHonda HA-420 · S/N 42000109N213KFKraus Michael D KITFOX SS7 · S/N KA12148232N216PKPacific Aerospace 750XL · S/N 114N2227RPiper PA-28-181 · S/N 28-7990309N22378Aeronca 65-C · S/N C-3509N233RSSchneider Raymond E HORIZON II · S/N 110323N23537Aeronca 65-C · S/N C4809N23586Aeronca 65-C · S/N C-5509N23599Aeronca 65-C · S/N C5599N2419LCessna 172H · S/N 17255619N2422RCessna 182G · S/N 18255522N24DSDaniel J Stanton CH 750 ZENITH · S/N 10308N26338Aeronca 65-C · S/N C8040N2644RCessna 182K · S/N 18258344N287EBBellanca 7ECA · S/N 1265-78N2995ACameron Balloons US O-84 · S/N 5157N2995DCessna 170B · S/N 26938N2QGCessna 680 · S/N 680-0231N300LHHoffman Lawrence J RV-14A · S/N 141314N30369Piper J3C-65 · S/N 4817N304JEEiler John Edward HARMON ROCKET II · S/N 321N304PPPowrachute AIRWOLF 912ULS · S/N A448ULSN3078WFantasy Air Sro ALLEGRO 2000 · S/N 06-222N308EBBack Garry S-21 OUTBOUND · S/N 11200145N3123YCessna 182E · S/N 18254123N333JXLockheed T-33 · S/N 58-509N3540TCessna 172R · S/N 17281077N3544BCessna 172R · S/N 17281071N361QBDJI AGRAS T50 · S/N 1581F6BUB245M001LKV5N36497Aerostar International RX-7 · S/N RX7-3258N3741RCessna 172H · S/N 17255541N377XCirrus Design SR22T · S/N 0298N3806FGreat Lakes 2T-1A-2 · S/N 0774N3996CCameron Balloons US V-90 · S/N 5619N4034AAdams Balloon A55S · S/N 140N416EMBoeing PT-17 · S/N 75-519N4283TPiper PA-28-140 · S/N 28-7225120N4489PBeech N35 · S/N D-6769N4494TXag P100 PRO · S/N 821942537E1QN44VWGrumman G-44A · S/N 1408N45251Cameron Balloons US V-77 · S/N 5893
Back to Jackson, MI