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.

N7486TRhodes Vergil H Jr · Bartlesville, OKBuilt 1959 · S/N 47086N7487ANelson Rodney G · Amenia, NDBuilt 1957 · S/N 29587N7487BMiller Timothy J · Hutchinson, MNS/N 7EC-488N7487MMaple Lake Flyers Corp · Maple Lake, MNBuilt 1959 · S/N 55787N74887Mroz Kaitlin J · Haslet, TXBuilt 1953 · S/N 25853N7488BMorrow Larry A · Dunnellon, FLBuilt 1957 · S/N 7EC-550N7488MFegert Jeff · Las Vegas, NVBuilt 1959 · S/N 55788N7489AAllianna LLC · Fayetteville, ARBuilt 1956 · S/N 29589N7489BLumley John W · Boynton Beach, FLBuilt 1957 · S/N 7EC-551N7489MMerinar John R Jr · Bridgeport, WVBuilt 1959 · S/N 55789N7490BPeacock David W · North Bennington, VTBuilt 1957 · S/N 7EC-552N7490XDawson Ejay J · Eveleth, MNBuilt 1960 · S/N 17247990N7491AMckee Paul R · Astoria, ORBuilt 1957 · S/N 29591N7492BBenson Airport Association Inc · Shoreview, MNBuilt 1957 · S/N 7EC-558N7492TSale Reported · Newport, ORSale reportedS/N 47092N7493BAlwine Joshua L · Chewelah, WAS/N 7EC-559N7493TLee Cody C · Denton, MTS/N 47093N7494BBowden Terry L · Moody, TXS/N 7EC-560N7494DBrown Stephen R · Chugiak, AKBuilt 1957 · S/N 18-5833N7495MPlumley David E · Waxhaw, NCBuilt 1959 · S/N 55795N7495XIsch Philip D · Geneva, INBuilt 1960 · S/N 17247995N7496AMcreynolds Sean D · Visalia, CABuilt 1956 · S/N 29596N7496BHoldgate Frederick I · Englewood, FLS/N 7FC-4N7496MMcmurray Patrick T · Brush Prairie, WABuilt 1959 · S/N 55796N7496XAbove All Aviation Inc · Santa Barbara, CABuilt 1960 · S/N 17247996N7497AJohnson Kurt W · Jordan, MNBuilt 1956 · S/N 29597N7497XTrinciante Fernando S · Thief River Falls, MNBuilt 1960 · S/N 17247997N7498ATorrey Robert S · Anchorage, AKBuilt 1957 · S/N 29598N7498TLala Princy · Deltona, FLBuilt 1959 · S/N 47098N7499ADurousseau Joseph Harry Trustee · Sparks, NVBuilt 1957 · S/N 29599N7499TWright Donald E · Greensboro, NCBuilt 1959 · S/N 47099N7499XVintage Aircraft Ltd · Hortonville, WIBuilt 1960 · S/N 17247999N74APPainton Albert M Jr · Bloomsdale, MOBuilt 1971 · S/N 74N74EEFarr Aviation LLC · Tullahoma, TNBuilt 1999 · S/N 4636215N74GTKnick Robert J · Eugene, ORBuilt 1969 · S/N 15070302N74JRSwindle Michael A · Clewiston, FLS/N 14435N74KWWilling Kenneth Allen · Grasston, MNS/N 15063752N74LHPetik Wil A · Brookings, SDBuilt 1974 · S/N 1413N74PHarris David M · Costa Mesa, CABuilt 1958 · S/N L-7N74RWWesterberg Roger K · Cottage Grove, MNBuilt 1988 · S/N 543N74UAnderson Ray L · Auburn, CAFirst renewal noticeBuilt 1977 · S/N 15079197N74VSchneider Dennis E Executor · Tribune, KSBuilt 1946 · S/N 1248N74WSGrimshaw Stuart A · Whispering Pines, NCBuilt 2007 · S/N CC11-00011N74YBJones Brandon Michael · Chelsea, ALBuilt 1997 · S/N 96-344RDN7500CBancroft Diane F · Hernando, FLBuilt 1957 · S/N 5612N7500MRoat Todd J · Rio, WIS/N 55800N7500TJacks Jerry W · Dalton, GABuilt 1960 · S/N 47100N7501Shuff Richard · Mead, COBuilt 2016 · S/N 8531N7501MAngus Glen R · Fernley, NVBuilt 1959 · S/N 55801N7502TDavis Chip · Apex, NCBuilt 1959 · S/N 47102
Back to AD 94-05-05 R1