Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('0191102')
ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('0191102')
ORDER BY n_numberRun 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.
N86120Resler Tyler L · Enid, OKN86122Ramirez Kyle T · Chicago, ILN86125Denniston John A · Albion, NYN86126Fisher Douglas W · Holton, KSN86131Crisler Jacob H · Alexandria, VAN86133Rousseau Chase · Amarillo, TXN86135Brown Morris J · Mc Alpin, FLN86136Laverty Russell H · Jones, OKN86140Van Horn Eric T · Linton, INN86146Wiese Andrew T · Gibsonburg, OHN86149Morison Janet Z · Ridgeway, WIN86152Bills Ricky E · Canandaigua, NYN86153Legion Airs Inc · Cliffside Park, NJRevoked, canceledN86154Wood James A · Madera, CAN86156Mulvania Rodney A · Linn, MON86158Hixssen Michael L · Anchorage, AKN86161Goatley John Edward · Springfield, KYN86165Kiefer Kenneth K · Fort Collins, CORevoked, canceledN86166Lesmeister Joseph P · Santa Maria, CAN86171Townsend Mark · San Jose, CAN86174Thomas Roy J · Tucson, AZN86175Kobberdahl Marcel A · Deerwood, MNN86176Bragg Paul L Jr · West Richland, WAN86180Vintage Props LLC · Iowa City, IAN86181Neel Bradley H · Lakeland, FLN86185Cimprich Joseph P · Camden, OHN86186Peters Raymond L · Bayfield, WIN86189Blackwell Mark E · Crowley, TXN86193Parks Reuben · Webster, SDN86195Stangl Royce M · Coon Rapids, IAN86196Pippert Jim · Dysart, IAN86203Jones Donald T Jr · Barrigada, GUN86207Godlewski John A · Ormond Beach, FLN86213Peterson Earl P · Fort Atkinson, WIN86217Lukes Landing Inc · Hernando, MSN86219Quast Felix E · Winsted, MNN86221Page Tony G · Hammon, OKN86223Stevenson George G · Scio, ORN86224See J William · Topeka, ILRevoked, canceledN86232Wasnik Richard J · Munnsville, NYN86252Reek David A · Emmett, IDN86266Anding Catherine C · Bryan, TXFirst renewal noticeN86270Curley Paul T · Wilmington, NCN86271Bouten Glenn A · Kasilof, AKN86272Turf Birds LLC · Zelienople, PAN86273Harder Alan N · Terre Haute, INN86278Veley Larry D · Chickasha, OKN86286Stewart Emerson C · Waynesville, OHN86287Hryniewicki Walter E · Jim Falls, WIN86295Houser Teddy W · Lincolnton, NC
Back to Aeronca 11AC