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.

N8214YRegistration Pending · Harrisburg, SDRegistration pendingBuilt 1980 · S/N 28-8090362N82155Maroney Thomas L · Wasilla, AKBuilt 1975 · S/N 18-7809135N8215GGersten Iron · Spring Valley, CABuilt 1971 · S/N 177RG0115N8215NRyder Paul M · Charlotte, NCBuilt 1969 · S/N 28-25419N8215YGlassburn Teresa L · Winthrop, WAS/N 30-1343N82165Piper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 18-7809136N82166Minuteman Aviation Inc · Missoula, MTBuilt 1978 · S/N 18-7809137N82168Earth Center Adventures Inc · Haines, AKBuilt 1979 · S/N 18-7909061N82169Patterson Colin G · Ballston Spa, NYBuilt 1979 · S/N 18-7909063N8216CYoung Mikaela R · Fairbanks, AKS/N 18-4444N8216GFarrar Edwin L · Mansfield, OHBuilt 1971 · S/N 177RG0116N8216NShelton William B · Wildwood, MOBuilt 1969 · S/N 28-25420N8216PBobbitt Aviation LLC · Edenton, NCBuilt 1960 · S/N 24-2219N8216SNulton Enterprises LLC · Johnstown, PABuilt 1980 · S/N 28-8016328N8216WBritair Inc · Austin, TXBuilt 1965 · S/N 28-2349N8216YMedia Stew LLC · Carson City, NVS/N 30-1344N82172Wadekamper Leo V · Helena, MTBuilt 1979 · S/N 18-7909064N8217NG U M P S Flying Club Inc · Warner Robins, GABuilt 1969 · S/N 28-25421N8217QParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8016334N8217SValles Robert Jr · Spicewood, TXBuilt 1980 · S/N 28-8016335N8217YMaledy John Trustee · Salem, MOBuilt 1966 · S/N 30-1345N8218Kornegay Patrick C · San Benito, TXBuilt 1982 · S/N 18-8209005N82188Kubecka Daniel P · Edna, TXBuilt 1979 · S/N 18-7909068N8218CStargazer Aviation LLC · Clearwater, FLBuilt 1975 · S/N 28-7615081N8218NLee David · Palm Springs, CAS/N 28-25548N8218ZWingsleasing LLC · Wichita, KSBuilt 1980 · S/N 28-8090320N82190Salav LLC · Salisbury, NCBuilt 2018 · S/N 140344N82196Flying W Ranch Jv · Cooperstown, NDBuilt 1979 · S/N 18-7909070N8219GSchaum Jerome B · Machipongo, VABuilt 1971 · S/N 177RG0119N8219WA18 Missions LLC · Clinton, MOBuilt 1965 · S/N 28-2352N8219YDurden Julian F Jr · Twin City, GABuilt 1966 · S/N 30-1347N821BABarr Air Patrol LLC · Mesquite, TXBuilt 2007 · S/N 441-32/OB2N821BERas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816398N821BFDehn Timothy E · Braham, MNBuilt 2004 · S/N 90793N821BPPerdue Joseph D · Marshall, OKBuilt 2006 · S/N M-11-406N821ESSchmitz Mark J · Ames, IABuilt 2019 · S/N 81767N821FJ8th Dimension Enterprises LLC · Aurora, ORBuilt 2021 · S/N 28020032N821GMHoosier Aviation LLC · Terre Haute, INBuilt 1957 · S/N 23-1247N821KCIreland Robert D Jr · Gulf Breeze, FLBuilt 1972 · S/N AA5-0121N821LLindrooth Steven A · Perkasie, PABuilt 1976 · S/N AA5B0333N821PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881248N821PCJones Clark L · Cave Creek, AZS/N 18-8031N821PTHermes Ana Paula F · West End, NCFirst renewal noticeBuilt 1973 · S/N 28-7305600N821RPVan Cleave Raymond D · Kalispell, MTBuilt 1997 · S/N 92948N821SDGlobal Adventures N821sd LLC · Hollywood, FLBuilt 1985 · S/N 172-76485N821SHAero Leasing Inc · Brookings, ORBuilt 2005 · S/N 3774N82209Pearl Darwyn L · Bend, ORBuilt 1978 · S/N 18-7809153N82213Anderson Stephen A · Yuba City, CABuilt 1979 · S/N 18-8009031N8221GIshoy Glen · Indiana, PABuilt 1971 · S/N 177RG0121N8221NFedchenko Vitaliy · Cumming, GABuilt 1969 · S/N 28-25425
Back to AD 90-04-06 R1