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 ('2072728')
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 ('2072728')
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.
N91705Gerbick Dean · Lena, ILN91718Miklos Russ · Youngstown, OHN91721Scott Dennis E · Wake Forest, NCN91722Ken-Oh Transportation LLC · Porter, INN91726Kcsi Aerial Patrol Inc · Bakersfield, CAN91730Meints Larry W · Altahoma, CAN91748Ad Venture Sales LLC · Wilmington, DEN91749Skydive Northstar LLC · Mankato, MNN91753Pope Lucas B · Hayden, IDN91759Parker Michael F · Leesburg, VAN91767Mcclary Guy E Jr · Darlington, SCN91771Whitt Horace M · Edgewood, NMN91775Kcsi Aerial Patrol Inc · Bakersfield, CAN91789Bell Barbara A · Gilbert, AZN91790Hill Benjamin L · Hollywood, FLN91791Cessna N91791 Inc · Saginaw, MIN91795Avco Patrol LLC · Lyndon, KSN91799Turner Ryan J · Pittsburg, TXN91802Jones Bernard H Jr · Pendleton, SCN91803Legacy 1 Aviation LLC · Canton, OHN91804Dreau Air LLC · Flandreau, SDN91816Garrett Douglas D · Granbury, TXN91831Sides Matthew E · Lonoke, ARN91835Page Farms Inc · Natchitoches, LAN91844Brandt Kurtis L · Susanville, CAN91845Broderick Donald S · S San Fran, CAN91846Bas Part Sales LLC · Greeley, CON91852Kennon Wesley F · Doniphan, MON91860Ransom Bob · Pasco, WAN91866Weldon Jeffrey A · Anacortes, WAN91868V12 Enterprises LLC · Niceville, FLN918CTBlinn Gilbert Trustee · Eastsound, WAN91900Lewis Jeery K · Cocolalla, IDN91907Skierka Christopher · Browning, MTN91912Champagne Estates Inc · Wilmington, DEN91916Hanson Larry G · Seattle, WAN91917Paul William D · Twin Falls, IDN91926Pacific Flying Association LLC · Aurora, ORN91928Moseley Michael S · Chelsea, ALN91937Munsell Kenneth L · Stuart, FLN91941West Debra C · Dillon, CON91942Marvelous Margies Flying Club LLC · Helper, UTN91950Bruno Cosimo Gino · Spokane, WAN91958Greenwood Richard S · Duncan, OKN91963Justpullin Inc · Wilmington, DEN91976Tucker Bobby G · El Dorado, ARN91978Dvorak Ross E · Highland, CAN91987Sander William D · Eaton, CON91999Gembala Randall L · Kalispell, MTN92000Clift Robert E · Anchorage, AK
Back to Cessna 182M