Registered aircraft · 211

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:82-17-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-17-01') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:82-17-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-17-01')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:82-17-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:82-17-01')
ORDER BY n_number

Run 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.

N100ATWestern Pacific Fisheries · Hermosa Beach, CABuilt 1980 · S/N 500718D N101CHTri-State Vegetation Management LLC · Vevay, INS/N 1000829D N102SUSignature Property Holdings LLC · Wilmington, DES/N 700736D N104SUSignature Property Holdings LLC · Wilmington, DEBuilt 1977 · S/N 670151D N105ACAgricultural Air Services LLC · Jupiter, FLBuilt 1978 · S/N 580316D N105SUSignature Property Holdings LLC · Wilmington, DEBuilt 1988 · S/N 800776D N106SUSignature Property Holdings LLC · Wilmington, DEBuilt 1981 · S/N 510954D N107SFDah Aircraft LLC · Georgetown, SCBuilt 1978 · S/N 1280405D N1088NTemsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 300679D N108ECHva Inc · Summersville, WVBuilt 1982 · S/N 811049D N1091PTemsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 300683D N1091STemsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 300691D N1092LDel Rio Aviation Inc · Paso Robles, CAS/N 410940D N1095TState Of Montana · Helena, MTS/N 800769D N1097JSignature Property Holdings LLC · Wilmington, DEBuilt 1980 · S/N 900801D N1101NLindemann Drilling Company Inc · Archer City, TXBuilt 1981 · S/N 510960D N1102DAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 900806D N1103LAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 1000812D N1103VGulf Helicopters LLC · Santa Fe, TXS/N 1000823D N11054Winco Inc · Aurora, ORBuilt 1981 · S/N 310910D N11056Northwest Helicopters I Inc · Olympia, WABuilt 1981 · S/N 310905D N1106GSenninger Thomas P · Clermont, FLBuilt 1981 · S/N 510955D N1106ZEnright Miles · Ketchikan, AKBuilt 1981 · S/N 210900D N1107NCairns Dave DBA · Lemon Cove, CABuilt 1981 · S/N 210902D N1107PTemsco Helicopters Inc · Ketchikan, AKBuilt 1981 · S/N 210897D N1107TAviation Advantage Inc · Tabor City, NCBuilt 1981 · S/N 210898D N11082Vertical Corp · Kalispell, MTBuilt 1980 · S/N 1100845D N1110QAviation Advantage Inc · Tabor City, NCBuilt 1981 · S/N 611011D N111ADSvp LLC · Missoula, MTBuilt 1980 · S/N 400704D N112ASOlympic Jet Inc · Olympia, WABuilt 1980 · S/N 900808D N114HDWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 280261D N115HDLaroche Aviation Services LLC · Bellaire, OHBuilt 1981 · S/N 711020D N115SUSignature Property Holdings LLC · Wilmington, DEBuilt 2021 · S/N 110868D N131ALQuicksilver Air Inc · Fairbanks, AKBuilt 1977 · S/N 1170230D N131NWEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1982 · S/N 1131D N138TXAir2 LLC · Blountville, TNBuilt 1979 · S/N 1290646D N145ALQuicksilver Air Inc · Fairbanks, AKBuilt 1980 · S/N 1200856D N151JPFarmar Peter D · San Angelo, TXBuilt 1978 · S/N 480301D N1578FHeliservice LLC · Wilmington, DEBuilt 1981 · S/N 610957D N160THTerrell Bill · Port Orange, FLS/N 770160D N161LAAir2 LLC · Blountville, TNBuilt 1981 · S/N 711015D N166MBHelicopter Roundup Service LLC · Nephi, UTBuilt 1980 · S/N 1000831D N167ALFerguson And Sons Construction LLC · Emmett, IDBuilt 1977 · S/N 270083D N173ALFulton Timothy E · Salem, MOBuilt 1976 · S/N 1160020D N175JLRatcliff Dustin · Saltville, VABuilt 1977 · S/N 270076D N193VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N 110882D N195VSVertol Systems Co Inc · Destin, FLBuilt 1981 · S/N 110826D N212ELMark Mondo Building & Excavating Inc · Reno, OHBuilt 1982 · S/N 1097D N212VTLaroche Aviation Services LLC · Bellaire, OHBuilt 1981 · S/N 811039D N221TGCollier Mosquito Control District · Naples, FLBuilt 1981 · S/N 410951D

Back to AD 82-17-01