OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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-20-04-R2')
    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-20-04-R2')
  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.

N8958ADrinkard Robert L · Moro, ORBuilt 1951 · S/N D-2712N8961AJenkins James L DBA · Lake Stevens, WABuilt 1957 · S/N D-2715N8963ANicola Gary L · Lansing, MIBuilt 1951 · S/N D-2717N8964ARice Johnny D · Rosharon, TXBuilt 1951 · S/N D-2718N8966CStiles David · Saint Petersburg, FLS/N D-3231N8970AKelley Con A · Green Cove Springs, FLS/N D-2724N897TRegistered aircraftBuilt 1972 · S/N D-9354N897TMLow Approach Only LLC · Wilmington, DEBuilt 1965 · S/N D-7962N8981MPeter N Steinmetz Trustee · Tempe, AZBuilt 1964 · S/N D-7339N8982MSharman Paul D · Carefree, AZBuilt 1964 · S/N D-7310N8983AStark Erik K · Frisco, TXBuilt 1951 · S/N D-2735N8986AHickman Herbert A · Fullerton, CABuilt 1951 · S/N D-2738N8986M170kts LLC · Novato, CABuilt 1964 · S/N D-7313N898QCrosby John J · Adel, GABuilt 1953 · S/N D-3511N8990MHayden Patrick Jr · Lexington, KYBuilt 1964 · S/N D-7312N8991AStikekeather Caro Anne · Arlington, VAS/N D-2743N8993MNorthwood Holdings LLC · Dugspur, VABuilt 1964 · S/N D-7316N8995MCollins Sherman C · Sedona, AZBuilt 1964 · S/N D-7317N8996ACzerski Norman B · Eagle River, AKBuilt 1951 · S/N D-2748N899TEtherington Charles A Trustee · Vlg Loch Loyd, MOBuilt 1971 · S/N D-9297N89JSPh Flight Services LLC · Wilmington, DEBuilt 1967 · S/N D-8537N8GMWalker Bobbie R · Denver, COBuilt 1954 · S/N D-3943N8KWSigurdson Richard J · Olivia, MNBuilt 1977 · S/N D-10091N8MPForeman Thomas H · Orange, TXBuilt 1966 · S/N D-8059N8MWHeckler Gary C · Carefree, AZBuilt 1976 · S/N D-9943N9000QFog City Flying LLC · Dublin, OHBuilt 1969 · S/N D-9000N9002SD'Alessio Enterprises Inc · Smithville, TNBuilt 1965 · S/N D-7936N9002VMason Thomas · Lubbock, TXBuilt 1968 · S/N D-8887N9003SWestchester Flying Club Inc · Purchase, NYBuilt 1965 · S/N D-7937N9003VMann Spencer I · Smithville, TXS/N D-8907N9004QLuketavious Aviation LLC · Madison, MSBuilt 1970 · S/N D-9179N9004SMorris Ag Air & Sons Inc · Orovada, NVBuilt 1965 · S/N D-7934N9006VBuckholts Texas LLC · Buckholts, TXBuilt 1969 · S/N D-9069N9007VHoster Keith DBA · Gordon, TXBuilt 1970 · S/N D-9088N9009QHanna Aviation Inc · Wheaton, ILBuilt 1970 · S/N D-9169N900PDV Claims LLC · Ainsworth, NEBuilt 1979 · S/N D-10195N9011DPorter Michael · Cleveland, TNBuilt 1964 · S/N D-7641N9012VEngelhardt John C · Porter, TXS/N D-9002N9014VKestrel Inc · West Des Moines, IABuilt 1971 · S/N D-9290N9017QLong Lynn I · Van Alstyne, TXBuilt 1970 · S/N D-9171N9018SOptimus Motors LLC · Amarillo, TXBuilt 1965 · S/N D-7948N9019SSky Master LLC · Blue Earth, MNS/N D-7949N901FJN901fj LLC · Miami, FLBuilt 1974 · S/N D-9657N901LCMaps-Rye LLC · Benton, ARBuilt 1958 · S/N D-5569N9022SWalker April M · Keller, TXBuilt 1965 · S/N D-7950N9023STwo Wings LLC · Pierre, SDBuilt 1965 · S/N D-7951N9029SKubier Martin · Yukon, OKBuilt 1965 · S/N D-7956N9033QDavid E Weissman · San Diego, CABuilt 1970 · S/N D-9208N9034SMcnurlin Thomas C · Tucson, AZBuilt 1965 · S/N D-7960N9041CAlexander Stephen L · Sugar Land, TXBuilt 1977 · S/N D-10096
Back to AD 94-20-04 R2