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 ('2210406')
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 ('2210406')
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.
N16PMRiordan James · Kanab, UTN176WWRegistered aircraftN177AJPnw Tin Goose LLC · Liberty Lake, WAN177AKBrockman Kenneth E Jr · Iliamna, AKN178WWRegistered aircraftN179AMNorth American Flight Services Inc · Ballston Spa, NYN17MRLarsen John L · Excelsior, MNN17WKOhnigian Steven P · Castle Rock, CON180CAGrosslight Greg · Afton, WYN180HYEms Ronald D · Portland, ORN187AMDh Aviation Products LLC · Missoula, MTN188DSCopper River Airmotive LLC · Copper Center, AKN189LSSeno Louis C Jr · Ponce Inlet, FLN18WACarmel Christopher F · Bozeman, MTN191DHLee Kevin B · Beulah, NDN193CVarney Gary W · Turner, MEN199AMVeterinary Imaging Solutions Inc · Davis, CAN199STRandle Jan O · Lenoir, NCN200HHKa Corp · Libby, MTN200HYFly Yawa Aviation LLC · Statesboro, GAN204MATsiu LLC · Wilmington, DEN2073XAnania Nickolas F · West Ossipee, NHN20HYTack John A · Wasilla, AKN217RAVinci Frank L · Dallas, TXN21HYHunkus Kenneth F · San Angelo, TXN222HUPlane Nutz LLC · Sugar City, IDN222HYWarner Robins Air Service Inc · Cochran, GAN225AKSkywagon Ventures LLC · Chapel Hill, NCN22ZHBrookway Aviation LLC · Brookhaven, MSN230WChandler Charles G · Luray, VAN233FCjk Inc · Lafayette, CON233HYTen Mile Ranch Inc · Vale, ORN234HYMcleran Ralph Charles · Novato, CAN237HYZeus Flight LLC · Ketchum, IDN242AMZike Jay N · Lindsay, CAN243CYHarvey Steven T · Honolulu, HIN249DGRegistered aircraftN24ZCNau Thomas W · San Antonio, TXN250MALc Flyers LLC · Monument, ORN252UWyatt Gregory P · Cheyenne, WYN256AMEdwards Bruce D · Georgiana, ALN256JMWieland Joachim H · Vancouver, WAN258CVandelay Industries I Inc · Wilmington, DEN25ASMolek Jon · Warren, OHN25HYFirst Airplane LLC · Eden Prairie, MNN25WADesiati Sergio · Belen, NMN262AMChapman Kevin Joseph · Williston, NDN263ALEvans Randall B Trustee · Fallon, NVN26HYFocus Air LLC · Wilmington, DEN26VMLyons Hal · Merrill, NY
Back to Aviat A-1B