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.

N6010PSniffen Kirby K · Sycamore, OHBuilt 1959 · S/N 24-1104N6011FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020090N6011JSymond Clarence B · Eastover, NCBuilt 1978 · S/N MC-625N6011LBiondich Amy Sue · Rubicon, WIBuilt 1972 · S/N AA5-0111N6011QHikari Aviation Ltd · Torrance, CABuilt 1978 · S/N ME-100N6011UJin Jin Aviation LLC · Anchorage, AKBuilt 1978 · S/N ME-101N6012FSanders Flight Training Center · Jasper, ALBuilt 1965 · S/N TD-616N6012LCloudkicker Lc · Sioux Falls, SDBuilt 1972 · S/N AA5-0112N6012QClassic Aircraft LLC · West Point, NEBuilt 1965 · S/N 864N6012YBieszczad Wally · Bloomingdale, ILBuilt 1979 · S/N M-2106N60135Charles Ray Aviation LLC · Fleming Island, FLBuilt 1979 · S/N M-2105N6013DBennett Garrett Douglas · Bonners Ferry, IDBuilt 1956 · S/N 22-4665N6013LCraven Jeremy A · Winter Garden, FLBuilt 1972 · S/N AA5-0113N6013ZVandelay Aviation LLC · San Diego, CABuilt 1978 · S/N ME-112N6014PTwo Men And A Plane Inc · Dearborn, MIBuilt 1959 · S/N 24-1109N6014WLeaders Bob O · Clear Lake, MNBuilt 1964 · S/N 28-20014N6014YBackscheider Eric D · La Follette, TNBuilt 1997 · S/N 24367N6014ZSimpson Alena A · Blue Eye, MOBuilt 1979 · S/N M-2141N60156Shannon School Of Aeronautics LLC · Fredericksburg, VABuilt 1979 · S/N ME-147N6015FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020091N6015LWade Rolla R · Kingsport, TNBuilt 1972 · S/N AA5-0115N6015QBohlke LLC · Kingshill, VIBuilt 1979 · S/N ME-141N6015UN6015u LLC · Lakeview, NCS/N M-2135N6015ZOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-145N60165Caballero Arturo C · Clute, TXBuilt 1979 · S/N M-2145N6016DWells Roger M · Stratford, TXBuilt 1956 · S/N 22-4669N6016KRamsey Keith W · Morrison, TNS/N MC-646N6016LAssociated Aircraft LLC · San Diego, CABuilt 1975 · S/N 0710N6016QAbrahem Bishoy · Bakersfield, CABuilt 1965 · S/N 866N6016UAbbasi Babak · Escondido, CABuilt 1979 · S/N ME-156N6016XBeland Michael R · Maiden, NCS/N 1650N6016YClute Jack S · Valparaiso, INBuilt 1979 · S/N MC-650N6016ZPrestenbach Kyle A · Vacherie, LAS/N 25-19N60177Kelley Robert D · Barstow, CABuilt 1969 · S/N 15070126N6017WKarg James R · Paradise, TXBuilt 1964 · S/N 28-20017N6018DBader Ronald W · Montrose, MIBuilt 1956 · S/N 22-4671N6018FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020092N6018QWilson Reed · Arlington, VABuilt 1965 · S/N 868N60190Busha James P · Oshkosh, WIBuilt 1945 · S/N 76-91N60199Krystofiak Steven · Scottsdale, AZBuilt 1979 · S/N WA-12N6019DKuper Carl J II · Dalhart, TXBuilt 1956 · S/N 22-4672N601ABFdr601 LLC · Lewiston, IDBuilt 2012 · S/N 6-4994N601BSThird Coast Aircraft LLC · Mobile, ALBuilt 1970 · S/N 28R-35798N601CXRegistration Pending · Marion, TXRegistration pendingS/N 6-4842N601DGJackson Benjamin · Lagrange, GAS/N 63304N601DQSilver Eagles Aviation Association · Mesa, AZS/N 60334N601EAExecutive Air Transport Inc · Norton Shores, MIBuilt 1978 · S/N 28-7916124N601FTSanson Paul H · Deland, FLBuilt 1989 · S/N 2841195N601HCJohnson Timothy R · Owatonna, MNS/N 006N601HHHerman Joseph D · Marion, ILBuilt 2020 · S/N 6-6307
Back to AD 90-04-06 R1