OpenAirDocs.org
AD 89-02-01 R1

Registered aircraft · 484

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
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:89-02-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:89-02-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.

N511SHHawkeye Helicopter LLC · Lyndon, KSBuilt 1979 · S/N 290455DN5125QTemsco Helicopters Inc · Ketchikan, AKBuilt 1982 · S/N 1100DN5129NEichner Eric D · Ketchikan, AKBuilt 1982 · S/N 1101DN5132YEmaero LLC · Sequim, WAS/N 1108DN5133UTemsco Helicopters Inc · Ketchikan, AKBuilt 1982 · S/N 1102DN5134VTemsco Helicopters Inc · Ketchikan, AKBuilt 1982 · S/N 1103DN513HTHeliservice LLC · Wilmington, DEBuilt 1981 · S/N 410961DN514PAAa Leasing Lp · Kilauea, HIBuilt 1981 · S/N 510981DN516BRichey Bradly L · Chico, TXS/N 0378EN516PJSchreindl Lawrence A · Colton, ORS/N 1188DN5185GLas Vegas Metropolitan Police Department · North Las Vegas, NVBuilt 1984 · S/N 0009FN518PAPatriot Aviation Inc · Greenville, DEBuilt 1980 · S/N 400694DN519PAPatriot Aviation Inc · Greenville, DEBuilt 1977 · S/N 370097DN51MNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 0200EN5200WEmerald City Aircraft Leasing Inc · Port Orchard, WAS/N 0025EN520PAMid Pacific Aero Services LLC · Honolulu, HIS/N 490505DN520WHWinco Inc · Aurora, ORBuilt 1988 · S/N 0607FFN521PAPatriot Aviation Inc · Greenville, DEBuilt 1985 · S/N 0015FN521PDSale Reported · Costa Mesa, CASale reportedBuilt 1988 · S/N 0321EN5238CAviation Advantage Inc · Tabor City, NCS/N 0151EN5245PFlight Level Zero LLC · Othello, WAS/N 0140EN5264QSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1986 · S/N 0126EN5277FCity Of Houston · Houston, TXBuilt 2008 · S/N 0587EN5278FCity Of Houston · Houston, TXBuilt 2008 · S/N 0588EN5279FCity Of Houston · Houston, TXBuilt 2009 · S/N 0596EN527HKHawkeye Helicopter LLC · Lyndon, KSS/N 0430EN5280FCity Of Houston · Houston, TXS/N 0597EN5284FCity Of Houston · Houston, TXBuilt 2008 · S/N 0585EN5288XCollier Mosquito Control District · Naples, FLS/N 911059DN530Valiair Lc Trustee · Casper, WYBuilt 2023 · S/N 0343FFN530ARN530mx LLC · Missoula, MTBuilt 2009 · S/N 0157FFN530CGSvp LLC · Tucson, AZBuilt 1987 · S/N 0041FFN530DGHlh Leasing LLC · Wilmington, DES/N 0603FFN530FCFerguson And Sons Construction · Emmett, IDBuilt 2007 · S/N 0712FFN530FFUtah Aviation Services Inc · Spanish Fork, UTBuilt 1987 · S/N 0050FFN530FMGooseneck Inc · Heber City, UTBuilt 2015 · S/N 0253FFN530HBKansas Farm & Ranch Inc · Seneca, KSBuilt 1981 · S/N 121096DN530JLLas Vegas Metropolitan Police Department · Las Vegas, NVBuilt 2015 · S/N 0251FFN530JRApex Heli-Support LLC · Phoenix, AZS/N 0711FFN530MPRegistration Pending · Missoula, MTRegistration pendingBuilt 1994 · S/N 0103FFN530RLGulf Helicopters LLC · Santa Fe, TXS/N 0602FFN530RPGilliam Aviation LLC · Odessa, TXS/N 0153FFN530STJ&J Holdings And Investments LLC · Phoenix, AZBuilt 2000 · S/N 0142FFN530TGSummit Helicopter Inc · Pacoima, CAS/N 0174FFN530THHeliservice LLC · Wilmington, DEBuilt 1996 · S/N 0600FFN530TTAdvanced Aerospace Consultants Inc · Boynton Beach, FLS/N 0056FFN530TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2009 · S/N 0172FFN530VHSvp LLC · Missoula, MTBuilt 2012 · S/N 0187FFN530WHWinco Inc · Aurora, ORBuilt 2008 · S/N 0151FFN530XOxford Police Department · Oxford, ALBuilt 1994 · S/N 0112FF
Back to AD 89-02-01 R1