Battle Creek, MI
Registered aircraft · 108
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 = 'BATTLE CREEK' 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 = 'BATTLE CREEK' 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.
N100GLWaco Classic 2T-1A-2 · S/N 1215N102JVAmerican Champion 8KCAB · S/N 1128-2013N105LGJairo Dos Santos Fogaca JOB-77 · S/N JOB-0102N105PPCameron Balloons US 0-105 · S/N 6805N120WCWaco Classic YMF-F5C · S/N F5C120Registration pendingN124JTVans RV-12 · S/N 120025N126FPPowrachute AIRWOLF 912ULS · S/N A432ULSN126SCMooney M20M · S/N 270180N127YWaco RNF · S/N 3287N136AGXag P150 · S/N 186324P18223449UW624N13RTBeech P35 · S/N D-6954N140AFCirrus Design SR20 · S/N 1709N148AGXag P150 · S/N 186324P1822344301CN5N148TTPiper PA-44-180 · S/N 4496428N14LEDelano/Elfstrom LONG-EZ · S/N 1680N1515EFirefly Balloons FIREFLY 7-15 · S/N F7-2016N154WFCirrus Design SR20 · S/N 1638N156CSCirrus Design SR20 · S/N 1685N161LBLindstrand Balloons 60A · S/N 5123N162PCPiper PA-44-180 · S/N 4496429N173WMCirrus Design SR20 · S/N 1739N176CMPiper PA-44-180 · S/N 4496427N1871VCessna 172M · S/N 17263777N18JUJunkers JUNKERS A50 JUNIOR · S/N 018N190SFLindstrand Balloons 105A · S/N 5362First renewal noticeN191JGCirrus Design SR20 · S/N 1699N234MCBeech D-45 · S/N BG-411N275WAWaco Classic YMF WACO F5C · S/N F5C-8-167N28584Grumman American Avn. AA-5B · S/N AA5B0692N291USDJI AGRAS T40 · S/N 1581F574B237600100FWSale reportedN2994ECessna 172N · S/N 17271398N3001ALindstrand Balloons 69A · S/N 5071N304BBBalloon Works FIREFLY 7-15 · S/N F71012N305CSCameron Balloons ZL-84 · S/N 6858N3095TArbc Inc DBA Lindstrand 120A · S/N 5657N3258VCessna 150M · S/N 15076445N325JCBell OH-58C · S/N 71-20444Sale reportedN349RZDJI AGRAS T30 · S/N 3U5BJ6R001008KN34ECCessna T337G · S/N P3370224N3569RBeech A23 · S/N M-750N35JUJunkers JUNKERS A50 JUNIOR · S/N 035N36PLCirrus Design SR20 · S/N 1707N3807FGreat Lakes 2T-1A-2 · S/N 0775N3928FCessna 172 · S/N 36828N4010DJI AGRAS T30 · S/N 3U5BJ4K001002USale reportedN4049WCameron Balloons US N-105 · S/N 6444N409KJPiper PA-44-180 · S/N 4496523N42VRCirrus Design SR20 · S/N 1673N4330MPiper PA-12 · S/N 12-3269N445LBLindstrand Balloons 35A · S/N 5304
Back to Battle Creek, MI