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.

N8299ELondon Corbin Airport Board · London, KYBuilt 1979 · S/N 17272185N8299JViking Aviation LLC · Chesapeake, VABuilt 1979 · S/N VAC-145-79N829AHochstatter Patrick J · Moses Lake, WABuilt 1951 · S/N 22-131N829BBaxter Thomas L · Stockbridge, GABuilt 1950 · S/N 6760N829BGGipson Robert E · Port Byron, ILBuilt 1968 · S/N 17700667N829BSStubbs Brian E · Knoxville, TNBuilt 2007 · S/N 22391N829FSPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1999 · S/N 17280795N829JBMathis Robert · Sandersville, GABuilt 1965 · S/N 34N829LBBuller Larry J · Bismarck, NDBuilt 2011 · S/N 73644N829PJMidwestern Twang Communications LLC · Evanston, ILBuilt 1970 · S/N 17701534N829RVNewhall Robert E II · Treasure Island, FLBuilt 2004 · S/N 70480N829RWCaylor Michael C · Valley View, TXS/N 25377N82BPKlump John · Alamogordo, NMBuilt 2003 · S/N 21988N82BZTeuber Gary J · Sister Bay, WIBuilt 1982 · S/N 28-8390017N82CFurrow Charles · North Dinwiddie, VABuilt 1981 · S/N 0001N82CEGbm Aviation LLC · Los Altos, CAS/N OSTERHUBER 0001N82DCAugust Aero LLC · Kalispell, MTBuilt 1983 · S/N 001N82DMPerry Timothy W · Marstons Mills, MABuilt 1978 · S/N 88N82EJJw Flyers LLC · Allen, TXBuilt 1976 · S/N AA5B-0234N82EPPosav Holdings LLC · Zephyrhills, FLBuilt 1978 · S/N 17271353N82EZFloyd Allen T · Erie, COBuilt 2015 · S/N 82N82FMF J Corporation · Wilmington, DEBuilt 1999 · S/N 80834N82FYBurbage Richard W · Wichita Falls, TXBuilt 2009 · S/N 82302N82GCVolk James E · Argyle, TXBuilt 2004 · S/N 60545N82GHMorrison Richard L · Lake Como, FLBuilt 1982 · S/N 1N82HABeller Ronald D · Morehead, KYBuilt 1976 · S/N 17702401N82HUOpatril Ron · Creede, COBuilt 2025 · S/N 3454N82HYJohnson Michael T · Moatsville, WVBuilt 2002 · S/N 2191N82JStewart Michael W · Snellville, GAS/N JH111N82JNNicholas Kim A · Kent, WABuilt 2004 · S/N 90150N82KLMcdaniel Michael Ray · Hampton Cove, ALBuilt 1977 · S/N 24-0280N82KMShartle Austin W · Fredericksburg, PABuilt 1988 · S/N KM-02N82KPCarter Doug A · Tower, MNBuilt 2024 · S/N 318RN82LMMartindale Harold L · Orange, TXBuilt 1984 · S/N 1215N82MReady Aim Flyer LLC · New Castle, DEBuilt 1958 · S/N TD-167N82MTMalo Blake Ridgway Trustee · Portland, ORBuilt 2017 · S/N 004N82NBMohillsmith Coulter · Temecula, CABuilt 2000 · S/N 001N82NDBaker David Jr · Louisville, KYS/N 0140N82NFN82nf LLC · Mckinney, TXBuilt 2013 · S/N 3188N82PDJames Gary S · Weatherford, TXBuilt 1984 · S/N PD1N82PLOilar Agricultural Services · Mcarthur, CABuilt 2008 · S/N 3047N82PMCollings Foundation Inc · Hudson, MABuilt 1976 · S/N AA5B-0250N82RRegistered aircraftS/N 24564N82RBBurns Robert A · Fort Myers, FLS/N 3524N82RDStrafford Cameron Cornell · San Diego, CAS/N 001N82RHHolte Brian J · Monticello, MNS/N 1-0003N82RJLynch James D Jr · Ocala, FLBuilt 1966 · S/N 30-1049N82SPMaiden Robert · Williamson, GABuilt 1958 · S/N DH-174N82TDSharpe Andrew M · Wildwood, MOBuilt 2024 · S/N 81150N82THBirrell Christopher James · Ottumwa, IABuilt 1999 · S/N 2042
Back to AD 90-04-06 R1