Zeeland, 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 = 'ZEELAND' 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 = 'ZEELAND' 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.
N100JVJV Air VANS RV-10 · S/N 40992N1144LLake LA-4 · S/N 306N1465JRockwell International 112A · S/N 465N18163Cessna 150L · S/N 15073835N18LTPhilip R Cook ZENITH 750 CRUZER · S/N C75-10537N199NADJI AGRAS T50 · S/N 63YBLAM002002HN2526LLancair LC41-550FG · S/N 41035N326ABGary Kremers CCK-2000 · S/N CCK-2000-0118N330CMHughes 369A · S/N 291060N3332Dahlman Francis G BEDE BD-4 · S/N 25N335JJCessna 525A · S/N 525A0162N34128Commonwealth 185 · S/N 1838N348STTakas Stephen P BD-4 · S/N 529N34978Infinity Powered Parachutesllc COMMANDER · S/N A-308INFN34GDBell UH-1H · S/N 66-16345N351ECBombardier BD-100-1A10 · S/N 20625N352ECBombardier BD-100-1A10 · S/N 21072N352GGrimes Andrew D ANDERSON KINGFISHER · S/N SKF97-1N352JACessna LC42-550FG · S/N 421005N3753EAeronca 7AC · S/N 7AC-7042N37PDDannenberg Paul MONOCUB · S/N 001N38WBeech H-18 · S/N BA-580N3942WPiper PA-32-260 · S/N 32-931N3GTMitsubishi MU-2B-25 · S/N 277N4375FPiper PA-28-140 · S/N 28-7725012N44167Piper PA-28-151 · S/N 28-7415594N503JNSchweizer 269C-1 · S/N 0104N521XLLiberty Aerospace LIBERTY XL-2 · S/N 0018N52394Piper PA-31-310 · S/N 31-7401207N53525Cessna 337G · S/N 33701682N5474PPiper PA-24-250 · S/N 24-531N563SBPiper PA-28R-200 · S/N 28R-7335429N591XLLiberty Aerospace LIBERTY XL-2 · S/N 0075N60662Air Tractor AT-402A · S/N 402A-0968N621NTCirrus Design SR20 · S/N 1679N6561FCessna 150F · S/N 15063161N6889GCessna 150L · S/N 15072389N700BVSmith AEROSTAR 601P · S/N 61P-0448-171N71WEVerduin William D RV-7 · S/N 73043N738TGCessna 172N · S/N 17270220N7430YPiper PA-30 · S/N 30-491N7471KPiper PA-20 · S/N 20-384N7594TCessna 172A · S/N 47194N817MPCessna 525A · S/N 525A0238N822REPiper PA-22-108 · S/N 22-9802N827RPCessna P210N · S/N P21000541N828PBCessna 182Q · S/N 18265926N844WCirrus Design SR22 · S/N 3158N9107FHughes 369HS · S/N 320370SN9184EAeronca 11AC · S/N 11AC-818
Back to Zeeland, MI