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 ('1182110')
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 ('1182110')
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.
N319AEAir Evac Ems Inc · O Fallon, MON325AEAir Evac Ems Inc · O Fallon, MON338AEGm Leasing Co LLC · Broussard, LAN34RMCrm Holdings LLC · Missoula, MTN357SPLouisiana Department Of Public Safety · Baton Rouge, LAN35NRCentral States Helicopters Inc · Wood River, NEN361DT925dt LLC · Picayune, MSN386VCCounty Of Volusia · Deland, FLN38BZHelicopters Inc · Wilmington, DEN3QYHelicopters Inc · Wilmington, DEN401FNNy On Air LLC · Kearny, NJN401FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeN402FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLFirst renewal noticeN404MPIndustrial Helicopters LLC · Lafayette, LAN406KKKehler Kelly · Saint Xavier, MTN406MPGm Leasing Co LLC · Broussard, LAN420RLBlue Sky Leasing Inc · Delta, CON42FOchoco Wood Products LLC · Prineville, ORN43EEHelicopters Inc · Wilmington, DEN482TJSky Aviation Corp · Worland, WYN49MAAv8-Orr Helicopter Services Inc · Hamilton, MTN4CQHelicopters Inc · Cahokia, ILN520RLPremier Rotors LLC · Saint Martinville, LAN523RLLarson Helicopters LLC · Perham, MNN538TDEl Destino LLC · Monticello, FLN56757Jbi South Leasing LLC · Pembroke, NHN569THelicopters Inc · Wilmington, DEN570KDK&D Aviation LLC · Kingston, OKN5WVState Of West Virginia · Charleston, WVN60TLIndustrial Helicopters LLC · Scott, LAN6344DSummit Helicopters Inc · Salem, VAN64AWN57aw LLC · Glendale, AZN652HAHelicopter Applicators Inc · Gettysburg, PAN657HAAgricultural Air Services LLC · Jupiter, FLN65RMRmc Aviation LLC · Klamath Falls, ORN6NJNew Jersey State Police · West Trenton, NJN6QPHelicopters Inc · Cahokia, ILN6TYMooney Seven Inc · San Antonio, TXN6ULHelicopters Inc · Wilmington, DEN71HMSummit Helicopters Inc · Salem, VAN722LMNorthwest Helicopters LLC · Olympia, WAN729AEAir Evac Ems Inc · O Fallon, MON73AWTre Aviation Corp · Wilmington, DEN75TVMooney Seven Inc · San Antonio, TXN767HWeyerhaeuser Nr Co · Seattle, WAN76LPPanther Helicopters Inc · Belle Chasse, LAN7898XRigid Aviation LLC · Opelousas, LAN7QDHelicopters Inc · Wilmington, DEN7QNHelicopters Inc · Wilmington, DEN7YJHelicopters Inc · Linden, NJ
Back to Bell 206-L4