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.

N6952BWesley Jerry A · Moorland, IAS/N 22-4232N6952CSnoz Inc · Sharon, MABuilt 1978 · S/N 28R-7837178N6952JLagimoniere Gregory · Jacksonville Beach, FLBuilt 1976 · S/N 28R-7635365N6952KPoor Jeffrey L · Bettles, AKS/N 20-57N6952RMelville Isaiah · Panama City, FLBuilt 1975 · S/N MC-317N6952UDuggan Edwin T · Franklin, MEFirst renewal noticeBuilt 1964 · S/N 322N6952WBeaver Milton H II · Palmer, AKBuilt 1965 · S/N 28-21143N6953DLambert Hubert D Sr · Lincolnton, NCBuilt 1957 · S/N 22-4882N6953QBrancefield John Lewis · Fort Mohave, AZBuilt 1968 · S/N MA-300N6953WScotting David R · Pipestone, MNBuilt 1965 · S/N 28-21144N6954PJcav8 LLC · Cartersville, GABuilt 1960 · S/N 24-2090N6954QBalash Bryan J · Oldenburg, INBuilt 1968 · S/N MA-302N6954VGrubb Jefferson D · Chesapeake, VABuilt 1976 · S/N 20-1187N6955DGlover Thomas B · Marana, AZFirst renewal noticeBuilt 1957 · S/N 22-4884N6956BBushplane Lab LLC · Wilderville, ORBuilt 1956 · S/N 22-4237PN6956JJuliet Sky LLC · Sioux City, IABuilt 1976 · S/N 28-7690439N6956KEdwards Stephen L · Wasilla, AKBuilt 1950 · S/N 20-60N6956QStaab Robert J · Wantage, NJBuilt 1968 · S/N MA-304N6956RMorgan Richard D · Belton, TXBuilt 1975 · S/N MC-320N6956VAbney Timothy R · Crossett, ARBuilt 1975 · S/N 20-1189N6957BVaughn James R · Winchester, KYBuilt 1956 · S/N 22-4239N6957PHoran Edward · Wexford, PABuilt 1960 · S/N 24-2095N6957QWashburn Ronald G · Westfield, INBuilt 1968 · S/N MA-305N6957VKnoke Keith W · Litchfield Park, AZBuilt 1976 · S/N 20-1190N6958HJewell Aviation Inc · Kennett, MOBuilt 1975 · S/N 17265663N6958JAkin Enterprises Inc · Greensboro, GABuilt 1976 · S/N 28-7690441N6958UVauclin Brady P · Shreveport, LAS/N 2709N6958VSale Reported · Austin, TXSale reportedBuilt 1976 · S/N 20-1191N6958WPeck Michael S · Las Vegas, NVBuilt 1965 · S/N 28-21150N695APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843782N695ACHodgson Daniel J · Anchorage, AKBuilt 1998 · S/N 394-98N695FParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020237N695FLPugh Daniel J · Omaha, NEBuilt 1971 · S/N 28-7125634N695LHJrnd Corp · Lewes, DEBuilt 2023 · S/N 2881628N695NDFly Gateway Aviation Institute · New Castle, DEBuilt 2015 · S/N 4496386N695PMSimonson Robert J · Cedar Crest, NMBuilt 1966 · S/N 1021N695RAPhillips Robert M · Imperial, CABuilt 2018 · S/N 83533N6960HZiller Wayne Jr · Fairbury, ILBuilt 1975 · S/N 17265664N6960KTillman William L · Virginia Beach, VABuilt 1950 · S/N 20-64N6960UWayne Brett M · Saint George, UTBuilt 1964 · S/N 2711N6961BTrimmer Marvin E · Willow, AKBuilt 1956 · S/N 22-4243N6961DOrtega David J · San Antonio, TXBuilt 2013 · S/N 90297N6961QReed Billy B · Cabool, MOBuilt 1968 · S/N MB-316N6961UMeservey Harley G · Portland, ORBuilt 1964 · S/N 2712N6961VHunt David · Burlington, IABuilt 1975 · S/N 22-1328N6961WExpresstek LLC · Farmington, UTBuilt 1965 · S/N 28-21155N6962JBores Scott J · Huron, OHBuilt 1976 · S/N 28-7625262N6962KBast William B · Fairbanks, AKBuilt 1950 · S/N 20-66N6962UGrey Scott A · Bluff City, TNBuilt 1964 · S/N 2713N6962VRez Peter Trustee · Scottsdale, AZBuilt 1976 · S/N 22-1329
Back to AD 90-04-06 R1