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 ('2074228')
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 ('2074228')
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.
N6959LPinter Scott · New Hudson, MIN6962LD W Peterson Inc · Warren, MNN6964L310owners LLC · Port Royal, SCN6969LCarter Charles David · Fort Worth, TXN6970LMulligan David E · Andover, KSN6971LCw Equipment Rentals Inc · Biggs, CAN6979LIntravaia Anthony J · Saint Louis, MON6988LCentral Virginia Aviation Inc · North Dinwiddie, VAN6994LVance Austin Leasing Enterprises Inc · Blytheville, ARFirst renewal noticeN6995LBaker James W · Wildwood, MON6997LMcnutt Chris L · Anna, TXN7002LDatema Steven K · Susanville, CAN7005LYonge Laurie W Jr · Ocklawaha, FLN7007LSkykings LLC · Little Rock, ARN7015LHeritage Aviation Management LLC · Headland, ALN7017L310 Aviation LLC · Schererville, INN7019LCutrer Raymond · Kentwood, LAN7023LHubele Conrad · Tucson, AZN7032LMcclaskey Leslie P · New Albany, OHN7038LWaddingham William B · Rancho Cucamonga, CAN7068LSale Reported · Crystal, MNSale reported, pending cancellationN7071LBeta Flight LLC · Queen Creek, AZN7077LF4 Aviation LLC · Marble Falls, TXN7083LPotter Steven R · Grapevine, TXN7097LDeon Esterhuizen Inc · Clearwater, FLN7098LGillespie Warren H · Hamilton, MTN881RMMadden Robert B · Eagleville, PAN898TCRomar LLC · Myrtle Beach, SC
Back to Cessna 310K