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 ('1182108')
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 ('1182108')
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.
N406WHHeli-Works Flight Services LLC · Deer Lodge, MTN4180FCaswell Farms · Durham, CAN419DHAerial Applicators Of Missouri LLC · Qulin, MON4282ZSayre Stanley · Mantua, OHN4338DAce High Helos LLC · Louise, TXN449EAEdgefield Aviation LLC · Sandy, ORN468RLMarks Lloyd L · Lafayette, LAN4717WSeven Whiskey LLC · Austin, TXN477SDHigh-Lead Helicopters LLC · Mossyrock, WAN4833Gm Leasing Co LLC · Broussard, LAN4846G M Leasing Co LLC · Broussard, LAN5000BAir Flite Inc · Shawnee, OKN514RLSlikker Flying Service Inc · Buttonwillow, CAN52GHPleasant Gap Land Co Inc · State College, PAN53702Helicopter Applicators Inc · Gettysburg, PAN545SAShier Aviation Corp · San Diego, CAN54SPIndiana State Police · Indianapolis, INN560PK&D Aviation LLC · Kingston, OKN583MS & S 1165 Investments LLC · Austin, TXN5843Gm Leasing Co LLC · Broussard, LAN588MAMercury Aviation Inc · Flowood, MSN601SJAg Air Inc · Longmont, CON60VGFarwest Aviation LLC · Billings, MTN6133CRedlands Heli Flight LLC · Redlands, CAN613LHTop Flight Aviation Of Mississippi LLC · Picayune, MSN6160YGm Leasing Co LLC · Broussard, LAN620LHNorth Wind Aviation LLC · Cottage Grove, ORN623QJb Air Services LLC · Brighton, CON626United States Department Of Interior · Boise, IDN629LSShook Farms LLC · Milan, MIN641HAHelicopter Applicators Inc · Gettysburg, PAN6501SInternational Air Services Inc Trustee · Carson City, NVN651HAHelicopter Applicators Inc · Gettysburg, PAN6533UTop Flight Aviation Of Mississippi LLC · Picayune, MSN6603XAerial Applicators Of Missouri LLC · Jonesboro, ARN67SJSan Juan Aviation LLC · Wilmington, DEN70606Registration Pending · Rome, NYRegistration pendingN711TTFaithful Flyers LLC · Lakeside, CAN712MScotts Helicopter Service Inc · Le Sueur, MNN7159HPremier Rotors LLC · Saint Martinville, LAN71JJInterstate Helicopters Inc · Bethany, OKN726HGm Leasing Company LLC · Broussard, LAN790RBRight Brother Aviation LLC · Rome, NYN79TMAbove & Beyond Aviation Inc · Anchorage, AKN808HLRegistered aircraftN-number assigned, not yet registeredN852SSAg Air Inc · Johnstown, CON868HWeyerhaeuser Nr Co · Seattle, WAN86PHProvine Helicopter Service Inc · Greenwood, MSN899BHNisource Corporate Services Co · Gary, INFirst renewal noticeN8BQBank Of Utah Trustee · Salt Lake City, UT
Back to Bell 206L-3