Caledonia, MI
Registered aircraft · 38
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 = 'CALEDONIA' 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 = 'CALEDONIA' 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.
N106DRRussell Dwight R EAGLE · S/N 93-1N110RRPiper J3C-65 · S/N 19659N119DLCase Grant SPORTSMAN GS-2 · S/N 7436N167FXFX Consulting EVOLUTION · S/N EVO-0090N1773Bell 47G · S/N SA51N185RGGearhart Joseph L VANS RV-7 · S/N 70563N199CEFlight Design General Avn CTLS · S/N F-20-11-02N2267VCessna 140 · S/N 14498N2423SCessna T210L · S/N 21061275N276TBDJI AGRAS T40 · S/N 64TBL61002009GN351RVVans RV-12 · S/N 120150N359SRRamsey Stephen J RAMSEY HAWK · S/N 001N397CMCessna 510 · S/N 510-0397N4421JPiper PA-28-140 · S/N 28-22819N4468RCessna 172M · S/N 17263210N4712DCessna 182A · S/N 34812N4894MMiller Ronald R AIRDALE · S/N AIR 30473N503MMSykes Gregory MINI-MAX · S/N 001N5538UPiper PA-28-140 · S/N 28-26260N56BC56bc RV10 · S/N 42368N59HBell 47G-2 · S/N 325N6235HPiper PA-28-181 · S/N 28-7890219N637MHDJI AGRAS T40 · S/N 64TBL19002009DN64299Cessna 172M · S/N 17265150N67CNCessna 172K · S/N 17257566N699DKBeech C24R · S/N MC-552N7162QBuckeye DREAM MACHINE · S/N 5066N729KTThompson Kenneth A VANS RV-9A · S/N 91203N73GKKaminski Gary D RAF 2000 GYROPLANE · S/N H2-00-11-478N78PPPalmer James VANS RV6A · S/N 25392N7ARBell 47G · S/N WH5001N8211YPiper PA-30 · S/N 30-1338N856PBBarger Preston L RV10 · S/N 40186N871CJDJI MAVIC 2 PRO · S/N 163DFCD001W2PLN9176NPiper PA-32R-301 · S/N 3213025N934TCCessna A185F · S/N 18503026N937DBBauman Daniel W RV-9A · S/N 90237N990ASMooney M20F · S/N 680167
Back to Caledonia, MI