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 ('2074246')
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 ('2074246')
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.
N55ABAllan Michael D · Forney, TXN587GFReher David P · Arlington, TXN6098XKeystone Aerial Surveys Inc · Philadelphia, PAN610W610w Holdings LLC · Sandy, UTN6126CM20k LLC · Minot, NDN6131XGv Air Inc · Medford, ORN6177XMayhew William D · Round Lake, ILN6192XSongbird Group LLC · Andover, MNN654DEDill Brice R · Glendale, AZN6830LN661w Air LLC · Dalton, GAN685CPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN712SBSinger Nathan · Pismo Beach, CAN717TVPinkert Sy · Silverthorne, CON771CMCollvins Robby D · Mount Vernon, TXN777VMiso Enteprises LLC · Wilmington, DEN78BBRadwanski D · Westmont, ILN8155ASkylane Ventures LLC · Keizer, ORN816GHSteim Joseph M · Shirley, MAN817GCMountain View Aeromotive Inc · Del Norte, CON83GHTebow William · Bunkie, LAN87221Chester Darren Dw · Sioux Falls, SDN8727387273 LLC · Reno, NVN87293Dinaland Aviation · Vernal, UTN87356Kovacs Endre · Plant City, FLN87393310 Amigos LLC · Stuart, FLN87443Keystone Aerial Surveys Inc · Philadelphia, PAN87481Petersen Donald W · Bullhead City, AZN87RJNorris Aviation LLC · Mansfield, TXN888KPRunway 321 LLC · Hilton Head Island, SCN900GMKashtan David L · Mill Valley, CAN910MFly By Night Aviation LLC · San Francisco, CAN916MD43701 Corp · Zanesville, OHN92903Nalle W B · Austin, TXN934JDCitation Time LLC · Seguin, TXN9469CKinetic Concepts LLC · Pensacola, FLN969THMgi Proflight LLC · Las Vegas, NVN97HCAlpha Whiskey 1 LLC · Brandon, MSN984DSWilger Thomas J · Lafayette, CON98869Keystone Aerial Surveys Inc · Philadelphia, PAN998JA2 Doods LLC · Lakewood Ranch, FL
Back to Cessna T310R