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.
N248AEAir Evac Ems Inc · O Fallon, MON24WSCorvus LLC · Clovis, NMN255GTL3 Helicopter Inc · Miami, FLN2619Bank Of Utah Trustee · Salt Lake City, UTN269AEAir Evac Ems Inc · O Fallon, MON2717WSf Leasing LLC · Norfolk, NEN271AEAir Evac Ems Inc · Ofallon, MON275AEAir Evac Ems Inc · O Fallon, MON277AEAir Evac Ems Inc · O Fallon, MON277TBSierra Flite LLC · Camden, DEN279THT & T Capital Inc · Bangor, MEN27TKAir Resources Helicopters Inc · Salt Lake City, UTN281AEAir Evac Ems Inc · O Fallon, MON282AEOas2 LLC · Orlando, FLN283BHJohnson Flying Service LLC · Exira, IAN285AEAir Evac Ems Inc · O Fallon, MON288AEAir Evac Ems Inc · O Fallon, MON28NAPremier Rotors LLC · Saint Martinville, LAN290AEAir Evac Ems Inc · O Fallon, MON293AEAir Evac Ems Inc · O Fallon, MON295AEAir Evac Ems Inc · O Fallon, MON296CCClayton County Police Department · Jonesboro, GAN29AEAir Evac Ems Inc · O Fallon, MON2NJNew Jersey State Police · Ewing, NJN304MHBank Of Utah Trustee · Salt Lake City, UTN306MHOlympic Jet Inc · Olympia, WAN31079Top Flight Aviation Of Mississippi LLC · Picayune, MSN3107WWeyerhaeuser Nr Co · Seattle, WAN312NLYellowstone Wr Ranch LLC · Dillon, MTN315WCAnjum Mohammad A · Melrose Park, ILN3180LGm Leasing Co LLC · Broussard, LAN318AEAir Evac Ems Inc · O Fallon, MON321AHBektor III LLC · Kalispell, MTN327AEAir Evac Ems Inc · O Fallon, MON334AEAir Evac Ems Inc · O Fallon, MON33PPUnited States Department Of Interior · Boise, IDN33RSFlying H Limited LLC · Mesa, AZN343ALBtak LLC · New Baden, ILN351RLOas2 LLC · Orlando, FLN356LArizona Helicopter Services LLC · Prescott, AZN361ALBillings Flying Service LLC · Billings, MTN362ALMarks Lloyd · Lafayette, LAN370DPDodson International Parts Inc · Rantoul, KSN3777MRotor Co · New Braunfels, TXN377LFHelicopter Parts International Inc · Minden, NVN383SHAspen Helicopters Inc · Oxnard, CAN3893UMonarch Enterprises Inc · Kirkland, WAN3KYCommonwealth Of Kentucky · Frankfort, KYFirst renewal noticeN402TDAir Metro Helicopters Inc · New City, NYN405RLGlobal Aviation Florida LLC · Pompano Beach, FL
Back to Bell 206L-3