OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N278SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0571N278ZKennerson Robert L · Palmer, AKBuilt 1981 · S/N 18-8109030N2790WMoondogger LLC · Yakima, WAS/N 1068N27913Kenyon Larry H · Grafton, OHS/N 4446N27918Reneau Thomas E · Midland, TXBuilt 2001 · S/N 2974N2791PMccarthy Air LLC · Palmer, AKBuilt 1955 · S/N 18-4426N2791WToothman John · Fairmont, WVS/N 1069N2792PVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1955 · S/N 18-4427N2793WSchneider Aerial Inc · Rugby, NDBuilt 1966 · S/N 3365N2793Y3y Leasing LLC · Englewood, COBuilt 1958 · S/N TD-166N2794Autry Timothy R · Stedman, NCBuilt 1971 · S/N 80AN2794MRifenburg Brian K · Ward Cove, AKS/N 12-1252N2795JEndeavour Flight Training Inc · Miami, FLBuilt 1979 · S/N 17273650N27967Dirigo Aerospace Solutions LLC · Sumner, MEBuilt 1940 · S/N 4482N2796WPennington Jeffrey B · Wrightwood, CABuilt 1966 · S/N 1072N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324N2797WWebb John H Jr · Paulding, OHBuilt 1966 · S/N 1073N2798EPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N 17271325N2798WSb Enterprise LLC · Marshall, TXBuilt 1966 · S/N 3367N279AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496507N279BWLee Douglas Anthony · Quincy, CAS/N 279N279CGDelaware State University · Dover, DEBuilt 2000 · S/N 2843399N279KMarble Rick W · Hartford, IABuilt 2014 · S/N 90859N279MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881020N279NDSowela Technical Community College · Lake Charles, LABuilt 2000 · S/N 2844034N279PWMauck Ryan S Trustee · Bend, ORBuilt 1985 · S/N 28-8590059N279RARusso Robert Michael · Pipersville, PABuilt 2005 · S/N 1392-2005N279RMBingham Sammy J · Manvel, TXBuilt 1992 · S/N 513N279RVStewart James L · Garden City, TXBuilt 2016 · S/N 90299N279TAspenglow LLC · Talkeetna, AKS/N 18-2393N279WCZabinski Ted W · Voorheesville, NYBuilt 1943 · S/N 77-160N279WMMcmartin Cutler J · Roanoke, TXBuilt 2021 · S/N 83392N279YRegistration Pending · Seneca, SCRegistration pendingBuilt 2008 · S/N 027N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306N27AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843768N27AWBold William H Jr · Annapolis, MDBuilt 1950 · S/N 4-2172BN27BATerrill Dana R · Port Angeles, WABuilt 1952 · S/N 22-819N27BEAir N Nautical LLC · Kalispell, MTBuilt 1998 · S/N 1418N27CMM & J Enterprises · Union, SCBuilt 1979 · S/N 571N27CWRebr Holdings LLC · Hernando, FLS/N 711N27DRN504fl LLC · Killeen, TXBuilt 2003 · S/N 24703N27DWFritschle Derek R · Olney, ILBuilt 1975 · S/N 94N27EGVetterman Larry D · Hot Springs, SDBuilt 2017 · S/N 062N27GFAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274608N27GSMazzola Michael · Baton Rouge, LABuilt 1977 · S/N 28R-7737160N27GWWatson Gary R · Modesto, CABuilt 1982 · S/N 0002N27GZKelly Kristofor · Belton, TXBuilt 2000 · S/N 01N27HCCranston Courtland L · Santa Rosa, CAS/N 1N27HRRemer Herbert I · Punta Gorda, FLBuilt 1999 · S/N 1444N27HSSchooler Harold L · Chico, CABuilt 1980 · S/N HS-1
Back to AD 90-04-06 R1