AD 94-05-05 R1

Registered aircraft · 26,231

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:94-05-05-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:94-05-05-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.

N4240UDennis P Berky Enterprises LLC · Winder, GAS/N 15060240N4240VLadage Terry L · Champaign, ILBuilt 1948 · S/N 18596N42417Mace Thomas Richard · Jacksonville, FLS/N 14678N4241FPankhurst Terrell K · Lauderdale, MSBuilt 1958 · S/N 46141N4241LAshland Flyers LLC · Bayfield, WIBuilt 1966 · S/N 17254310N4242CCas LLC Trustee · Ballinrobe Co MayoS/N 172-49187N4242EMorrell Samuel C · Lake City, MIBuilt 1947 · S/N 11CC-127N4242FChronis Marc D · Pembroke, NHBuilt 1958 · S/N 46142N4242HWebb Greg · Sweetwater, TNBuilt 1949 · S/N 15304N4242LHannon Douglas L · Yakima, WABuilt 1966 · S/N 17254311N4242MPapineau John B · Atchison, KSBuilt 1947 · S/N 13713N42432Wilson Mickey R · Skagway, AKBuilt 1945 · S/N 14696N4243FEagle Glen Veterinary Services Inc · Corona, CAS/N 46143N4243LNorth Central Marketing Inc · Cranston, RIBuilt 1966 · S/N 17254312N4243UN4243u LLC · Wilmington, DEBuilt 1963 · S/N 15060243N42443Older Dan · Bellingham, WABuilt 1945 · S/N 14709N42445Grammer Samuel Emmett Jr · Wasilla, AKS/N 14711N42447Brown Jon K Administrator · Winter Haven, FLBuilt 1946 · S/N 14713N4244ANunn Marvin T · Lovell, WYBuilt 1947 · S/N 7BCM-48N4244ETucker Alan K · Taberg, NYBuilt 1947 · S/N 11CC-130N42455Idaho Aviation LLC · Rexburg, IDS/N 14722N4245LAero Missions Inc · Sylacauga, ALBuilt 1966 · S/N 17254314N4245NSell Scott F · Moody, TXS/N 13716N42468Barton Douglas A · Moorpark, CABuilt 1945 · S/N 14735N4246EHansen Karl G · Waxahachie, TXBuilt 1947 · S/N 11CC-129N4246VMesserly John A · Altus, OKBuilt 1948 · S/N 18602N42480Clegg Stephen A · Port Orange, FLBuilt 1945 · S/N 14749N42481Smiley Neil G · Clover, VABuilt 1945 · S/N 14750N4248FWilcox Ross P · Newark, DEBuilt 1958 · S/N 46148N4248UEyles Benson G · Hampden, MEBuilt 1963 · S/N 15060248N42494Goebel William R · Rhome, TXBuilt 1945 · S/N 14765N42497Mission Aviators LLC · Spring, TXBuilt 1945 · S/N 14768N42498Beaver Barry G · Shelby, NCBuilt 1945 · S/N 14769N4249EPerron Ted J · White Bear Lake, MNBuilt 1947 · S/N 11CC-133N4249LKraus Gary L · Holbrook, PABuilt 1966 · S/N 17254318N4249NCessna 140 LLC · Taylor, MOS/N 13720N424BCPikeside Flying Club Inc · Martinsburg, WVBuilt 1964 · S/N 17252171N424EFGullet Samuel H · Lafayette, LABuilt 2011 · S/N AF-001N42500Fowler Pamela J · Zebulon, NCBuilt 1945 · S/N 14772N42509Lake Placid Flyer LLC · Lake Placid, FLS/N 14781N4250LKnight Aire LLC · Simpsonville, SCBuilt 1966 · S/N 17254319N4250UBrownfield Bruce · Oak Park, CABuilt 1963 · S/N 15060250N4250VSnyder Michael Scott · Erie, COBuilt 1948 · S/N 18606N42523Sale Reported · Herriman, UTSale reportedBuilt 1945 · S/N 14796N4252LStephani Timothy M · White Lake, WIBuilt 1966 · S/N 17254321N4252NEads Arthur H · Jackson, OHBuilt 1947 · S/N 13723N4252V212 Investments Of Montana LLC · Owasso, OKBuilt 1948 · S/N 18608N4253EPrice James A · Melba, IDBuilt 1947 · S/N 11CC-136N4253UConrad Chace D · Maryville, TNBuilt 1963 · S/N 15060253N4254FRed Baron LLC · Davis City, IABuilt 1958 · S/N 46154
Back to AD 94-05-05 R1