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.

N4172VMd Aero LLC · Somerton, AZBuilt 1948 · S/N 18505N4173VLohmeier George A · Indianapolis, INBuilt 1948 · S/N 18506N41741Funk Aeroplane Company · Basehor, KSBuilt 1946 · S/N 223N41754Lewis Mark E · Datil, NMBuilt 1973 · S/N 391-26-6346N4175FGay Clayton B · Villisca, IAFirst renewal noticeBuilt 1958 · S/N 46075N4175LColangelo Frank · New Preston, CTBuilt 1966 · S/N 17254244N4176EMacveigh Craig A · New Carlisle, OHS/N 11CC-78N4176FKruggel Kurt · Rancho Cucamonga, CABuilt 1958 · S/N 46076N4176NElsberry Freddie L · Lake Jackson, TXBuilt 1947 · S/N 13647N4177FWinkler Steve · Clarksburg, CABuilt 1958 · S/N 46077N4178EWest Michigan Aviation Inc · Kalamazoo, MIBuilt 1947 · S/N 11CC-80N4178VVan Dyke Robert L · Foley, ALBuilt 1948 · S/N 18511N4179EBell Scott A · Mc Alpin, FLBuilt 1947 · S/N 7BCM-174N4179LMorristown Flying Service Inc · Talbott, TNBuilt 1966 · S/N 17254248N4179NGauntt Stephen R · Kennewick, WAS/N 13650N4179UParks Daniel J · Milton, FLBuilt 1963 · S/N 15060179N4179VSchmidt David · Brooksville, MSBuilt 1948 · S/N 18512N417JGRice Clifford H Sr · Natchitoches, LABuilt 2008 · S/N AL-1123N417YBWaddell Richard K · Loveland, COBuilt 2017 · S/N L-116N4180CMckenney Bret · Billings, MTBuilt 1962 · S/N 12N4180EHesse Jeffry L · Talkeetna, AKS/N 11CC-81N4180LMcginn Robert W · Marion, NCBuilt 1966 · S/N 17254249N4180UFirst Flight Aviators · Lincoln, ILBuilt 1963 · S/N 15060180N4181AJoye Robert M · Casa Grande, AZBuilt 1966 · S/N 1N4181EShooting Star Services LLC · Rosamond, CAS/N 11CC-82N4181NDesrochers Robert F · Saint Johnsbury, VTFirst renewal noticeBuilt 1947 · S/N 13652N4182EJones Jacob R · Rockford, TNBuilt 1947 · S/N 11CC-83N4182FHong Jason S · Yorba Linda, CABuilt 1958 · S/N 46082N4182VCoulter Robert Allen · Granger, INBuilt 1948 · S/N 18515N4183FDurocher David T · Logan, UTFirst renewal noticeBuilt 1958 · S/N 46083N4183HLazor Ronald E · Middlefield, CTBuilt 1948 · S/N 15-66N4184FCastle Jame R · Douglasville, GABuilt 1958 · S/N 46084N4184LKleman Connie F · West Bend, WIBuilt 1966 · S/N 17254253N4184UDoughton Jonathan S · Jefferson, ORBuilt 1963 · S/N 15060184N4185CRodgers Samuel D · Casper, WYBuilt 1952 · S/N 20597N4185EHuffman Myron · Felda, FLS/N 11CC-86N4185HColton F D · Canby, ORS/N 15-68N4185NNew Daniel A · Deming, WABuilt 1947 · S/N 13656N4185UJennings William A · North Little Rock, ARBuilt 1963 · S/N 15060185N4185VHuff James L · Mars Hill, NCBuilt 1948 · S/N 18518N4186LG2g Aviation LLC · Wray, COBuilt 1966 · S/N 17254255N4186VJohnson David E · Rock Island, ILBuilt 1948 · S/N 18519N41889Bair Zach · Memphis, TNS/N 119N4188FBayliss Warren E · Orlando, FLBuilt 1958 · S/N 46088N4188LHlr Aviation LLC · Swan Lake, NYBuilt 1966 · S/N 17254257N4188NBascom Richard J Trustee · Elkhart, IABuilt 1947 · S/N 13659N4188U88 Uniform LLC · Jesup, GABuilt 1963 · S/N 15060188N4188VNtn3n LLC · Titusville, FLBuilt 1948 · S/N 18521N4189EJamieson Robert F · Friday Harbor, WABuilt 1947 · S/N 11CC-89N4189VEastman Gregory L · Pueblo, COS/N 18522
Back to AD 94-05-05 R1