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.

N8521YVan Devere Joseph C · Akron, OHBuilt 1970 · S/N 18-8886N8522CParylak Sean P · Colchester, CTBuilt 1953 · S/N 22-1230N8522DAdams Daryl S · Monticello, FLBuilt 1957 · S/N 22-5750N8522EHall Robert P · Decatur, ALBuilt 1959 · S/N 7GC-82N8522FHhi Farms LLC · Hamilton, MIBuilt 1971 · S/N 7800N8523PTubbs Jeffrey E · Kasilof, AKBuilt 1965 · S/N 18-8298N8523YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1684N8524DBig Bend Community College Foundation · Moses Lake, WABuilt 1957 · S/N 22-5752N8524YGasmire David C · Fredericksburg, TXS/N 18-8888N8526Core Tech Services & Supply LLC · Odessa, FLBuilt 1973 · S/N 449-73N8526FMinton Gabriel D · Wexford, PABuilt 1976 · S/N 28-7715279N8526KBaratta Richard J · Tower, MNBuilt 1956 · S/N 18-4953N8526YCarlile John D · The Villages, FLBuilt 1968 · S/N 30-1687N8526ZRyther John W · Austin, MNBuilt 1952 · S/N 20-900N8527CRegistered aircraftBuilt 1953 · S/N 22-1237N8527YHatbright Farm LLC · Wilmington, DEBuilt 1968 · S/N 30-1688N8528Somerville Billy J · Newport, NCBuilt 1973 · S/N 68-73N8528CJain Abhishek · Weehawken, NJBuilt 1976 · S/N 28-7615115N8528NWright Jeffrey C · Canby, ORBuilt 1942 · S/N 75-5045N8528YYoung David A · Lakeland, FLBuilt 1968 · S/N 30-1689N8529RElias Bernard J · Hampton, GABuilt 2021 · S/N 275N852ATWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250258N852CPPmbarrett Aviation LLC · Tucson, AZBuilt 1998 · S/N 17280485N852DAHendrix Rex · Pell City, ALBuilt 1975 · S/N 17264427N852HHoffart Paige D · Omaha, NEBuilt 2011 · S/N 81985N852NBurns Dwayne · Madera, CABuilt 2002 · S/N 1018N852NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 4495006N852PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843943N852TStudarus John E · Sacramento, CABuilt 1974 · S/N M-1528N852TXFormhals Steven P · Boerne, TXBuilt 2019 · S/N 11483N8530DCurcio Steve J · Oak Creek, WIBuilt 1957 · S/N 22-5758N8530YMouat Michael W · Hemet, CABuilt 1968 · S/N 30-1691N85348Passeno Mark A · Cheboygan, MIS/N 7AC-4088N8534CSalter Christopher D · Elberta, ALBuilt 1953 · S/N 22-1239N8535YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 30-1696N8536DAnderson Kel G · Alta, IABuilt 1957 · S/N 22-5768N8536XTrask John D · Portsmouth, VABuilt 1984 · S/N 1096N8536YEastern Flight Services Inc · Ronkonkoma, NYBuilt 1984 · S/N 0438N8537Kopaska Linda · Guthrie Center, IABuilt 1973 · S/N 452-73N8537MRegistered aircraftBuilt 1963 · S/N TD-534N8538DMarble Jere D · Dayton, NVBuilt 1957 · S/N 22-5769N8538JHarrison Gene R · Pendleton, ORS/N BROSE-0001N8538YRothstein Steven R · Punta Gorda, FLBuilt 1967 · S/N 30-1606N8539DEdens Ferlin C · Boone, COBuilt 1957 · S/N 22-5770N8539YTwinco Leasing LLC · Yacolt, WABuilt 1967 · S/N 30-1626N853AAAb Prop Plane I LLC · Metairie, LABuilt 2026 · S/N 28010044N853AKKase Gayle L · Wasilla, AKBuilt 2017 · S/N 6901N853BBSaile Daniel K · Skiatook, OKBuilt 1958 · S/N 1147N853CEWilford Boone · Cotter, ARBuilt 2012 · S/N 802RN853LCCox Leon F · Ruffin, NCBuilt 2013 · S/N 70299
Back to AD 90-04-06 R1