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.

N172KRRose Kim M · Mount Vernon, OHBuilt 1965 · S/N 17252960N172LRDevillers Daniel R · Kalamazoo, MIBuilt 1960 · S/N 47607N172LWCrane Donald L · Kenai, AKBuilt 1967 · S/N 17255790N172MBStone Wall Acres · Antigo, WIS/N 36824N172MPPasswater Michael E · Upland, CABuilt 1961 · S/N 17248976N172NXHolcomb Garry M · Point, TXBuilt 1960 · S/N 17248148N172PHRegistration Pending · Milton, DERegistration pendingBuilt 1963 · S/N 17250918N172PJSlykhouse Gary B · Grand Rapids, MIBuilt 1966 · S/N 17255099N172PLSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1964 · S/N 0055N172PM98x LLC · Caddo Mills, TXS/N 17256117N172PSSchwarzenberg Johannes · MoosburgBuilt 1967 · S/N 172-55822N172RMorales Jeremy · Brewster, NYBuilt 1961 · S/N 47349N172RSSchwartz Nathan S · Indianapolis, INBuilt 1961 · S/N 17248893N172TNRegistration Pending · San Antonio, TXRegistration pendingBuilt 1966 · S/N 17255519N172TPContrail Aviation Inc · Cheboygan, MIBuilt 1956 · S/N 28401N172TTErvin Max W · Bend, ORBuilt 1961 · S/N 17248370N172TWGriffiths Larry F · Upland, CABuilt 1956 · S/N 29537N172VLEnce Daniel G · Saint George, UTBuilt 1964 · S/N 17251968N172VWVanwagnen Brian J · Jackson, MIBuilt 1961 · S/N 17249058N172WHSholund Stuart H · Elgin, ORBuilt 1961 · S/N 17249101N172WVMessner Mark R · Chesapeake, OHBuilt 1957 · S/N 36274N172XXRoberts Christopher B · Warner Robins, GAFirst renewal noticeS/N 47123N1730DKeith R Layne · Oklahoma City, OKS/N 20173N1730FSpragues Aerial Spraying Inc · Courtenay, NDBuilt 1966 · S/N 17255125N1730TEmshwiller Mark E · Camp Verde, AZBuilt 2013 · S/N 8695N1731FHostetler Robert J · Windyville, MOBuilt 1966 · S/N 17255126N1731VHargrove Dwayne E · Shepherdsville, KYBuilt 1947 · S/N 13916N1732FWicks Colton D · Cooper, TXBuilt 1966 · S/N 17255127N17330California Antique Aircraft Museum · San Martin, CABuilt 1945 · S/N 1N1733DCessna 170 LLC · Idaho Falls, IDBuilt 1951 · S/N 20176N1733FRegistered aircraftBuilt 1966 · S/N 17255128N1733KSogge Bjorn R · Spicer, MNBuilt 1946 · S/N 4460N17342Weber Worldwide LLC · Cedar Rapids, IABuilt 1973 · S/N 1045N1734FWlb Farms LLC · Iota, LABuilt 1966 · S/N 17255129N1735DOxford Glenn H · Fredericksburg, VAS/N 20178N1735QMadden David · Bethlehem, NHBuilt 1971 · S/N 15073035N1736DHoffman Drew A · Churubusco, INBuilt 1951 · S/N 20179N17371Lynch Kyle R · Palmetto, FLBuilt 1972 · S/N 15073714N17375Jts Aircraft LLC · Rock Hill, SCBuilt 1972 · S/N 15073718N1737FVoltl Mike N · Coloma, WIS/N 17255132N1737QWilliams Kamille N · Juneau, AKS/N 15073037N17382Hagelstein Ele C · Sanderson, TXRegistration expired, pending cancellationBuilt 1972 · S/N 15073715N1738FWesley Emerson Holdings LLC · Clifton, TXBuilt 1966 · S/N 17255133N1739EWilson Bobby R · Kathleen, GABuilt 1946 · S/N 7AC-5306N1739FSessions Jan · Kirbyville, TXBuilt 1966 · S/N 17255134N1739KBas Part Sales LLC · Greeley, COBuilt 1946 · S/N 4466N173RJJohnston Ronald E · Seattle, WAS/N 26269N173VFCorlee Douglas K · Palm Coast, FLBuilt 1964 · S/N 17252157N1740FBecton Richard A · San Antonio, TXBuilt 1966 · S/N 17255135N1741KSimply Living LLC · Fort Myers, FLS/N 4468
Back to AD 94-05-05 R1