Registered aircraft · 23

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'IL' AND g.registrant_city = 'MCHENRY' ORDER BY g.n_number

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 = 'IL' AND g.registrant_city = 'MCHENRY'
  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 = 'IL' AND g.registrant_city = 'MCHENRY'
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.

N1748TPiper PA-28-140 · S/N 28-7125066Built 1970 · Ballard George M N2040BLane Robert SEA REY · S/N 1MK045Built 1997 · Swanson Alan J N2157J&J Ultralights SEA WING · S/N 2157Built 2000 · Schams Gregory P N237SBeech S35 · S/N D-7841Built 1965 · Coley Douglas E N2504CCessna 170B · S/N 26148Built 1954 · Hain Walter J N252WAPiper PA-34-200T · S/N 34-8070211Built 1980 · Bettendorf Nicholas L N28642Fairchild 24W-40 · S/N W40-162Van Buren Karen A N30571Cessna 177A · S/N 17701334Spencer Burton D N31067Piper J3C-65 · S/N 5293Marinangel Kathleen E Executrix N31679Waco VKS-7F · S/N 6120Marinangel Kathleen E Executrix N329JGAircraft Mfg & Development CH601XL SLSA · S/N 601-025SBuilt 2006 · Hernandez Jesus N33387Commonwealth REARWIN 185 · S/N 1608Van Buren Karen A N34BQBeech T-34B · S/N 144025Built 1957 · Bettendorf Nicholas L N439PTPiper PA-34-200 · S/N 34-7450179Built 1974 · Knot Mach LLC N529SARaytheon A36 · S/N E-3429Built 2001 · Raptorsair LLC N55PNPiper PA-28-151 · S/N 28-7415251Built 1974 · Knot Mach LLC N59BBateman John R F-1 · S/N 009Bateman John R N62070Maule M-5-210C · S/N 6092CBuilt 1975 · Wydra Richard J Jr N7182RPiper PA-28-140 · S/N 28-21894Built 1966 · Stl Aviation LLC N727GMRolladen-Schneider OHG LS3-A · S/N 3152Molidor Gerald C Jr N7567GCessna 172L · S/N 17259267Built 1970 · Whipple Eugene B N9173CCessna R182 · S/N R18200436Built 1978 · Bettendorf Nicholas L N9977CPiper PA-28-140 · S/N 28-7225525Built 1972 · Schuster Jacob M

Back to Mchenry, IL