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 ('2072618')
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 ('2072618')
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.
N9911VInternational Air Services Inc Trustee · Carson City, NVN9913VIsern Douglas J · Golden, CON9914VJennair LLC · Wilmington, DEN9918VGray Paul W · Eads, TNN9923VFive Pines Aviation LLC · Casper, WYN9926VRanheim Richard J · Blaine, MNN9928VRyan Wilfred P · Anchorage, AKFirst renewal noticeN9930VHovland Keith C · Wadsworth, OHN9934VRuby Aviation LLC · Oak Creek, CON9939VJackson Walter E · Wasilla, AKN9941VMorris Gray S · Chugiak, AKN9943VNewsom John · Lubbock, TXN9944VHinkes Michael T · Fairbanks, AKN999AGClark Chase H · Ozona, TXN9HQBacon Joseph M · Fenton, MIN9PDPowell Distributing Co Inc · Portland, OR
Back to Cessna 180H