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 ('0191006')
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 ('0191006')
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.
N47373Cavanaugh Flight Museum · Denison, TXN47421Colby Austin Baker · Hagerstown, MDN47427Museum Of Flight Foundation · Seattle, WAN47474Lequire Wayne A · Maryville, TNN47500Jackson Robert J · Ranger, TXN47502Bowles Christian · Taylorsville, NCN47503Beckman Jeffrey A · Temecula, CAN47520Shepard Logan K · Kent, WAFirst renewal noticeN47523Deaero LLC · Darwin, MNN47602Tollett Thomas V · Sunrise Beach, TXN47608Mid Atlantic Air Museum · Reading, PAN47668Steel Alan P · Odessa, TXN47751Western Antique Aeroplane & Automobile Museum · Hood River, ORN47811Plummer Derwin W · Cordele, GAN48014Warbirds Squadron #32 Inc · Oshkosh, WIN48053Johnson Scott J · Oshkosh, WIN48078Vaughn Macia J · Ione, CAN48094Goggans Danny · Sulphur Springs, TXN48118Registration Pending · Valparaiso, INRegistration pendingN48145Port Townsend Aero Museum · Port Townsend, WAN48218Hopper Raymond L · Strafford, MON48295Mean Green Flying Machines LLC · Logan, OHN48297Oliver Frank E · Albany, ORN48341Herzog Eric M · New Waverly, TXN48434Ross Frank L Jr · Marcellus, MIN48441Tate James S Jr · Nashville, TNN48530Wiser Tony J · Goodyear, AZN48536Grismer Jeff Trustee · Hemet, CAN48540Obrien Robert · Cape Neddick, MEN48620Capital Aviation Group LLC · Alexandria, VAN48648Hall M Richard · Aliquippa, PAN48653Wallin Joshua M · Moreno Valley, CAN48656Kreloff Richard L · Cathedral City, CAN48657Etchell Bruce R · Healdsburg, CAN48660Collins Timothy L · Spring Creek, NVN48661Dent Janice L · Plantation, FLN48662Lanham Rex E · Boise, IDN48709Franke Nicholas · Jacksonville, ARN48716Colby Don · Kingman, AZN48807Mock John L · Fullerton, CAN48814Olsen Cherrine · Sacramento, CARevoked, canceledN48844Hardy Theodore A · Carson City, NVRevoked, canceledN48853Hoag Michael R · Three Rivers, MIN48859Eason David A · Eugene, ORN48910Mee Cliff F · Thayne, WYN48936Anderson A James · Denton, TXN48954Waterman David K · Temple City, CAN49001Ferris Harry R · Marengo, ILN49012Barlow Michael J · Central Point, ORN49015Stewart Dan R · Cashmere, WA
Back to Aeronca 0-58B