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.

N3876SMustoe William J Jr · Summersville, WVBuilt 1963 · S/N 17251076N3877JWilson Steven J · Elkton, KYBuilt 1966 · S/N 15065177N38787Onawa Flying Service · Sioux City, IABuilt 1941 · S/N 7264N3878HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4579N3878KQualitair LLC Trustee · MichelstadtBuilt 1948 · S/N 3578N3878LLatshaw Sonja · Vero Beach, FLBuilt 1965 · S/N 17254047N3878RSs Farms Operating LLC · Hydro, OKBuilt 1966 · S/N 17255378N3878SSkyhawk172 LLC · Gainesville, TXBuilt 1963 · S/N 17251078N38794Shealy Charles T · St Helena Is, SCS/N 7271N3879JMuehl John M · Maryland, NYBuilt 1966 · S/N 15065179N3879LThielemann Kate Ann · Inverness, FLBuilt 1966 · S/N 17254048N387RMHeil Joe · Edgar, WIBuilt 2016 · S/N C75-10043N3880KRhodes Tracy · Reno, NVBuilt 1948 · S/N 3580N3880RC172 Nancy LLC · Euclid, OHS/N 17255380N3881LDarnell David M · Bon Aqua, TNS/N 17254050N3881SWynja Loreen Dee · Riverside, CABuilt 1963 · S/N 17251081N3882JPeek James · South Fork, COBuilt 1966 · S/N 15065182N3882SNichols Troy · Clinton, ARBuilt 1963 · S/N 17251082N38837Taylor Lucas S · Watford City, NDBuilt 1941 · S/N 7324N3883LBragg Gary W · Rainelle, WVBuilt 1966 · S/N 17254052N3883RGingras Carl A · Avondale, COBuilt 1966 · S/N 17255383N3883SBruns Scott A · Brodhead, WIBuilt 1964 · S/N 17251083N38846Danforth Byron F · Fryeburg, MES/N 7335N3884LCosta Jason L · Spring Hill, FLBuilt 1966 · S/N 17254053N3884SHawley Michael C · Hampton, NHBuilt 1963 · S/N 17251084N3884YJohnson James R · Cedarville, OHS/N 188N3885KFlies Warren E · Mesa, AZBuilt 1948 · S/N 3585N3885SLewis Kyle P · Shelbyville, KYBuilt 1964 · S/N 17251085N3886LRench Eugene G · Owosso, MIS/N 17254055N3887KWaters Joseph P · Morganton, NCBuilt 1948 · S/N 3587N3887LHigley Ryan · Arlee, MTBuilt 1965 · S/N 17254056N38880Shrader Sarah L · Rhinelander, WIBuilt 1941 · S/N 4-1595N38881Bishops Ltd · Virginia Beach, VABuilt 1941 · S/N 7369N3888HLewis James T Jr · Williamsport, MDS/N 4589N3888JAzalea Aviation LLC · Quitman, GABuilt 1966 · S/N 15065188N3888RGriswold Zachary S · Waunakee, WIBuilt 1966 · S/N 17255388N3889JVeduccio Gary Robert · Griffin, GABuilt 1966 · S/N 15065189N3889KBohl Howard M · Temecula, CABuilt 1948 · S/N 3589N3889LBaker Duane · Shepherd, TXS/N 17254058N3889RAdams Donald C · Garner, NCBuilt 1966 · S/N 17255389N388DTSchool Street Design Co LLC · Aptos, CABuilt 2002 · S/N 1388N388SESunset Eagle Aviation LLC · Southport, FLBuilt 1968 · S/N 15068466N3890LTexas Yellow Rose Planes LLC · Fort Worth, TXBuilt 1965 · S/N 17254059N3890RWright Chad · Fredericktown, OHBuilt 1966 · S/N 17255390N3891RN3891r LLC · Ogden, IAS/N 17255391N3892EFerriter John M · Waterville, NYS/N 7AC-7110N3892HDezso Joseph A · Arroyo Grande, CABuilt 1947 · S/N 4593N3892LHuettl Austin · Liberty Hill, TXBuilt 1965 · S/N 17254061N3892SState Technical College Of Missouri · Linn, MOS/N 17251092N38946Vierra Daryl M · Tempe, AZBuilt 1942 · S/N 8277
Back to AD 94-05-05 R1