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 ('2072708')
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 ('2072708')
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.
N8617TBrunson Aviation LLC · Little Elm, TXN8622TBothell Eric L · Center, CON8625TChisum Lance A · Boise, IDN8626THibbert Walter W · Otto, WYN8627TRegistered aircraftN8628TR&D Aviation Holdings LLC · Bellville, TXN8629TWoodworth Mark P · Golden, CON8630THensley Steven Lee Jr Trustee · Scappoose, ORN8632TLucky Resin Works LLC · Bend, ORN8637THundo Air LLC · Kalispell, MTN8640TSkydive Florida Keys Inc · Summerland Key, FLN8643TStofer William · Warsaw, INN8647TJones Wallace F · Waterford, MEN8649TJarosak Peter J · Valparaiso, INN8652TEagles Wings Inc · San Angelo, TXN8656THacker Arlen H · Sandusky, MIN8659TMclenaghan Alvin N · Phoenix, AZN8662THatfield Dominic · Mesa, AZN8663TBruni Design Inc · Greenacres, WAN8664TGray Eric W · Erie, CON8666TEvery Rex R · Wilburton, OKN8668TWagoner Thomas H · Clarinda, IAN8669THall David T · Baton Rouge, LAN8670TLovegreen Kenneth · Naples, FLN8671TSchafer Timothy R · Soldotna, AKN8673TJensen Dennis H · Askov, MNN8675TWakefield Bradley E · Rogersville, MON8676TCasciola Diana M · East Branch, NYN8677TKowachek Edwin J · Missoula, MTN8679TOnshore Aviation LLC · Taylors, SCN8680TD2w Enterprise LLC · Miami Lakes, FLN8682TBushong Charles L Jr · Jackson, WYN8684TMacnealy Bradly S · Isola, MSN8687TKinney Christopher G · Beresford, SDN8690TFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVN8693TEgmond Aircraft LLC · Lewes, DEN8695TAtarah LLC · Tucson, AZN8698TTimwatco LLC · Orland, CAN8699TSims William L · Hobart, OKN8702TWarner Billie J · Fair Oaks Ranch, TXN8710TWilson Kendal · Carrizozo, NMN8711TFlyabq Aviation LLC · Bella Vista, ARN8713TMoreau Darlene A · Penrose, CON8714TPittman Stuart P · Palisade, CON8716TManchester International LLC · Liberty Lake, WAN8720THarris Todd D · Malta, IDN8722TBarker Bruce L · Liberal, MON8724TStephens Nicholas C · Overgaard, AZN8730THardin Mark A · Dalton, GAN8731TSkol Alaska LLC · Soldotna, AK
Back to Cessna 182C