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.

N7308KBradley Gary C · Orchard Park, NYBuilt 1950 · S/N 20-217N73091Rudder33 LLC · Grantham, NHBuilt 1976 · S/N 17267261N73093Yngsdal Dale A · Lino Lakes, MNBuilt 1976 · S/N 17267262N7309CKeefer Ralph E · Markle, INBuilt 1975 · S/N 28-7615051N7309KStanley Bryan D · Paso Robles, CABuilt 1950 · S/N 20-218N7309YGlaser William Burnett · New Smyrna Beach, FLS/N 30-296N730AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843792N730ACHeimbach Paul A · Steamboat Springs, COBuilt 1999 · S/N 1277-99N730BRHagan David W · Overgaard, AZBuilt 2002 · S/N 3554N730CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881736N730FNNguyen David · Cedar City, UTBuilt 1970 · S/N 28-26701N730HAHonaker Group LLC · Sellersburg, INS/N 17267246N730JKMcgrath Sean P · Plano, TXBuilt 2014 · S/N 70758N730KFZero Kilo Foxtrot LLC · Grand Junction, COBuilt 2016 · S/N KA12037223N730KPPeterson Robert Kd · Edgewood, TXBuilt 2005 · S/N 71268N730LBEarly Bird Aviation LLC · Rillito, AZBuilt 1974 · S/N 17263162N730LKBay Aero Ventures LLC · Port Clinton, OHBuilt 1977 · S/N 28-7890070N730MABennett Robert · Lutz, FLBuilt 2024 · S/N 2881697N730NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843887N730SASun Aircraft Management LLC · Ormond Beach, FLBuilt 2010 · S/N 2842363N730UOhio University · Albany, OHBuilt 2005 · S/N 2842224N73103Bfl Aviation LLC · Bakersfield, CABuilt 1976 · S/N 17267267N73105Jlk Management LLC · Kerrville, TXBuilt 1976 · S/N 17267268N7310CC3 Aircraft LLC · Burnet, TXBuilt 1975 · S/N 28-7690066N7310GMccall Freddie W Jr · East Brewton, ALBuilt 1970 · S/N 17259010N73113Top Flight Aviation Inc · Corona, CABuilt 1976 · S/N 17267269N73116Taildraggers Flyers Inc · Saint Joseph, MIBuilt 1976 · S/N 17267272N7311DRasmussen Kent L · Jetmore, KSBuilt 1957 · S/N 22-5099N7311FRegistered aircraftBuilt 1968 · S/N 28-25225N7311JBouley John T · Tolland, CTFirst renewal noticeBuilt 1968 · S/N 28-24658N7311YInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N 30-354N7312DJenkins James L · Lake Stevens, WABuilt 1957 · S/N 22-5100N7312KWilson David A · Garrison, IABuilt 1950 · S/N 20-221N73131Fremont Flight Academy LLC · Fremont, OHBuilt 1976 · S/N 17267280N73134Harborside Aviation Services Inc · Punta Gorda, FLBuilt 1976 · S/N 17267281N7313YPr Aeronautics LLC · Buffalo, SDBuilt 1964 · S/N 30-356N73146Oregon State Flying Club Inc · Corvallis, ORBuilt 1976 · S/N 17267287N73148Kinney Transportation · Columbia, MOBuilt 1976 · S/N 17267289N73149Good Flight Aviation LLC · Stockton, CABuilt 1976 · S/N 17267290N7314FAero Vantage Aviation Services LLC · Bayonne, NJBuilt 1968 · S/N 28-25272N7314GKittle Aviation LLC · Wichita, KSBuilt 1970 · S/N 17259014N7314WWelch Tully D · Brackettville, TXBuilt 1963 · S/N 28-1177N7315Frattasio Damian E · Pembroke, MABuilt 1989 · S/N T/Q 001N73151Hawaii Aviators LLC · Ewa Beach, HIBuilt 1976 · S/N 17267292N73154Bishop Services LLC · Ellisville, MSBuilt 1976 · S/N 17267293N7315DSkyhaven Airport Inc · Tunkhannock, PABuilt 1957 · S/N 22-5103N7315HGehrlein Rodney L · Waterford, PABuilt 1946 · S/N 20577N7316GCox Capital LLC · Rushville, MOS/N 17259016N7316KSantucci John D · Boonton, NJBuilt 1950 · S/N 20-225N7316WCallaboo LLC · Greenwood, SCBuilt 1963 · S/N 28-1180
Back to AD 90-04-06 R1