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.
N71386Single Engine Flyers LLC · Fredericksburg, TXN71397Turner Chris · Kosse, TXN71398Koch Jon P · Menahga, MNN713SMJa Williams Investments LLC · Austin, TXN71400Wubben Robert C · Waupaca, WIN71405Bowes John Michael · Lake City, FLN71408Emerald Darin · Springerville, AZN71420Yeti Aviations LLC · Madison, ALN71450Ejs Enterprises Inc · Three Forks, MTN71452Blay Jeffrey E · Oak Harbor, OHN71462Shaffer Jessie J · Peyton, CON71463Rodrigo Jodi L · Orland, CAN71484Noss David L Jr · Hominy, OKN71491Kelley Philip W · Titus, ALN71494Neverland LLC · Emerson, IAN71511Jochl Kimberley · Sugar Mountain, NCFirst renewal noticeN71514Slater Richard · Graham, WAN71518Northern Arizona 182 Flying Guys LLC · Flagstaff, AZN71538Grier Curtis · Lake Havasu City, AZN71551Aivcon Inc · Charlevoix, MIN71560Kansas State University Parachute Club · Manhattan, KSN71569Ziegler Andrew J · Clyde, OHN71573Steed David A · Oklahoma City, OKN71582Papon Bruce G · Hardtner, KSN71583Zidek Lawrence Paul · Onaga, KSN71584Burris Joshua William · Maiden, NCN71587Bynum Jerry R · San Angelo, TXN71589Carr Mark F · Anchorage, AKN71595Registration Pending · Nampa, IDRegistration pendingN71598Watkins William G IV · Aptos, CAN71607Hamby Robert Eidson · Martin, GAN71610Bowyer Steele · Long Beach, CAN71614Naylor Scott Trustee · Salinas, CAN71616Summit Helicopters Inc · Salem, VAN71621Skyward Bound Associates Ltd · Newark, DEN71622Gabrielson Richard A · Lyons, CON71623Bond Kevin · Sandy, UTN71624Tyler Terry Lynn Trustee · Tulsa, OKN71626Terwilliger Ron · Belton, MON71634Hester Daniel R · Stokesdale, NCN71637Schneider Gregory P · Laguna Beach, CAN71638Fisher Logan S · Rudyard, MTN71640Thom Derek · Peck, MIN71641Fortenberry Aviation LLC · Crossville, ALN71651J2k Fly By Night LLC · Hickman, NEN71652Leftovers Aviation LLC · Reno, NVN71655Starr Digital Technologies Inc · Medina, OHN71656Kindsvater Harold E · Boulder City, NVN71659Monroe Belle LLC · Greensboro, GAN71665Misener Mark J · Central Point, OR
Back to Cessna 182M