AD 2000-08-22

Registered aircraft · 433

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

N520NTAurora Meridian LLC · Portland, ORS/N LN066N520PAMid Pacific Aero Services LLC · Honolulu, HIS/N 490505DN520PDCity Of Glendale Police Department · Glendale, CABuilt 2014 · S/N LN111N520VCVolusia County Mosquito Control · New Smyrna Beach, FLBuilt 2015 · S/N LN112N521PDSale Reported · Costa Mesa, CASale reportedBuilt 1988 · S/N 0321EN5238CAviation Advantage Inc · Tabor City, NCS/N 0151EN523CPHowe Aviation LLC · Surprise, AZS/N LN003N523HBCrg2 LLC · Lees Summit, MOBuilt 2007 · S/N LN105N5245PFlight 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 0596EN527FBChatham County Mosquito Control · Savannah, GABuilt 1992 · S/N LN007N527HKHawkeye 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 911059DN530HBKansas Farm & Ranch Inc · Seneca, KSBuilt 1981 · S/N 121096DN5313YSeley Corp · Ketchikan, AKBuilt 1979 · S/N 490496DN533DRLt Aviation LLC · Lexington, KYBuilt 1979 · S/N 490533DN537STJ&J Holdings And Investments LLC · Phoenix, AZBuilt 1998 · S/N 0540EN53846Aerial Solutions Inc · Tabor City, NCBuilt 1982 · S/N 1070-DN538STJ&J Holdings And Investments LLC · Phoenix, AZS/N 0192EN541Chaparral Air Group · Grapevine, TXBuilt 1981 · S/N 711023DN54528Jobe Jeff · Redmond, WAS/N 390464DN54PDCameron Kenneth D · Montgomery, TXS/N 0180EN550JMNational Aggregates Inc · Malvern, OHBuilt 1982 · S/N 0013EN555BHAgricultural Air Services LLC · Jupiter, FLS/N 1200857DN555MSAvioelectronica Inc DBA · Coral Springs, FLS/N RN079N556ACAc Odyssey LLC · Bellevue, WAS/N 870173DN556MHAa Leasing Lp · Kilauea, HIBuilt 1977 · S/N 570143DN557TSLone Oak Aviation LLC · Stayton, ORBuilt 1976 · S/N 1160037DN569FCFerguson And Sons Constructions LLC · Emmett, IDBuilt 1977 · S/N 570126DN571HHHlh Leasing LLC · Wilmington, DEBuilt 1977 · S/N 470125DN572SABank Of Utah Trustee · Salt Lake City, UTBuilt 1987 · S/N 0252EN58191Temsco Helicopters Inc · Ketchikan, AKBuilt 1977 · S/N 1070187DN58243Aa Leasing Lp · Kilauea, HIS/N 410934DN58251Windward Aviation Inc · Puunene, HIBuilt 1978 · S/N 880317DN58252Windward Aviation Inc · Puunene, HIBuilt 1978 · S/N 1080364DN58337Temsco Helicopters Inc · Ketchikan, AKS/N 1090582DN58341N953xt LLC · Henderson, NVBuilt 1979 · S/N 790544DN58350Siller Helicopters Inc · Yuba City, CABuilt 1979 · S/N 790546DN58415Temsco Helicopters Inc · Ketchikan, AKBuilt 1978 · S/N 480312DN58428Teryjon Aviation Inc · Bluefield, VABuilt 1979 · S/N 1290624DN58431Dodson Larry · Lone Oak, TXBuilt 1979 · S/N 1290647DN593CK & S Helicopters Inc · Kailua Kona, HIS/N 201EN594DBDeland Air And Sea Brokerage Inc · Deland, FLBuilt 1982 · S/N 1169DN59CPRegistration Pending · Phoenix, AZRegistration pendingBuilt 2008 · S/N 0591EN59SDInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 0019E
Back to AD 2000-08-22