AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N8786Kiloecho Trnsport LLC · Tucson, AZBuilt 1974 · S/N 929N87867Anderson Ryan L · Minneapolis, MNBuilt 1946 · S/N 15485N87869Coats Cheryl B Trustee · Dunn, NCBuilt 1954 · S/N 18-3355N8786C8786c LLC · Cleburne, TXBuilt 1976 · S/N 28-7615129N8786DMikkelsen Timothy O · Wasilla, AKBuilt 1958 · S/N 18-6323N8786ELuv 2 Fly Ada LLC · Ada, OKBuilt 1976 · S/N 28-7615162N8786NSorenson Kyle F · Deaver, WYBuilt 1969 · S/N 28-25772N87875Rice John D · Maddock, NDBuilt 1954 · S/N 18-3589N87876Plauger George V Jr · Beverly, WVBuilt 1987 · S/N 18-3595N8787CBrolan Aviation LLC · Kansas City, MOBuilt 1976 · S/N 28-7690165N8787EMyers Danny A · Saint Charles, MOBuilt 1976 · S/N 28-7615163N8787FLibby Nicholas J · Olympia, WABuilt 1976 · S/N 28-7715289N8788CSaflight Pilot Training Inc · Manchester, NHS/N 28R-7635182N8788DMartens Edwin L · Ogallala, NEBuilt 1958 · S/N 18-6325N8788ECoastal Fliers Inc · El Cajon, CABuilt 1976 · S/N 28-7690204N8788RRicher Ned A · Glendale, AZBuilt 2016 · S/N 91895N8788YAerotransit Inc · Milwaukee, WIS/N 30-1946N87898Scott Shawn · Darrington, WAS/N 440301N8789CPainter Joe S · Buffalo, SDFirst renewal noticeBuilt 1953 · S/N 18-2885N8789DStrembicke Derek R · Owens Cross Roads, ALS/N 18-6326N878ACDecathlon LLC · Herndon, VABuilt 2001 · S/N 878-2001N878ALCathcart Richard Gordon · Covington, VABuilt 2018 · S/N 65-10175N878DZSlayback Eric J · Florence, KYBuilt 2004 · S/N 81885N878JMVaughan William F · Henryville, INBuilt 1973 · S/N 177RG0450N878MAAgri Med LLC · Belgrade, MTBuilt 2006 · S/N 1415-2006N878MCHelicopter Leasing LLC · Henderson, NVBuilt 2005 · S/N 3782N878RMBowman Mark R · Tillamook, ORBuilt 2013 · S/N 145N878RVVenohr Robert E · Aurora, COBuilt 2006 · S/N 81663N878WSWallace State Community College · Hanceville, ALBuilt 2021 · S/N 28020033N878ZCrawford Chris M · Petersburg, VAS/N 80096N8790CAltitude Unlimited Inc · Lewes, DEBuilt 1953 · S/N 22-1402N8790EFenty Brandon · Normandy, TNBuilt 1976 · S/N 28R-7635214N8791NVetter Daniel W · Dayton, NVBuilt 1969 · S/N 28-25631N8791YGeboy Alan R III · Baxley, GABuilt 1969 · S/N 30-1949N8792DAndresen Elouise H · Anchorage, AKBuilt 1958 · S/N 18-6333N8792NPiotrowski Nicholas S · Poplar Grove, ILBuilt 1969 · S/N 28-25633N8793LVoerman Joseph R Jr · Cambridge, NYBuilt 1974 · S/N 18-7409125N8794FMundell Terry D Trustee · Rosston, OKBuilt 1962 · S/N 103-0002N8794GBarrymore Blake · Hailey, IDBuilt 2019 · S/N JA515-12-17N8794NCopeland Kevin D · Vidalia, GABuilt 1969 · S/N 28-25637N8795NCycle-Moto Inc · Gilbert, AZBuilt 1969 · S/N 28-25639N8795YJohnson Paul · Wichita Falls, TXS/N 30-1954N8796DNelson Rohn R · Salmon, IDBuilt 1958 · S/N 18-6341N8796NMitchell Michael R · Swanville, MEBuilt 1969 · S/N 28-25640N8797DDuflo Spray Chemical Inc · Lowville, NYS/N 18-6342N8797EVan Beckum Peter · Farmington, CTBuilt 1976 · S/N 28-7690209N8797YHight Derrick R · North Aurora, ILBuilt 1969 · S/N 30-1812N8798CSchraceo Travis D · Bridgeport, TXBuilt 1953 · S/N 22-1411N8798EFuller Glenn C · Santa Paula, CAS/N 28R-7635215N87996Terrell Anthony K · Iowa Park, TXBuilt 1954 · S/N 18-4026
Back to AD 90-04-06 R1