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.

N613FLOwens William N · Lexington, NCBuilt 1971 · S/N 28-7125492N613KBPrecision Aero LLC · Wilmington, DEBuilt 1999 · S/N 835-99N613PCPrivitt Bret J · Forest Hill, TXBuilt 1999 · S/N 1255-98N613RVFlege Jordan T · Morrow, OHBuilt 2000 · S/N 80266N613SCMorgan John P · Atlanta, GABuilt 1994 · S/N 1N613SPAirmart Inc · Lexington, KYBuilt 2000 · S/N 172S8597N613VTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1986 · S/N VERMONT 0001N613XEMalinchak Louis · Bristow, OKBuilt 2007 · S/N 270N6140CNorth Coast Helicopter Service Inc · Napa, CABuilt 1948 · S/N 47N6140EIorio Jeffrey M · Tucson, AZBuilt 1958 · S/N 46240N6140JWeldy Mark L · Etna Green, INBuilt 1976 · S/N 28-7615311N6140KHepner Glenn L · New Port Richey, FLBuilt 1980 · S/N 17274169N6140WKing Donna K · Mount Pleasant, MIBuilt 1964 · S/N 28-20158N6140ZConnecticut Soaring Association Inc · New London, CTS/N 25-164N6141Black Shadow Aviation Inc · Georgetown, FLS/N 1506N61411Vincent Tarissa · Westminster, COS/N 1151N6141JRnt Air LLC · Mitchell, SDBuilt 1976 · S/N 28-7615312N6141LJohnson Stephen M · Westlake, TXBuilt 1970 · S/N AA1-0341N6141VWright Lawrence D · West Chester, PABuilt 1965 · S/N TD-614N6141ZRotor And Wing · Tioga, NDBuilt 1960 · S/N 25-165N6142DManbeck Michael R · Summerville, SCBuilt 1957 · S/N 22-4786N6142PAllison Trent Van · Southlake, TXBuilt 1959 · S/N 24-1243N6142SKelly Robert D · Sheboygan, WIFirst renewal noticeBuilt 1965 · S/N 18-50N6142WBurns Robert J · Loxahatchee, FLBuilt 1964 · S/N 28-20160N6142XHurt Ronald L · Smithville, TNBuilt 1977 · S/N 17269169N6143NTorikawa Domingojason K · Ewa Beach, HIBuilt 1969 · S/N MB-414N6143QSt Onge Andre E · Hooksett, NHBuilt 1981 · S/N 15285166N61447Overton Tommy · Cumberland Gap, TNBuilt 1995 · S/N 0007N6144DCarter Tim R · Morgan, UTBuilt 1957 · S/N 22-4788N6144LArtz Agri Sales LLC · Westhope, NDBuilt 1980 · S/N 15284364N6144NDunn Rick · Benton, ARS/N MB-415N6144VAir Flite Inc · Shawnee, OKBuilt 1996 · S/N 0037N6144WFiebelkorn Daniel S · Gregory, SDBuilt 1964 · S/N 28-20162N61458Dls Holdings Inc · Lewes, DEBuilt 1995 · S/N 0008N6145DLindsey Christopher T · Nesbit, MSBuilt 1957 · S/N 22-4789N6145LMichaud Martin R · Monte Vista, CABuilt 1970 · S/N AA1-0345N6145VMarshall University · Huntington, WVBuilt 1996 · S/N 0045N6145WRegistered aircraftS/N 28-20163N61465Bishop Michael D · Pulaski, TNS/N 12-3189N61468Nimmons Johnny F · Brookshire, TXBuilt 1943 · S/N L424ARN6146PMount Up Aviation LLC · Kirbyville, MOS/N 24-1247N6146QWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1981 · S/N 15285169N6147DRegistered aircraftBuilt 1957 · S/N 22-4792N6147EBuckley Michael J · Billings, MTBuilt 1995 · S/N S1707N6147HBietsch Sr Thomas R · Lincoln, CABuilt 1977 · S/N 28-7816229N6147RBloom James F · Clay City, KYS/N 172RG0094N6147WLister Stephen J · Sherman, ILBuilt 1964 · S/N 28-20166N61486Johnson Gary R · Carthage, NYBuilt 1998 · S/N 0084N6148HHicks Braden · Manson, IABuilt 1977 · S/N 28-7816230N6148JNorth Texas Flight Ventures LLC · Mckinney, TXBuilt 1976 · S/N 28-7615313
Back to AD 90-04-06 R1