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 ('2072602')
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 ('2072602')
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.
N740BHHarris Jaqai · Juneau, AKN744NGEvans William H Jr · Gardendale, TXN7474EGough William N · Vancouver, WAN7479CBentley John R · Bend, ORN7511Travis Paul A · Defiance, OHN7601ACranor Clayton · North Pole, AKN7603ANoble Raymond D · East Windsor, CTN7615AUpton Michael James · Anchorage, AKN7622APribyl Katie Ann Marie · Great Falls, MTN7626AMissaukee Aircraft Leasing LLC · Cadillac, MIN7627AMullin Samuel J · Salem, ORN7646ASommer Charles D · Twin Falls, IDN7648AFrance Jane M · Cheyenne, WYN7651AMonson Conrad J · Wasilla, AKN7652AWilliams Jerry B · Vashon, WAN7654LLarsen Daniel R · Kenai, AKN7658AWest Michigan Aviation Inc · Kalamazoo, MIN7661AMiller Bradley · Joliet, MTN7663ATovsen John T · Anchorage, AKN7666ACournoyer Constance L · Ellsinore, MON7668ASpevacek William E · Geraldine, MTN7672ATram Enterprises LLC · White, GAN7678AHenderson William H Trustee · Eagle River, AKN7685AAnderson Clarence D Trustee · Anchorage, AKN7698ABauman Jessica T · Junction City, ORN7707AGay Chris · Anchorage, AKN7708AFrelin Josef J · Anchorage, AKN7711AMckay Donald A · Soldotna, AKN7712AMizer James D · Hailey, IDFirst renewal noticeN7714ALawyers Real Estate Services LLC · Hondo, NMN7715AWallace Wayne P · Graham, WAN7720AKrueger Eric J · Olivehurst, CAN7721AAngel Steven · Fairbanks, AKN7723ADoremus Scott M · Wolfeboro, NHN7741ATalaheim Air Service LLC · Willow, AKN7743AHarden Harry B · English, INN7749APrins Dennis A · South Lake Tahoe, CAN7755ADunn Brian R · Otis, MEN7757CBentley John R · Bend, ORN7763CHudzinski Thomas E · Wasilla, AKN7772BLunken Martha F · Cincinnati, OHN7847CAyres Patrick C · Bend, ORN7855CSitz Walter L · Burns, ORN79AGarg Christopher D · Shoreline, WAN8022XAzzalin Giorgio · Jacksonville, FLN8047ZBooth James L · Bozeman, MTN823TMMarther Thomas L · Albion, PAN834ZGroshel Joseph C · State College, PAN851DABhh Leasing #4 LLC · Pensacola, FLN882DBBerland Donald B · Lone Tree, CO
Back to Cessna 180