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.

N77XYExtra Sweet LLC · Saint Paul, MNBuilt 1997 · S/N 012N77XZRed Rocket Holding Co LLC · Boca Raton, FLS/N 38-78A0033N77YACrew Sourcing Inc · Wilmington, DEBuilt 1954 · S/N 23-61N77YMNew Richard A · Deming, WABuilt 1957 · S/N 185832N77YWMeske Richard A · Columbus, OHBuilt 2000 · S/N 24442N77ZCWorkman Randall L · Batavia, OHS/N 001N77ZPTryer Vince S · Wilmington, NCBuilt 1998 · S/N 2835N77ZWMeyer Alan T · Eckert, COBuilt 2007 · S/N 1039N7800DGoff Harold G · Brandon, FLS/N 22-5444N7800GSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1970 · S/N 17259500N7800PPash Olin M · Harlan, IABuilt 2007 · S/N 0105N7800SSlykerman John A · Bakersfield, CABuilt 1967 · S/N 7854N7801DWebb John M · Chugiak, AKBuilt 1957 · S/N 22-5445N7801HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 12-698N7801NGeorge Monte · Medford, ORBuilt 1968 · S/N 28-5199N7801SRital Copter Service Inc · Hudson, IAS/N 7855N7801WRegistered aircraftBuilt 1964 · S/N 28-1799N78027Cramlet Kirk T · Woodlake, CABuilt 1968 · S/N 17257467N7802VKruger Matthew J · San Francisco, CABuilt 1964 · S/N 2808N7803DFako John · Binghamton, NYS/N 22-5447N7803FKarlovich James W · Kingston, GABuilt 1957 · S/N 18-6259N7803GTomlin Jonathan S · Georgetown, OHS/N 17259503N7803VArtlip James · Wake Forest, NCS/N 2787N7803W3w Group Inc · Hot Springs, ARS/N 28-1807N78048Latham Randall W · Georgetown, OHBuilt 1946 · S/N 2048N7804GWells Adam · New Lexington, OHBuilt 1970 · S/N 17259504N7804NApaa Aviation Group LLC · Frisco, TXBuilt 1969 · S/N 28-5254N7804VVickers David Dewayne · Douglas, GABuilt 1964 · S/N 2788N78051Sipple Ronald W Jr · Gardner, KSS/N 2051N7805DMoretti Anthony · Deming, NMBuilt 1957 · S/N 22-5450N7805GArgabright John · Waterford, OHBuilt 1970 · S/N 17259505N7805NCorrigan Air Center · Hondo, TXBuilt 1968 · S/N 28-5256N7805YN7805y LLC · Winchester, VAS/N 30-884N78066Orlandi Properties LLC · Blairstown, NJBuilt 1968 · S/N 17257470N7806DHillegeist Tracy L · Beverly, KSS/N 22-5453N7806GAircraft Management Services Inc · Milton, FLBuilt 1970 · S/N 17259506N7806NTab Air Time LLC · Longmont, COBuilt 1968 · S/N 28-5257N7806PSpires Kenneth G · Seville, OHBuilt 1962 · S/N 24-3025N7806VMouriz Javier · Leesburg, FLBuilt 1964 · S/N 2790N7806YHhozapnv-LLC · Las Vegas, NVBuilt 1965 · S/N 30-885N78074Bartholomew Donald B · Gardnerville, NVBuilt 1946 · S/N 2074N78076Clinton Aeroclub · Clinton, IABuilt 1968 · S/N 17257472N78078International Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17257473N7807GLake Of The Woods Aviation LLC · Baudette, MNS/N 17259507N7807NBwh Leasing LLC · Lewes, DEBuilt 1968 · S/N 28-5258N7807SSmith Travis T · Watsonville, CABuilt 1976 · S/N 584-76N7807VMad Dog Aviation LLC · Minot, NDBuilt 1964 · S/N 2791N7807YMcv2021 LLC · Saint Augustine, FLBuilt 1965 · S/N 30-886N78083Holcomb Garry · Point, TXBuilt 1946 · S/N 2083N78086Drake Ronald N · Helena, MTBuilt 1968 · S/N 17257475
Back to AD 90-04-06 R1