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 ('9230406')
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 ('9230406')
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.
N334KLyle Daniel D · Westmorland, KSN336CElkins Aerial LLC · Palmer, AKN340CLindvig Rachel R · Canton, MIN346CVeal Jeffrey S · Sterling, AKN348CSmith Leon R · Homer, AKN358CNicola John T · Coffee Springs, ALN361CBerg Paul A · Gig Harbor, WAN362CSedlickas Scott T · Monroe, WAN363CReddick Eren J · Roselle, ILN366CHendrickson Steven L · Lake Stevens, WAN367CComanche Bloom Enterprises LLC · Purcellville, VAN374CTuttle Walter T · Fairbanks, AKN381CGold Robert K · Hemet, CAN386CFlying M Services Inc · Germansville, PAN389CLayne Terri W · Arrington, VAN394CMccann Todd A · Centralia, WAN397CBell Cody R · North Pole, AKN400CLZedaker Thomas L · Las Vegas, NVN40141Fulton Wayne · San Luis Obispo, CAN403CNicolet Air LLC · Suring, WIN405CPierce John W · Cheney, WAN407CJames David R · Wayne, MIN412CPheasant Terry L · Wasilla, AKN423C9081 LLC · San Jose, CAN424CMillard Richard J · Bedford, NHN425CRegistration Pending · Coolin, IDRegistration pendingN428CVarani Christopher F · Missoula, MTN433CAlaska Frontier Fabrication LLC · Wasilla, AKN441CShepard John A · Thornville, OHN444CCooper Thomas Gordon · Longview, TXN462CKroenke Seth M · Palmer, AKN466CHi-Flight LLC · Ferndale, MIN471CEspeseth Daniel D · Erskine, MNN476CGnandt Steve · Lake Havasu City, AZN481CLatham Scott W · Naples, FLN59345Seefeldt Richard K · Denver, CON6526KPaxton Portraits & Photos LLC · Aiken, SCN65HBreuer James R · Horseshoe Bend, IDN678RDDeltagolf Aviation LLC · Gaithersburg, MDN68194Everett James S · Wyoming, MNN74KSale Reported · Woodside, DESale reported, canceledN8000KGudgel Shannon L · Mount Shasta, CAN8001KSloan Patrick G · Lacon, ILN8010KLa Tourette David A · Coolin, IDN8012KZimmerman Frederick J · Boulder City, NVN8018RBenson Gene N · Reno, NVN8019KWinter Jay R · Huron, SDN8022KPierce Terence M · Mojave, CAN8030KMark Richard A · Gansevoort, NYN8033KSipos Richard · Homosassa, FL
Back to Stinson 108-2