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.

N696RCastro Wladimir · Carolina, PRBuilt 1976 · S/N 17267360N696RJWeitman Jim Trustee · Decatur Island, WAFirst renewal noticeBuilt 1953 · S/N 18-3363N696RKClassic Aviation Inc · Pella, IABuilt 1992 · S/N 20193N696SHGurry Deirdre M · Pt Pleasant, NJBuilt 2004 · S/N 22755N696SMSk Aircraft LLC · Anchorage, AKBuilt 1954 · S/N 18-3309N696SPMj Paws LLC · Wilmington, DEBuilt 1997 · S/N 791-97N6970HPerella James C · Cub Run, KYBuilt 1975 · S/N 17265671N6970QWalker Joshua D · Denison, TXBuilt 1968 · S/N MB-317N6970UCampbell Steven D · Henderson, NVBuilt 1964 · S/N 330N6971DVan Wagner Aerial Media LLC · Hollywood, FLS/N 18-5497N6971JMurphy David Charles · Rancho Cucamonga, CABuilt 1976 · S/N 28-7625263N6971QRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1968 · S/N MB-318N6971TTodaro Rodney F · Tullahoma, TNBuilt 2004 · S/N SRE041N6971UStephen Jacoby A · Coconut Creek, FLS/N 331N6971WPop-A-Top Corp · Nashville, MIBuilt 1965 · S/N 28-21169N69721Auburn Cord Duesenberg Museum · Auburn, INBuilt 1943 · S/N 77-152N6972HWoodstock Aviation LLC · Anchorage, KYBuilt 1946 · S/N 20214N6972JBicker Farms Lllp · Tioga, NDBuilt 1976 · S/N 28-7690445N6972KCawley Rebecca L Personal Representative · Lewiston, IDBuilt 1950 · S/N 20-77N6972RWhite Robert Graydon · Damascus, ORBuilt 1976 · S/N MC-323N6972UAyres Floyd Dean · Leavenworth, KSBuilt 1964 · S/N 422N6972WPryce James T · Ebensburg, PABuilt 1965 · S/N 28-21170N6973HScheerer Jill · Sag Harbor, NYBuilt 1975 · S/N 17265673N6973JStracener Adam · Pittsburg, TXBuilt 1976 · S/N 28R-7635369N6973KSmith Scott B · Sterling, AKBuilt 1950 · S/N 20-78N69745Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1955 · S/N 77-64N6974BHill Karl D · Igiugig, AKBuilt 1957 · S/N 18-5095N6974HWatsonair LLC · Carlsbad, CABuilt 1975 · S/N 17265674N6974PLiske Robert R · Chesterfield, MIBuilt 1960 · S/N 24-2116N6974RPaulsen David · Danville, CABuilt 1974 · S/N M-1587N6974VRegistered aircraftBuilt 1976 · S/N 22-1341N6974WRolland Jason J · Plumas Lake, CABuilt 1965 · S/N 28-21172N6975HRoot Shane G · Dighton, KSBuilt 1975 · S/N 17265675N6975QWeber Mark J · Hoven, SDBuilt 1968 · S/N MA-338N6975UBallou-Crawford Terry · Savannah, MOBuilt 1964 · S/N 335N6975VRodmark Aviation LLC · Jupiter, FLBuilt 1976 · S/N 22-1342N6976QBeech 76q LLC · Englewood, FLBuilt 1968 · S/N MA-339N6976UHumble Enterprises Inc · Valley Head, ALBuilt 1964 · S/N 336N6976WHorst Paul N · Lebanon, PAFirst renewal noticeBuilt 1965 · S/N 28-21174N6977QAnderson Gary D · Mechanicsville, MDBuilt 1968 · S/N MB-325N6977RSundowner Aviation Inc · Blaine, MNBuilt 1974 · S/N M-1620N6977UPoss Alexander C · Del Rio, TXBuilt 1964 · S/N 337N6978BVantrease Jerold Lee · Homer, AKS/N 18-5100N6978KMoore Jeffrey D · Blossvale, NYS/N 20-81N6978RDodson International Parts Inc · Rantoul, KSS/N MC-324N6978UDouglass Rick C · Bakersfield, CABuilt 1964 · S/N 338N6979DKohlhase Amy M · Anchorage, AKBuilt 1957 · S/N 18-5507N6979HWhitaker Ian S · Fort Mohave, AZBuilt 1975 · S/N 17265678N6979JImani Cameron · Lexington, KYS/N 28-7690446N6979QShlomo Yaron · Honolulu, HIBuilt 1969 · S/N MB-403
Back to AD 90-04-06 R1