Registered aircraft · 614

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:81-26-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-26-01-R1') 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:81-26-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-26-01-R1')
  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:81-26-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-26-01-R1')
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.

N473EOchoco Wood Products LLC · Prineville, ORBuilt 1991 · S/N 0473E N478NWTmds Air Inc · Gig Harbor, WABuilt 1973 · S/N 530478S N484Bhh Leasing #2 LLC · Pensacola, FLS/N 870177D N488NSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 450738S N48MPPope James D · Lewiston, IDBuilt 1982 · S/N 1137D N499SLHlh Leasing LLC · Wilmington, DEBuilt 1979 · S/N 190448D N49TJShoreline Aircraft Leasing LLC · Lewes, DEBuilt 1975 · S/N 550747S N49WKRail N LLC · Oracle, AZBuilt 1981 · S/N 611006D N4RRBlue Sky Air Services LLC · Wilmington, DEBuilt 2013 · S/N 0203FF N500ARHelicopter Roundup Service LLC · Nephi, UTS/N 0149E N500BHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 0537E N500CVParadise Air LLC · White City, ORS/N 240561S N500DCHva Holdings LLC · Gettysburg, PABuilt 1978 · S/N 290456D N500EKKar Aviation LLC · Saltville, VABuilt 1979 · S/N 1190610D N500EVSnohomish County Sheriff · Snohomish, WABuilt 1989 · S/N 0340E N500FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1983 · S/N 0442E N500FFRegistered aircraftN-number assigned (import), not yet registeredS/N 1270251D N500GKN969md Inc · Middletown, DES/N 911074-D N500HJ392e Inc Trustee · Wilmington, DEBuilt 1990 · S/N 0392E N500HWHeliwild Investments LLC · Austin, TXBuilt 1978 · S/N 480294D N500KYRotor Imaging LLC · Reading, PABuilt 1989 · S/N 0345E N500LKWinco Inc · Aurora, ORBuilt 1983 · S/N 0009E N500MUHva Inc · Summersville, WVBuilt 1996 · S/N 0533E N500MVTreeline Helicopters Inc · Bristol, TNBuilt 1977 · S/N 770156D N500NCSanders Associates LLC · Bluefield, VABuilt 1977 · S/N 1260052D N500PHPrecision Heli-Support LLC · Mesa, AZS/N 0187E N500RMHawkeye Helicopter LLC · Lyndon, KSS/N 0119E N500RTCessna 210 LLC · Waynesville, MOBuilt 1976 · S/N 1050773S N500SLPatriot Marine LLC · New Haven, CTBuilt 1988 · S/N 0309E N500SYNalas Inc Trustee · Wilmington, DEBuilt 1983 · S/N 0007E N500TNOnespan Powerline Services LLC · Peachtree City, GABuilt 1979 · S/N 590521D N500TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2019 · S/N 0320FF N500TYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N 0086E N500TZGulf Helicopters LLC · Santa Fe, TXBuilt 1979 · S/N 590507D N500VSVertol Systems Company Inc · Destin, FLBuilt 1977 · S/N 170072D N500VZSea Corp Helicopters Inc · Wilmington, DEBuilt 1975 · S/N 450735S N500WBSearok Aviation LLC · Pierson, FLS/N 1000269S N500WXTre Aviation Corp · Wilmington, DEBuilt 1992 · S/N 0493E N500XVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 1200881D N501EFAirwest Helicopters Inc · Redlands, CABuilt 1977 · S/N 270091D N501HPHonolulu Police Department · Honolulu, HIBuilt 2009 · S/N 0593E N501MDAgricultural Air Services LLC · Jupiter, FLBuilt 1991 · S/N 0485E N501RMCity Of Pasadena · Pasadena, CABuilt 2009 · S/N 0598E N501VSVertol Systems Co Inc · Destin, FLBuilt 1977 · S/N 170050D N5027PBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 611002D N502CHVertol Systems Co Inc · Destin, FLBuilt 1978 · S/N 180252D N502HBActive Aviation LLC · Newark, DEBuilt 1978 · S/N 480291D N502HPHonolulu Police Department · Honolulu, HIBuilt 2007 · S/N 0572E N502MMWinco Inc · Aurora, ORS/N 1170229D N502SLSc Law Enforcement Division · Columbia, SCS/N 0244E

Back to AD 81-26-01 R1