Fenton, MI
Registered aircraft · 56
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 = 'FENTON' 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 = 'FENTON' 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.
N1080RRaven S55A · S/N S55A-270N10MNBeech E-55 · S/N TE-831N1107BLuscombe 8A · S/N 5734N11BQAerostar International S81A · S/N S81A-3010N1459ZGrant Frownfelter GRANZAIR 100 · S/N 100N15BQCameron Balloons US A-250 · S/N 6721N179AKTextron G36 · S/N E-4101N180GSCameron Balloons US N-180 · S/N 5618N1831EAeronca 7AC · S/N 7AC5399N2052ZCessna 150C · S/N 15059852N211RDDaniels Ronald C RV7 · S/N 73358N2178DBeech D35 · S/N D-3525N2194BLuscombe 8A · S/N 6621N222DNDonald D Niles RANS S7S · S/N 1109533N222TGMcfarland William H SEA REY · S/N 1MK092N2630SCessna 337C · S/N 337-0930N273PQThunder Balloons AX7-77 · S/N 1010N2855VBeech 35 · S/N D-260N3134ACessna 170B · S/N 25778N314GFrownfelter Grant LANCAIR 320 · S/N 314N314VFrownfelter Grant VELOCITY 173 RG · S/N 1992229N3254LCessna 172H · S/N 17256154N3982LCameron Balloons US V-77 · S/N 5664N3987ARower AERO-BIPE · S/N 001N41000Raven S55A · S/N S55A-1000N4183GRaven S55A · S/N S55A-881N4357JPiper PA-28-140 · S/N 28-22735N4490APiper PA-18A · S/N 18-4856N474TBCessna 172RG · S/N 172RG0238N475PTEvolution REVOLT · S/N 001034N510GCPiper PA-23-250 · S/N 27-2681N52249Aerostar International RX 8 · S/N RX8-3324N524CCCirrus Design SR22 · S/N 9796N550NJEclipse Aerospace EA500 · S/N 550-1008N5611NBoeing A75N1(PT17) · S/N 75-8135N562DRaytheon A36 · S/N E-3577N56GHGregory J Heckler RV-6A · S/N 60523N5886BCessna 182A · S/N 33886N63196Aerostar International RAVEN S49A · S/N S49A-3009N6353TAerostar International RAVEN S-66A · S/N S66A-3046N64296Cessna 172M · S/N 17265147N648RVBarrett Larry E RV-8 · S/N 81879N7366ECessna 210 · S/N 57066N7504HPiper PA-12 · S/N 12-365N7523LCameron Balloons US A-210 · S/N 5856N7780FCessna 150F · S/N 15063880N819JKHaviland John G BRIGHT AIR 1 · S/N JK02N849BAIcon A5 · S/N 00118N9064HAerostar International S-60A · S/N S60A-3182N91104North American NAVION · S/N NAV-4-6
Back to Fenton, MI