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.

N72TGuazzerotti Fred · Mooresville, NCBuilt 1979 · S/N AA5B1086N72TDHerzog Eric M · New Waverly, TXS/N 1076N72VBVan Bladeren Ronald W · Vancouver, WABuilt 2003 · S/N 81548N72WACrosby Seth J · Anchorage, AKS/N WA-72N72WJKinnard Harris P · Pensacola, FLBuilt 1988 · S/N 72N72WLSingleton Colin · Walkerton, INBuilt 1994 · S/N 21063N72WMPalmer Phillip · Manchester, NHBuilt 1986 · S/N 6746N72WNPatmor Richard D Trustee · Dayton, NVBuilt 2006 · S/N 879-320-676N72WRFratzke Nathan A · Sterling, AKS/N 18-8982N73001Spooter Air LLC · Obion, TNBuilt 1976 · S/N 17267232N7300DClendaniel Randon · Desert Hot Springs, CAS/N 22-5087N7300LBarlow Tyrone J · St George, UTBuilt 1972 · S/N AA5-0230N7300WTaylor Robert P · Bothell, WABuilt 1963 · S/N 28-1064N7300YAdriatic Holdings LLC · Cheyenne, WYBuilt 1964 · S/N 30-341N73010Rico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17267235N73015Alameda Flying Club Inc · Richmond, CABuilt 1976 · S/N 17267238N7301DGrant Cary · Cave Creek, AZBuilt 1957 · S/N 22-5088N7301FMcpherson Alan · Big Bend Ntl Park, TXBuilt 1968 · S/N 28-25213N7301GFreeport Flyers Inc · Freeport, ILBuilt 1970 · S/N 17259001N7301JJach Joshua Spenser · Grand Prairie, TXBuilt 1968 · S/N 28-24596N73020Ajf Enterprises LLC · Des Moines, IABuilt 1976 · S/N 17267239N73028Halley Craig H · Lanai City, HIBuilt 1976 · S/N 17267241N7302GSmith Neil W · Rincon, GABuilt 1970 · S/N 17259002N7302YJohnson Robert Daniel · Seabrook, TXBuilt 1964 · S/N 30-345N7303FAyrey Elias · Bellingham, WABuilt 1968 · S/N 28-25215N7303JButtleman Robert L · Traverse City, MIBuilt 1968 · S/N 28-24588N73040Goulding Brian K · Roswell, GABuilt 1976 · S/N 17267247N73041Max Air Aviation LLC · Carrollton, GABuilt 1976 · S/N 17267248N73043Six Ten Ventures LLC · Cedar Hill, TXBuilt 1976 · S/N 17267250N7304FReid Brian S · Merced, CAS/N 28-25216N7304GChapman David C · Summersville, WVBuilt 1970 · S/N 17259004N7304JAdk Flying Club Inc · Ballston Spa, NYBuilt 1968 · S/N 28-24648N7304YN3024d LLC · Reno, NVBuilt 1964 · S/N 30-349N73054Blue Wings LLC · Spokane, WABuilt 1976 · S/N 17267253N7305JMallozzi Anthony M · Norwalk, CTBuilt 1968 · S/N 28-24636N7305LHill Stephen C · Fort Collins, COBuilt 1978 · S/N A1520780N7305YRegistered aircraftBuilt 1964 · S/N 30-350N73063Oregon State Flying Club · Corvallis, ORBuilt 1976 · S/N 17267256N73068Christensen Gary D · Alliance, NEFirst renewal noticeBuilt 1976 · S/N 17267259N73069Eagle Sky Patrol Inc · Deadwood, SDBuilt 1976 · S/N 17267260N7306DJ S H Farms Inc · Hermiston, ORBuilt 1957 · S/N 22-5093N7306EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17272081N7306FMeans James · Burleson, TXS/N 28-25219N7306KKutschera Thomas C · Youngsville, NYBuilt 1950 · S/N 20-216N7307DKnight Todd A · Grimes, IAS/N 22-5095N7307FEllis Johnathan · Evansville, WYS/N 28-25220N7307JAlmonte Duran Arquimedes · Paterson, NJBuilt 1968 · S/N 28-24640N7308CChandler Air Service Inc · Chandler, AZBuilt 1975 · S/N 28-7625075N7308GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259008N7308JMacdermaid Harry R · Kenai, AKFirst renewal noticeBuilt 1968 · S/N 28-24616
Back to AD 90-04-06 R1