OpenAirDocs.org
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.

N4927HOlhughes LLC · Staplehurst, NEBuilt 1948 · S/N 11-797N4928HAaberg Ronald N · Pedro Bay, AKBuilt 1948 · S/N 11-805N492APPyka Paul P · Austin, TXBuilt 2014 · S/N 05-5657N4930MCinquanta Daril · Arvada, COBuilt 1947 · S/N 111630N4933MPilster Larry · Alzada, MTBuilt 1947 · S/N 11-1563N4938MAbel William F · Billings, MTBuilt 1947 · S/N 11-1610N4939HMassas LLC · Fairbanks, AKBuilt 1948 · S/N 11-814N4942MVold Steven A Trustee · Billings, MTBuilt 1948 · S/N 11-549N4943HRohl Richard · Euclid, OHBuilt 1948 · S/N 11-819N4946HKing Matthew E · Tivoli, NYBuilt 2015 · S/N 1903N4948HStanton Sport Aviation · Stanton, MNBuilt 2008 · S/N CC11-00072N494AKIngram Allen · Eagle River, AKBuilt 1948 · S/N 15AC-75N494RAAstra Integrated Technologies LLC · Rockledge, FLBuilt 1967 · S/N 15066996N4950Ayers Walter L · Spokane, WABuilt 2019 · S/N 1N49500Chain Steven R · Cottonwood, CABuilt 1942 · S/N G-3N4952HLeyva Gregory G · Wilbur, WABuilt 1948 · S/N 11-827N4952VMartin Ryan L · Moses Lake, WAS/N 47-822N4953HRay Jonas R · Lakebay, WABuilt 1948 · S/N 11-818N4955MBlake Clark D · Belle Fourche, SDS/N 11-440N4955VSindlinger Lyle J · Puyallup, WABuilt 1947 · S/N 47-841N4956HNewton Donald H · Lewistown, MTFirst renewal noticeS/N 11-830N4957GSanford Mark J · Ithaca, NYBuilt 1947 · S/N 11-9N4957HHalsted Barry J Trustee · Sequim, WABuilt 1948 · S/N 11-831N4957MHarris Lloyd A · Bozeman, MTBuilt 1948 · S/N 11-443N4958HWeil Susan L · Minden, NVBuilt 1948 · S/N 11-832N49595Zulu Flight LLC · Washougal, WABuilt 1944 · S/N G-113N4959MDowns M Todd · Stephenville, TXBuilt 1948 · S/N 11444N495ZZach Brian D · Loveland, COBuilt 1975 · S/N 15076595N4960HPadden Kelly R · Ludlow, SDS/N 11-834N4960RUnited States Air Force Owner · Cannon Afb, NMBuilt 1967 · S/N 17256296N4961HMarquart Ricky L · Lakota, NDBuilt 1948 · S/N 11-835N4961MBarnette James S · Queenstown, MDS/N 11-447N4962MRegistration Pending · Beeville, TXRegistration pendingBuilt 1948 · S/N 11-448N49635Christie Ian A H · Limon, COBuilt 1986 · S/N 58N4965MClark Ernest Edgar · Spearfish, SDBuilt 1948 · S/N 11-451N4966HMeyer Chester A · Ekalaka, MTBuilt 1948 · S/N 11-840N4967MPietsch Warren A · Minot, NDBuilt 1948 · S/N 11-453N4968MAerial Crop Care Company · Hebron, NDBuilt 1948 · S/N 11-455N4969RUnited States Air Force Owner · Offutt Afb, NEBuilt 1967 · S/N 17256323N49705Dickens Todd H · Morganton, NCS/N 058B-8272N4971HNesin Christopher G · Chattanooga, TNBuilt 1948 · S/N 11-845N4971RScherer Sid S · Napa, CABuilt 1967 · S/N 17256325N4972RUnited States Air Force · Apo, APBuilt 1967 · S/N 17256326N4974RMcpherson Marvan T · Oklahoma City, OKS/N 17256328N4975HMorris Shannon D · Deadwood, SDBuilt 1948 · S/N 11-854N4979RUnited States Air Force · Offutt Afb, NEBuilt 1967 · S/N 17256333N497RAMartin Anthony M · Beebe, ARBuilt 1967 · S/N 17256273N4981RUnited States Air Force (Owner) · Offutt Afb, NEBuilt 1967 · S/N 17256335N4982VMcnamee Michael P · Anthony, NMBuilt 1943 · S/N 43-560N4983HGelinger Joseph J · Las Vegas, NVBuilt 1948 · S/N 11-863
Back to AD 94-05-05 R1