OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,367

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.

N12055Twigg John M · Pittsburgh, PABuilt 1974 · S/N 79N1205TAmerican Aircraft Management LLC · Irving, TXBuilt 1972 · S/N 28-7225422N1205UBordeaux Marvin · Willcox, AZBuilt 1976 · S/N 17266904N1205XOsborn Aviation LLC · Claude, TXBuilt 1963 · S/N 183N12066Grey Kenneth P · Snowflake, AZS/N 2066N1206APelham Aircraft LLC · Dallas, TXBuilt 1966 · S/N 301206N1206EStrassburg Wayne W · Galena, AKFirst renewal noticeS/N 990-77N1206TCps 1 LLC · Pelham, ALBuilt 1972 · S/N 28-7205266N1206XNlw 1 LLC · Washington, UTS/N 184N1207Cavanaugh Air LLC · Addison, TXBuilt 1940 · S/N 75207N1207PN73481 LLC · Ault, COBuilt 1955 · S/N 23-223N1207UKasakoff Lloyd · Diamond Bar, CAS/N 17266906N1207XPbc LLC · Missoula, MTS/N 001N1208XCartaya Lazaro C · Miami, FLBuilt 1963 · S/N 2611N12090Diaz Aviation LLC · Mount Upton, NYBuilt 1973 · S/N 17261800N12091K D Farms Inc · Cosmos, MNBuilt 1973 · S/N 17261801N12095Ciddio Mark S · Sebastopol, CABuilt 1975 · S/N 17702385N12097Aerolease Aviation Rental LLC · Cartersville, GABuilt 1973 · S/N 17261807N12098Traywick James D · Cope, SCBuilt 1973 · S/N 17261808N1209LHarrist Robert K · Fort Worth, TXBuilt 1975 · S/N 714N120BSShain Bill R · Coal City, ILBuilt 2003 · S/N 004N120CVasquez Bernie W · Esparto, CAS/N 81N120CDJackson Farms Callahan Division LLC · Callahan, FLBuilt 1974 · S/N 28R-7435315N120CFMatts Cats LLC · Osceola, WIBuilt 2007 · S/N TC0707018N120CPPorter Charles J · Camas, WABuilt 2012 · S/N 001N120DFFormsma Douglas A · Floral City, FLBuilt 2011 · S/N 70535N120DSElement Aero LLC · Chicago, ILBuilt 2002 · S/N 40.220N120ESell Mark R · Woodbury, PABuilt 1965 · S/N 1N120JLCook Cecil C · Newland, NCBuilt 1996 · S/N AV1041N120KHPackard Randall C · Anchorage, AKS/N 18-3511N120KTPlane Sense LLC · Helena, MTBuilt 2010 · S/N 2195N120LMBrown Kenneth B · Sequim, WABuilt 2003 · S/N 90120N120MCFlandry Frederick C · Columbus, GAS/N 1339N120MFJohnson Edward E · Rickreall, ORS/N 0012N120MGParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020071N120NPPowelson Mark · Pataskala, OHS/N JM-1N120PWBrookhaven Aviation LLC · Brookhaven, MSS/N 28-7415078N120RDDecesare George D · Danville, CABuilt 1956 · S/N DH-89N120RHAir Puerto Rico Corp · Aguadilla, PRBuilt 1978 · S/N 44-7995118N120RROrr Samuel L · Cleveland, GABuilt 2022 · S/N 001N120SJFessler Steven W · Palmer Lake, COBuilt 2015 · S/N 81634N120TMurphy Janet A · Stafford, KSBuilt 1952 · S/N 18-2234N120TUPaula LLC · Ault, COBuilt 1946 · S/N 8934N120XPHorton Richard · Winchester, NHS/N 120N120ZZCumulus Holdings LLC · Wilmington, DES/N 18-8107N12100Tita LLC · Fajardo, PRBuilt 1973 · S/N 17261810N12104Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261812N12105N12105 LLC · Tavares, FLBuilt 1973 · S/N 17261813N1210ACaneen Jeremy M · Wasilla, AKBuilt 1951 · S/N 18-823N1210GLingbeck Gary L · Lena, ILBuilt 2019 · S/N 07180011
Back to AD 90-04-06 R1