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.

N2417BRamsay Danny M · San Antonio, TXBuilt 1949 · S/N 3717N2417LBox Aviation Inc · Montgomery, ALBuilt 1966 · S/N 17255617N2417NZanuzoski Alan K · Hillsboro, ORBuilt 1947 · S/N 12666N2418DRogers Colin · Nevada City, CABuilt 1952 · S/N 20570N2418LF Sharp Aviation LLC · New Baltimore, MIBuilt 1966 · S/N 17255618N2418UGronning Chris D · Anchorage, AKBuilt 1963 · S/N 17250018N2419BFenn Michael J · Cloverdale, CAS/N 3719N2419DHansen Michael C · Roseville, CABuilt 1952 · S/N 20571N2419HPeterson Christopher A · Holt, FLBuilt 1946 · S/N 3044N2419JScheller Dwain A · Grand Rapids, MIBuilt 1966 · S/N 15065519N2419KMccann Michael · Springfield, ORBuilt 1947 · S/N 5146N2419L2419l LLC · Jackson, MIBuilt 1966 · S/N 17255619N2419YBaker Adam W · Germantown, TNBuilt 1962 · S/N 17249719N241NYColonial Aviation LLC · N Prince George, VAS/N 17256479N241PFForsyth Huston J · New Orleans, LAFirst renewal noticeBuilt 1973 · S/N 15075274N241SBFowler Gerald M · Hernando, FLBuilt 1946 · S/N 2131N2420DThomas Ryan J · Anchorage, AKBuilt 1952 · S/N 20572N2420ECabelka David M · Wausau, WIBuilt 1946 · S/N 7AC-5999N2420JRailsback Craig S · Huntington Beach, CAS/N 15065520N2420UAylmer Debra L · Black Creek, GABuilt 1963 · S/N 17250020N2421LPerdue Dustin W · Mooresville, INBuilt 1966 · S/N 17255621N2421UWiney Jonathan · Michigan City, INS/N 17250021N2421YAzflygal LLC · Phoenix, AZS/N 17249721N2422BRoki Classics LLC · Ogallala, NEBuilt 1949 · S/N 3722N2422LTravis Equipment LLC · Bee Cave, TXBuilt 1966 · S/N 17255622N2422VKeilman Geary P · Las Vegas, NVBuilt 1948 · S/N 14669N2423DWatkins Veronica J Trustee · Sparks, NVBuilt 1952 · S/N 20575N2423JHarris Patrick S · Chamberlain, SDS/N 15065523N2423KDarley Vernon O · Peachtree City, GABuilt 1947 · S/N 5150N2423LBig Hook Wilderness Camps LLC · Snowmass Village, COBuilt 1966 · S/N 17255623N2423UChord Line LLC · Homer, AKBuilt 1963 · S/N 17250023N2423VDtc Flying Club LLC · Sycamore, ILBuilt 1948 · S/N 14670N2423YStevens Mark E · Virgilina, VABuilt 1962 · S/N 17249723N2424KBlack Charles B · Lenoir, NCBuilt 1947 · S/N 5151N2424LRoberts Steven R · Palo Verde, AZBuilt 1966 · S/N 17255624N2424YBeek Nigel A · Pembroke Pines, FLBuilt 1962 · S/N 17249724N2425VHathaway Ben · Corvallis, ORBuilt 1948 · S/N 14673N2426DPalmer Bryon · Fall City, WABuilt 1952 · S/N 20578N2426KMoschell Randy Archie · Howard, SDBuilt 2000 · S/N 1361N2426L588 Delta LLC · Seminole, OKBuilt 1966 · S/N 17255626N2426UMartin Odis Bruce · Whitney, TXBuilt 1963 · S/N 17250026N2426YShamrock Flying Club Inc · Millersville, PABuilt 1962 · S/N 17249726N2427LT&T Aviators LLC · Buford, GAS/N 17255627N2427VN2427v LLC · Southbury, CTS/N 14675N2428YYellen Mark A · Mohave Valley, AZBuilt 1962 · S/N 17249728N2429BRegistration Pending · Oshkosh, WIRegistration pendingBuilt 1950 · S/N 3729N2429LCook Shawn R · Middlebury, VTBuilt 1966 · S/N 17255629N2429UNorman Jon Frederic Jr · Pineville, LABuilt 1963 · S/N 17250029N2429VMoriarty Gerry J · Anchorage, AKS/N 14677N2429YTucker Robert A · Kingston, OHBuilt 1962 · S/N 17249729
Back to AD 94-05-05 R1