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.
N788PWilliam Earl Dixon LLC · Lumberton, NCN7901PTwo Brothers LLC · Helena, MTN7DLWubben Robert · Waupaca, WIN8002KTrepanier Dennis A · Santa Fe Springs, CAN82CTCoelho Gabriel P · Chowchilla, CAN831DC831 Aviators LLC · Monterey, CAN865PHPhe Inc · Roseville, CAN868LBPatriot Leasing LLC · Abilene, TXN869JRRiver City Flying Club · Glen Allen, VAN900EDSpradling James · Fremont, OHN901PWFlywerx LLC · Anchor Point, AKN90BCSkypilot Aviation Ltd · Mcmurray, PAN90PFBas Part Sales LLC · Greeley, CON91508Stewart Bryan P · Carson City, NVN91509Watts Timothy R · Hermiston, ORN91510Registration Pending · Eagle River, AKRegistration pendingN91513Attactix Aviation LLC · Tucson, AZN91515Bulkley Gregory A · Spokane, WAN91529Dutchess Community College · Poughkeepsie, NYN91538Graves Dale E · Waukesha, WIN91541Engelen Patrick J · Rosamond, CAN91546Delta Charlie LLC · Meridian, IDN91552Reese Ken W · Pewaukee, WIN91557Aero Safe Corporation · Mineral Wells, TXN91558Cole Christopher W · Bothell, WAN91564Siudzinski David · Tuolumne, CAN91568Rasmussen Air LLC · Washington, UTN91574Capps Edward F · Chaparral, NMN91576Reeves James Matthew · Corpus Christi, TXN91579Valentine Jimmie Lloyd Sr · Gulfport, MSN91589Whittles John L · Higganum, CTFirst renewal noticeN91592Sawatzky John E · Oakley, CAN915SPThin Air LLC · Hillsboro, WIN91602Kreikemeier Michael L · Belgrade, MTN91604Veeref LLC · Temecula, CAN91606Zoltak Aviation LLC · Perry, GAN91607Parreira Paul Jr · Dos Palos, CAN91614Hendrich Matthew G · Paso Robles, CAN91621Whitney Richard J · Mason City, ILN91626Tmstar Services LLC · Lewes, DEN91651Cain Edward A · Pembroke, MAN91657Webster Max S · Dalton, PAN91661James One Seventeen LLC · Fairview, OKN91667Dennis Robert · Rosamond, CAN91670Sierrahotellima LLC · Farmingdale, MEN91672Baldridge Steven J · Edmonds, WAN91680Kay Scott Aviation Insurance Inc · Reno, NVN91690Walker Curtis N · Phoenix, AZN91691Stumm Robert W · Cadott, WIN91699Caughlan Cody P · Santa Cruz, CA
Back to Cessna 182M