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 ('2072418')
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 ('2072418')
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.
N80816Laurel Highlands Aeronautical Academy · Latrobe, PAN80830Mahnattan Flying Tigers Inc · Bozeman, MTN80837Lucky Richard E · Skipperville, ALN80841Sparta 140 Club Inc · Grand Rapids, MIN80842Augusta Aviation Inc · Augusta, GAN80847Evergreen Flying Club Inc · Medina, WAN80855Bowe Joseph E DBA · Chippewa Falls, WIN80864Kessler Garry A · Lansing, WVN80865Green Rick A · Hudson, IAN80866Preston Richard K Trustee · Albuquerque, NMN80868Paradis Paul A · Bar Harbor, MEN80870Robben William J · Pampa, TXN80871Monnin Aviation LLC · Amherst, NYN80872Yakima 872 Flying Club · Yakima, WAN80874Jls Aviation LLC · Fredericksburg, VAN80884Rein W Clark · Ottawa, KSN80896Dsr-Cherokee 180 LLC · Dallas, TXN808UFMahoney Clinton D · Tecumseh, NEN80906Red Door Aviation LLC · Dover, DEN80912Bay Area Concrete LLC · Hayward, CAN80914Cp Aviation Inc · Santa Paula, CAN80921Conerly Group LLC · Denham Springs, LAN80928Bellingham Aviation Services LLC · Bellingham, WAN80931Augusta Aviation Inc · Augusta, GAN80941Holombo Ray J · Taylors, SCN80952Registered aircraftN80959Mets Flying Club Inc · Fairmount, INN80961A S Air LLC · Lantana, FLN80975N80975 LLC · Wilmington, DEN80982Reiselt Paul T F · Corinth, MSN80985Mullins James C · Franklin, TNN80991Flowers Robert Clyde III · Manchaca, TXN80996Halley Dan R · Avery, TXN809BTLouisville Aircraft Leasing LLC · Louisville, KYN811JDSanders Jason C · Babylon, NYN81772American Patrols Inc · Midland, TXN817ZBennett Condon P · Stormville, NYN822MLMojo Flight Group LLC · Gainesville, GAN82671Keleman Kenneth S · Bellingham, WAN830TNPrianti Paul J · Rockaway, NYN83EWTremarco Philip J · Anchorage, AKN841JWScenic Concepts LLC · La Crosse, WIN844PTPatterson James M · Eagle, IDN847JWMoon Samuel C · Bedford, TXN852DAHendrix Rex · Pell City, ALN8541KNoack Kevin L · Oconto, WIN854ACKurchian Aram M · Sunland, CAN858SCNightscape Aerial Advertising LLC · San Diego, CAN864TWTailwinds Academy Of Aviation · Philadelphia, PAN867AAWings Over Texas Holdings LLC · Denton, TX
Back to Cessna 172M