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.

N8759NDisanto Rocco F · Morganton, NCBuilt 1969 · S/N 28-25580N8759VSmetters Jeffrey L · Crystal Lake, ILBuilt 1975 · S/N 202-75N875ADRegistration Pending · Independence, ORRegistration pendingBuilt 2004 · S/N 22707N875CFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020102N875GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881069N875LBeaman David · Knoxville, TNBuilt 1977 · S/N AA5B0672N875PMModys Peter B · Saint James City, FLBuilt 2017 · S/N 71957N875SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881744N875WSayre Matthew J · Manitou Beach, MIBuilt 2013 · S/N 001N8760CReindl Thomas A · Algonquin, ILBuilt 1976 · S/N 28-7615126N8760MRegistration Pending · Cheney, WARegistration pendingS/N M-548N87614Cawley Jeff W · Buckley, WABuilt 1941 · S/N 41A75N1N87618Ready Aim Flyer LLC · New Castle, DEBuilt 1948 · S/N 866N8761CSchlagel Cade P · Dillingham, AKBuilt 1953 · S/N 18-2848N8761MJohnson Gregory J · Port Orange, FLS/N M-549N87621Shackelford Gary L · Parrish, FLBuilt 1949 · S/N 869N8762DEpperson James R · Sand Springs, OKBuilt 1958 · S/N 22-5946N8762EPrewitt Russell · Statham, GABuilt 1976 · S/N 28-7625156N8762NKlyc Aviation LLC · Lake City, FLBuilt 1969 · S/N 28-25582N87638Apland Douglas C · Chippewa Falls, WIBuilt 1991 · S/N A001N8763EBodwell Keith J · West Cornwall, CTS/N 28-7615160N8764CMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7690160N8764EFa40 Plane LLC · New Port Richey, FLBuilt 1976 · S/N 28-7690202N8764GStrait Media LLC · Anchorage, AKS/N 15062864N8764J374dk Aviation LLC · Sand Springs, OKBuilt 1972 · S/N AA5-0116N8764YVenture West LLC · Mesa, AZBuilt 1969 · S/N 30-1920N8765CLatitude Aviation LLC · Spring, TXBuilt 1976 · S/N 28-7690161N8765EMoore Alex W · Deep Gap, NCBuilt 1976 · S/N 28-7690203N8765FSmith Nelson · Brighton, IAS/N 28-7790266N8765HN8765h LLC · Carthage, NCBuilt 1993 · S/N 1246N8765YBrady William H · Moorestown, NJBuilt 1969 · S/N 30-1921N8766DRatliff Steven L · Spring Grove, PABuilt 1958 · S/N 22-5952N8766ELoose Larry A · Jamestown, NDBuilt 1976 · S/N 28R-7635213N87675Hickey Aero Services LLC · White Hills, AZS/N 77-372N87678Benham John D · Blanco, TXS/N 19922N8767DGriffith Scott G · Newnan, GABuilt 1958 · S/N 22-5953N8767NAbernathy Larry D · Vernon, TXBuilt 1969 · S/N 28-25591N87687Dittmer Dean C · Bennett, COBuilt 1967 · S/N R172-0248N8768FReynolds Darryl G · Wills Point, TXBuilt 1962 · S/N 62-0092N8768NHammonds Benjamin J · Newcomerstown, OHS/N 28-25589N8768YVst Aviation LLC · Ball Ground, GAS/N 30-1924N8769ZFox Stanton C · Fairfax, VABuilt 1978 · S/N 177RG1358N876AJKnapp Adam G · Steamboat Springs, COBuilt 2005 · S/N 25423N876CMRybarczyk Mathias M · Burlington, WIBuilt 2020 · S/N 018142001N876DPassmore Stephen B · Lacrosse, WABuilt 1947 · S/N 108-2876N876EBLewis Aviation Inc · Wilmington, DEBuilt 2009 · S/N 82803N876LSThird Coast Aircraft LLC · Mobile, ALBuilt 2001 · S/N SRG 059N876SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881745N876TBHenderson Tyler J · Goodland, KSBuilt 1999 · S/N 20363N876TUDudley Aviation Services LLC · Wilmington, DEBuilt 2005 · S/N 7030
Back to AD 90-04-06 R1