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.
N9539ERegistration Pending · Wickenburg, AZRegistration pendingN9540EHegarty Ryan · West Sand Lake, NYN9543EMccoy Steve C · Hinton, WVN9544EBell Steven C · Lamesa, TXN9548EPalmenteri Louis J · Rhome, TXN9552EOleary Ruth · Jacksonville, FLN9557ECleveland Lorne T · Tyler, TXN9560EShook Devin T · Fairbanks, AKN9562EAnderson Rick L · Valley City, NDN9564ERhodes Jake H · Lenoir, NCN9570EWamsley Dearle James · Trimble, MON9572EJolliff Travis · El Paso, TXN9574EKnie Dean H · Aberdeen, SDN9575EPoore Randall J · Savage, MNN9576EGreen Castle Aero Club Ltd · Oxford, IAN9581ESchelm Donald A · Omaha, NEN9586EFabian Brian L · Corcoran, MNN9592EDavis Richard · Romney, WVN9593EN82 Sport Flying LLC · Wurtsboro, NYN9595ERegistration Pending · Roosevelt, MNRegistration pendingN9598ETomlin R H · Burleson, TXN9604EWatson Bobby M · Hoxie, ARN9608EJackson Lee R · Baldwinsville, NYN9615ECohutta Aviators LLC · Milton, FLN9621ELootens Charles W · Mansfield, OHN9622SRezek James P · Two Rivers, WIN9625EStahl Thomas E · Chula Vista, CAN9627EPasco Gary R · Brockport, NYN9629EHenkelmann David H · Janesville, WIN9633EHartman Thomas · Peru, ILN9636ETaylor Sophia · Urbana, OHN9641ELoudon Philip G · Fairbanks, AKN9645EWalsemann Brent M · Carthage, NYN9646EEmbree Walter G · Harrisonburg, VAN9647EEvans Mark O · Dover, ARN9650EWalton John F · Hesperia, CAN9651EMacveigh Craig A · New Carlisle, OHN9654EAlbij3 LLC · Milton, FLN9658EPrivitt Bret J · Fort Worth, TXN9659EFrick Gary A Trustee · Marion, INN9660EHoffman Allen D Sr · Cheboygan, MIN9661ECard Donald J · Dallas, TXN9662EEnnenga Robert B · Grand Haven, MIN9665EFurnas Jerry W · San Diego, CAN9675EJersey George H · Cold Brook, NYN9677EBoyd Jeff · Justin, TXN9681EDaniel Stephen Clay · Decatur, GAN9684EArcher William P · Wapato, WAN9692ESeever James J · Holmen, WIN9700ESeal Jerry W · Westlake, LA
Back to Aeronca 11AC