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.

N744SPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1944 · S/N 75-5732N744SGGimblin Robert Steven Trustee · Yuba City, CABuilt 2017 · S/N 582-2017N744VRElias Bernard J · Hampton, GABuilt 2000 · S/N 001N74501Barnes Michael N · Lindstrom, MNBuilt 1961 · S/N 1812N74502Land Dustin M · Bascom, FLBuilt 1961 · S/N 1813N74505Registration Pending · Redlands, CARegistration pendingBuilt 1961 · S/N 1816N74507Bas Part Sales LLC · Greeley, COBuilt 1961 · S/N 1818N7450GLewis Benjamin · Delano, MNBuilt 1970 · S/N 17259150N7450JBuchanan David · Elkin, NCBuilt 1968 · S/N 28R-30799N7450KMatelski Mark T · New Berlin, WIBuilt 1950 · S/N 20-361N7450WCreager Scott L · Visalia, CABuilt 1963 · S/N 28-1339N74510Hood Joseph L · Ann Arbor, MIBuilt 1962 · S/N 1904N74511A & D Wings LLC · Clarkston, MIBuilt 1961 · S/N 1822N74513Munasinghe Chanaka · Portland, ORBuilt 1961 · S/N 1824N74514Krupinski Floyd M · Chugiak, AKBuilt 1961 · S/N 1825N74516Daniel Gary T · Athens, GABuilt 1961 · S/N 1827N74517Linstad Daniel E · Canby, ORFirst renewal noticeBuilt 1961 · S/N 1906N7451JMoore Jimmy I · Beach City, TXBuilt 1968 · S/N 28R-30800N7451KHendry Joshua · Carthage, TNBuilt 1950 · S/N 362N7451WSamson Ag Flying LLC · Wilmington, DEBuilt 1963 · S/N 28-1340N74522Blue Line Holding LLC · Little Falls, MNBuilt 1961 · S/N 1833N74525Barnard Vaughn N III · Raleigh, NCS/N 1836N74527White Jesse J · Penn Valley, CAS/N 1838N74529Harris Nathan J · Preston, IDBuilt 1961 · S/N 1840N7452JMcaleer John D · Molalla, ORBuilt 1960 · S/N 18-7452N74533Whalen Shenandoah · Amelia, OHBuilt 1961 · S/N 1844N74535Rodgers Doyle W · Longview, TXBuilt 1961 · S/N 1846N7453DRomo Blaine Jeffrey · Dillingham, AKS/N 22-5219N7453GNorthwoods Flyer LLC · Jacksonville, FLBuilt 1970 · S/N 17259153N7453YStratus Air Services LLC · Punxsutawney, PABuilt 1964 · S/N 30-516N74541Premier Helicopters LLC · Carson City, NVFirst renewal noticeBuilt 2005 · S/N 3865N74542Bauerle Lucas W · Albuquerque, NMBuilt 1961 · S/N 1853N74545Hopkins Tim W · Cincinnati, OHBuilt 1961 · S/N 1911N74547Travierso Alan S · Farmington, UTBuilt 1961 · S/N 1913N74549Woodyard Tory · Mcloud, OKBuilt 1961 · S/N 1914N7454GDaniel Dewey R · Okeechobee, FLBuilt 1970 · S/N 17259154N7454PCreation Industries LLC · Middlefield, OHBuilt 1961 · S/N 24-2644N7454WPorter Robert D · Manchester, TNBuilt 1963 · S/N 28-1343N7454YOrthner Aviation LLC · Chattanooga, TNBuilt 1964 · S/N 30-517N74553Young John H · Sheridan, WYBuilt 1961 · S/N 1945N74555Pieszala John W · Larksville, PABuilt 1961 · S/N 1947N74556Gutierrez Juan · Sarasota, FLBuilt 1961 · S/N 1948N74557N74557 LLC · Kissimmee, FLBuilt 2005 · S/N 3900N7455DD'Amico Joseph J · Mount Ary, MDBuilt 1957 · S/N 22-5221N7455PEagles Aviation LLC · Rocklin, CABuilt 1961 · S/N 24-2645N7455RMcanelly Anthony J · Maricopa, AZBuilt 1966 · S/N 28-22000N7455SSharp Penny E · Ocala, FLBuilt 1991 · S/N 10043N7455WNicolai Tim A · Brandon, SDBuilt 1963 · S/N 28-1365N7455YTowns Bobby · Nashville, TNBuilt 1964 · S/N 30-518N74560Willett Lynn B · Wooster, OHBuilt 1976 · S/N AA5B-0251
Back to AD 90-04-06 R1