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.

N40VXHarder Steven R Trustee · The Sea Ranch, CABuilt 1998 · S/N 5040N40VZJump Jet LLC · Fort Worth, TXBuilt 2021 · S/N 40N40WFGrennell Brian M · Euless, TXS/N 30-971N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829N40XEFly Diamond Da40 N40xe LLC · Kalispell, MTBuilt 2002 · S/N 40.208N40XPRegistration Pending · Dallas, TXRegistration pendingBuilt 1976 · S/N K-040N40YLMeggers Roger D · Baker, MTBuilt 1996 · S/N 1327N41007Registered aircraftBuilt 1991 · S/N 243220N4100FGoldberg Mark · Massapequa Park, NYBuilt 1976 · S/N 28-7715006N4100GRegenald Michaud Aviation LLC · Willows, CABuilt 1968 · S/N 7910N4100PValley Flying LLC · Stuarts Draft, VABuilt 1959 · S/N 23-1580N4100YLofton Charles T · Georgetown, MNBuilt 1976 · S/N 944-76N4100ZMountain Escape LLC · Pullman, WAS/N 18-8114N4101JRichardson Howell · Gilbert, AZBuilt 1966 · S/N 28-22413N4101YBower Gary R · Miranda, SDBuilt 1976 · S/N 230-76N4102HForeman Guy W · Valparaiso, INBuilt 1978 · S/N 240617N4102PDoran Jeffrey T · Westerville, OHBuilt 1959 · S/N 23-1582N4103Port Townsend Aero Museum · Port Townsend, WABuilt 1953 · S/N 137N4103MMills Air Service Inc · Marstons Mills, MABuilt 1947 · S/N 12-3000N4103NKarpik Joseph Paul · Floodwood, MNS/N 680074N4103PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1583N4104Lewis Charles W · Newalla, OKBuilt 1953 · S/N 138N4104PSpooter Air II LLC · Willis, TXBuilt 1959 · S/N 23-1584N4104XBandy Carla Sr · Texarkana, TXBuilt 1968 · S/N 201N4104YBurgett Gary · Galena, AKBuilt 1976 · S/N 945-76N4104ZZelina William B III · Fort Greely, AKBuilt 1964 · S/N 18-8124N4105Rush David T · Durham, NCBuilt 1953 · S/N 139N4105HBonanza Valley Air LLC · Alexandria, MNBuilt 1978 · S/N 24-0621N4105MMameli Laurie K · Thomaston, GABuilt 1947 · S/N 12-2999N4105ZMccaughey Steven A · Winter Haven, FLBuilt 1964 · S/N 18-8126N4106JFlander Donald D · What Cheer, IABuilt 1966 · S/N 28-22419N4106NGioia Matthew M · Stafford, VABuilt 1968 · S/N 680035N4106XRossiter Andrew J · Vancouver, WAS/N 203N4106ZJohnson Royce D · Clinton, ARBuilt 1964 · S/N 188127N41071Zabinski Ted W · Voorheesville, NYBuilt 1941 · S/N 7824N4107MBeckham John T · Steelville, MOFirst renewal noticeBuilt 1947 · S/N 12-3005N4107NWest Main Auto Sales Inc · Tupelo, MSS/N 680075N4107PTm Aero Marine Inc · North Miami, FLBuilt 1959 · S/N 23-1562N4107XRedsun Oren Daniel · Fairfield, CAS/N 205N4107ZMissaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1964 · S/N 18-8128N4108ASwinehart Frank E · Lock Haven, PABuilt 1951 · S/N 18-867N4108JMetoyer Eric D · Yukon, OKBuilt 1966 · S/N 28-22421N4108ZRamstad Trygg J · Anchorage, AKBuilt 1964 · S/N 18-8130N4109HSchamber Thomas D · Oklahoma City, OKS/N 12-3545N4109NRoss George H · Delano, MNS/N 680036N4109ZAlf Robert R · Elkhorn, NEBuilt 1964 · S/N 18-8129N410BBBranscomb Brian K · El Granada, CABuilt 1985 · S/N 856N410BPWeiss Michael K · Paige, TXBuilt 2012 · S/N P01-P001/P002-P121N410BWHeffelfinger Darin W · Sterling, ILS/N 106N410EKGandy Donald T · Weatherford, TXBuilt 1976 · S/N 17702536
Back to AD 90-04-06 R1