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.

N8317TCalgonaire LLC · Seminole, TXS/N 17557017N8317VLynch Gerald C · Collinsville, OKBuilt 1966 · S/N 84N8318Rickey Donald Leslie · Murfreesboro, TNS/N 6223N83180John Cox LLC · De Witt, NEBuilt 1980 · S/N 28-8190135N8318CAviator Jet LLC · Dover, DES/N 28-7615087N8318EJust Planes Inc · Hobbs, NMFirst renewal noticeS/N 17272187N8318HParra Henry A Torres · Weston, FLS/N 28-8116121N8318QPenn Flight Academy LLC · Quakertown, PABuilt 1980 · S/N 28-8190130N8318RAir Wave Holdings LLC · Porter, TXBuilt 1966 · S/N 28-22189N8318VVetter Brent E · Helena, MTBuilt 1966 · S/N 46N8318YMaverick Air LLC · Wildwood, MOBuilt 1980 · S/N 28-8190134N8319LLaudon Piper C · Anchorage, AKS/N 17256519N8319WBlaker Martin O · Rough And Ready, CABuilt 1965 · S/N 28-2494N831APlane Fun Inc Tr Trustee · Snellville, GABuilt 1951 · S/N 22-132N831AC831ac Aero LLC · Ogden Dunes, INBuilt 2000 · S/N 868-2000N831AKJablonski Francis R III · Byron Center, MIBuilt 1994 · S/N 772N831ASChmiel Edward C · Barrington, ILBuilt 1958 · S/N 469-18N831BFHuddleston Edward L · Oaktown, INBuilt 1966 · S/N 28-3502N831BRAir Future Airways Corp · Miami, FLBuilt 1998 · S/N 172S8044N831GBDievendorf Gerry T · Columbia, SCS/N 284N831GRGrahn James A · Las Vegas, NVBuilt 1988 · S/N 831N831KTPilot Network Flyers LLC · Bastrop, TXBuilt 1974 · S/N M-1548N831LBWedekemper Steven E · Brighton, MIBuilt 2007 · S/N 515-2007N831MNSallee William T · Sylvania, OHBuilt 2019 · S/N 91445N831NDCirrus Aviation Inc · Sarasota, FLBuilt 1978 · S/N 28-7816351N831NQEslinger Carl W · Chouteau, OKBuilt 2018 · S/N 03N831PMAvier LLC · Beverly, MABuilt 2024 · S/N 2881735N831RHHanson Paul D · Evansville, INBuilt 1997 · S/N 789-97N831SHHutchison Eugene W · Armagh, PABuilt 2005 · S/N 3793N831TSWingsleasing LLC · Wichita, KSBuilt 1974 · S/N 28-7415485N831VZMelbourne Flight Training LLC · Melbourne, FLBuilt 1985 · S/N 17276416N83208Rothrock Cara J · Streator, ILS/N 28-8116124N8320AMendez Leonel Jr · Corpus Christi, TXBuilt 1995 · S/N 2510N8320CRiffle Bruce H · Chesterton, INBuilt 1975 · S/N 28-7690115N8320VThurman Randall N · Mcminnville, ORBuilt 1966 · S/N 399N8320WOracle Aviation LLC · Omaha, NEBuilt 1965 · S/N 28-2495N8320YKling Aviation Inc · Friendswood, TXBuilt 1967 · S/N 30-1460N8321CJackson Blane · Beaufort, NCBuilt 1975 · S/N 28R-7635147N8321HJust Plane Fellas LLC · Omro, WIBuilt 1980 · S/N 28-8116125N8321LArevalo Gilbert Jr · Loranger, LABuilt 1980 · S/N 28-8190136N8321MFox Two LLC · Camino, CABuilt 1980 · S/N 28-8190137N8321PSmoketown Helicopters LLC · Smoketown, PABuilt 1995 · S/N 2538N8321RThompson Grady R · Athens, ALBuilt 1966 · S/N 2822192N8321TRobinson Denise · Middletown, CTBuilt 1980 · S/N 28-8190140N8321WWeighman David R · Battle Creek, MIBuilt 1965 · S/N 28-2496N8322EHorton Ernest J III · Galveston, TXBuilt 1959 · S/N 1500N8322SAtp Aircraft 4 LLC · Wilmington, DEBuilt 1980 · S/N 44-8195014N8322V11 Point Aviation LLC · Alton, MOBuilt 1966 · S/N 65N8322WLickteig Eric Kirk Trustee · Ellensburg, WABuilt 1965 · S/N 28-2499N8322YDayhoff Miller Alice J · Springfield, OHBuilt 1967 · S/N 30-1463
Back to AD 90-04-06 R1