AD 94-05-05 R1

Registered aircraft · 26,232

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.

N823PWSpradley Jeff D · White Springs, FLBuilt 1964 · S/N 17250896N823WSMcinturf Paul A Jr · Childress, TXBuilt 1967 · S/N 15066175N823ZMarther Thomas L · Albion, PABuilt 1967 · S/N FS1N8240F14a Flying Club Inc · Mooresville, NCBuilt 1966 · S/N 15064340N8240LCactus To Clouds Aviation LLC · Indio, CABuilt 1967 · S/N 17256440N8241BBalint Jozef · Fort Worth, TXBuilt 1956 · S/N 36041N8241URegistration Pending · Casa Grande, AZRegistration pendingBuilt 1964 · S/N 17252141N8241XRotormate LLC · Royse City, TXBuilt 1961 · S/N 17248741N8242BLibby Robert E · Windham, MEBuilt 1957 · S/N 36042N8242XSadique Said-Hesamadine · Fairfax, VAS/N 17248742N82439Weigel John C · Natick, MABuilt 1946 · S/N 7AC-1072N8243XDemetreu Thomas J · Almond, NYBuilt 1961 · S/N 17248743N8244AMiles Robert A · Maupin, ORBuilt 1952 · S/N 25096N82458Barr Bruce A · Lander, WYS/N 7AC-1091N8245AAdriatic Holdings LLC · Cheyenne, WYBuilt 1952 · S/N 25097N8245FMorisette Michael W · Antelope, CABuilt 1966 · S/N 15064345N8246BBoyer Christopher · Bozeman, MTBuilt 1957 · S/N 36046N8246FTalikka Todd · Paulding, OHBuilt 1966 · S/N 15064346N8246LPatak Eva L · Ennis, TXBuilt 1967 · S/N 17256446N8247BDoughty Robert W · Casa Grande, AZBuilt 1957 · S/N 36047N8247FCarson Leonard H · Chesapeake, VAS/N 15064347N8247LKnepp Terry · Montgomery, INBuilt 1967 · S/N 17256447N8247UComeau Paul D · Walden, NYBuilt 1964 · S/N 17252147N82485Strom Kerry · Portal, NDBuilt 1946 · S/N 7AC-1122N8248AEllis John D · Hodgenville, KYBuilt 1952 · S/N 25100N8248FLucia Steven R Sr · Agawam, MAS/N 15064348N8248LBattleshaw Raymond · Weidman, MIBuilt 1967 · S/N 17256448N8248URobison Wm Lee · Smithville, MOBuilt 1964 · S/N 17252148N8249TTolmachev Nikolay A · Anchorage, AKBuilt 1960 · S/N 17556949N8249UDracka Charles L · Port Clinton, OHS/N 17252149N8249XDish Technologies LLC · Elm City, NCBuilt 1961 · S/N 17248749N824RJScaber Daniel · Ormond Beach, FLS/N 502N8250ARyan Craig M · Corona Del Mar, CAS/N 25102N8250BMortenson Daniel R Trustee · Newhall, CABuilt 1957 · S/N 36050N8250FRyan Good Aviation LLC · Sioux Falls, SDS/N 15064350N8250LStieler David C · Marlette, MIBuilt 1967 · S/N 17256450N8250SRegistration Pending · Statesville, NCRegistration pendingBuilt 1965 · S/N 15061850N8250UCalderon Daniel · Orlando, FLS/N 17252150N8250XVolk Kenneth Lee · Marshall, TXBuilt 1961 · S/N 17248750N82515Pangelinan Regina Mafnas · Dublin, CABuilt 1946 · S/N 7AC-1152N8251AJulius William C · Julesburg, COS/N 25103N8251TSkylark 61 LLC · Fair Oaks, CAS/N 17556951N8251XInman Charles E · Havre, MTBuilt 1961 · S/N 17248751N825225 Pm Inc · Nampa, IDBuilt 1946 · S/N 7AC-1159N8252ADuane Peters · Anchorage, AKBuilt 1952 · S/N 25104N8252LSky And Summit Aviation LLC · Suwanee, GABuilt 1967 · S/N 17256452N8253FSinclair Jerry D · Watonga, OKBuilt 1966 · S/N 15064353N8253LKostroski Larry J · Tucson, AZBuilt 1967 · S/N 17256453N8253THolzgrove Daniel R · Detroit Lakes, MNBuilt 1960 · S/N 17556953N8253XMasters Mission · Robbinsville, NCS/N 17248753
Back to AD 94-05-05 R1