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 ('2072606')
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 ('2072606')
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.
N5194E4d Aviation LLC · Gilbert, AZN5199ESnowden Andrea K · Anchorage, AKN5200EViaene Tajae L · Fargo, NDFirst renewal noticeN5205EGates Stephanie E · Sutton, AKN5208EHelmericks Mark H · Anchorage, AKN5220EMcgee Kirk S · Anchorage, AKN5222ESmith Nathan C · Kenai, AKN5225ERowland Taylor · Wasilla, AKN5237ENvision Technology LLC · Turtle Lake, WIN5242EWeeks Charles C · Setauket, NYN5248EColorado Skywagon LLC · Kiowa, CON5259ECole Charles · Las Vegas, NVN5269ERocky Pointe Logistics LLC · Hayden, IDN526PLEdson Aviation Group LLC · Jericho, VTN5273EDaniels Ronald H · Delton, MIN5274EFedermann Joe R · Anchorage, AKN5275EPasiewicz Shannon M · Anchorage, AKN5291TGodin David M · Levant, MEN5298EDunlap Russell M · Palmer, AKN59180Kennedy Jared W · Cordova, AKN59KMMatthews Casey D · Fort Worth, TXN59MPPilch Michael Joseph · Sheridan, WYN674MPhillips Joseph H · Anchorage, AKN67DVArizona Airplay LLC · Somerton, AZN7551Delash John M · Williamson, GAN846TLefebvre Kyle · Nome, AKN880CKOlson Craig J · Bettendorf, IAN8BJWanner Thomas J · Mound, MNN9100TRegistered aircraftN9104TPeninsula Aeroworks LLC · Fife, WAN9117TMichaud Paul K · Forest Lake, MNN9118THagen Bruce L · Reeder, NDN9122TWerth Lance C · Johnson Lake, NEN9126TLawrence David A · Auburn, WAN9130TThompson Dennis P · Spokane, WAN9136TMarble Jere D · Dayton, NVN9138TKnopp Steven L · Camano Island, WAN9142TLjungkvist Kristian · Ashland, ORN9154TLethal Aviation LLC · Kalispell, MTN91PCChay Dan B · Kenai, AKN929AEColman Steve · Alamosa, CON93QDurtschi James Werner · Sisters, ORN985DBAbidance Inc · Winthrop, WAN99DDLussier John A · Greene, RI
Back to Cessna 180B