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.

N4257Faire Kenneth D · Mojave Valley, AZS/N 312N4257HGilman James C · Butte, MTBuilt 1948 · S/N 14-60N4257JBroderick Randolph W · Shelby, OHBuilt 1967 · S/N 28-22614N4257MBaus Roman J · Rubicon, WIBuilt 1947 · S/N 12-3151N4257ZSmith April A · Anchorage, AKBuilt 1967 · S/N 18-8497N4258HCeason Jeffrey M · Tucson, AZBuilt 1978 · S/N 240686N4258JAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1967 · S/N 28-22615N4259HLambe Steven S · Anchorage, AKBuilt 1948 · S/N 14-62N4259PSkypark Inc · Wadsworth, OHBuilt 1959 · S/N 23-1758N425ADoberenz Marvin E · Granbury, TXBuilt 2000 · S/N 1N425AADoyle Jimmy Dan · Christoval, TXBuilt 1968 · S/N 28-5051N425AHHanson B Jake · Jackson, WYBuilt 1946 · S/N 12-817N425AJSomnium Consulting Services LLC · Pensacola, FLBuilt 1965 · S/N 28-20963N425BCRegistered aircraftBuilt 1997 · S/N 0001N425CBSummit Flight Academy LLC · Peculiar, MOBuilt 1974 · S/N 28-7415210N425CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8687N425DBWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266404N425DLTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1979 · S/N 172RG0143N425DPKuhn Alexander G · Fairfield, CTBuilt 1978 · S/N 28R-7837174N425FLFrogtown Investments LLC · Owensboro, KYBuilt 1971 · S/N 28-7125208N425FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC025N425JMccracken Lester G · Edinboro, PABuilt 1958 · S/N TD-57N425JVBarnes Timothy K · Chapel Hill, NCBuilt 2004 · S/N 2844112N425KTBartley Terrence E · Port Orange, FLBuilt 2002 · S/N 425N425KWWooten Kurt R · Wichita, KSBuilt 2014 · S/N 14001N425MKNorth Star Aviation Inc · Mankato, MNBuilt 1977 · S/N 15280650N425PABas Part Sales LLC · Greeley, COBuilt 2001 · S/N 2843474N425RHelmkamp Janet K · Bethalto, ILBuilt 1995 · S/N 124N425RVRegistered aircraftBuilt 2007 · S/N 72117N425SQSpinola Hernandes M · Homestead, FLS/N 23-1376N426Jarrett Franklin · Ivyland, PABuilt 1996 · S/N 1339N4260HDevoe Don F · Anchorage, AKBuilt 1948 · S/N 14-63N4260JSchroeder Gregory M · Saline, MIBuilt 1967 · S/N 28-22658N4260MHelmstadt Ronald J · Bridgeport, MIBuilt 1947 · S/N 12-3176N4260QLevin Robert G · Roseburg, ORBuilt 1971 · S/N 17260160N4261CGidzinski David A · Weirsdale, FLBuilt 1954 · S/N E3B-329N4261EConger Jon W · Cottonwood Heights, UTBuilt 2000 · S/N 33001CN4261JMathison John M · Vancouver, WABuilt 1967 · S/N 28-22618N4262Regal Dent Inc · Goshen, NYFirst renewal noticeBuilt 2006 · S/N 2843647N4262ARamaswamy Ashok · Clearwater Beach, FLS/N 27105N4262HNorthern Iowa Anesthesia Services P L C · Ames, IAS/N 24-0688N4262JBeaverdam Aeronautics LLC · Chatom, ALS/N 28-22619N4262MHoech Neal L · Everett, WABuilt 1947 · S/N 12-3175N4262PPower Willis H · Weatherford, TXS/N 23-1761N4263HSchneider Michael J · Anchorage, AKBuilt 1948 · S/N 14-67N4263JBmf Wings LLC · Corinth, MSBuilt 1967 · S/N 28-22620N4263MThompson Frank Link · Gordon, NEBuilt 1947 · S/N 12-3178N4263ZPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 18-8493N4264FNack Kim R · Wentzville, MOBuilt 1994 · S/N 1030N4264PFergason John S · Louisville, OHBuilt 1961 · S/N 23-1763
Back to AD 90-04-06 R1