OpenAirDocs.org
AD 94-18-04 R1

Registered aircraft · 1,310

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-18-04-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-18-04-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.

N9772MHeusinkveld Kevin D · Christiana, TNBuilt 1970 · S/N 700043N9773MGregory Vernon L · Swansea, SCS/N 700044N9775MMetelmann Thomas K · Grand Forks, NDBuilt 1970 · S/N 700046N9795MGaasch James F · Alpena, MIS/N 700050N980DDHeath Jackie · Radcliff, KYBuilt 1946 · S/N 4010N99013Poehler Carol S · Prairie Village, KSBuilt 1946 · S/N 1636N99030Brown John R · Nashville, TNS/N 1653N99036Wilwerding Terry · Omaha, NEFirst renewal noticeBuilt 1946 · S/N 1659N99037Still Robert L · Thomasville, NCS/N 1660N99039Alesso Casey H · Rosamond, CABuilt 1946 · S/N 1662N99043Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1666N99047Marriott Robert E · Newark, OHBuilt 1946 · S/N 1670N99049Brown Jeffrey S · Jerome, IDBuilt 1946 · S/N 1672N99050Berry Norman R · Knoxville, TNBuilt 1946 · S/N 1673N99052Wallace Paul E · Cedar Falls, IABuilt 1946 · S/N 1675N99055Ag-Aero Services LLC · Spring Hill, FLBuilt 1946 · S/N 1678N99056Morgan Rodney D · Boiling Springs, PAS/N 1679N99075Estuarial Medical Consultants · South Boston, VABuilt 1946 · S/N 1698N99083Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1706N99088Stanton Paul L · Bloomington, MNBuilt 1946 · S/N 1711N99089Moore Michael W · Tacoma, WABuilt 1946 · S/N 1712N99092Mapes Joseph S · Stevens Point, WIBuilt 1946 · S/N 1715N99101Croft Thomas J · Camdenton, MOBuilt 1946 · S/N 1724N99103Pearson Landon S · Madison, SDBuilt 1946 · S/N 1726N99109Holmes Ronald · Modesto, CABuilt 1946 · S/N 1732N99112Macario T Michael · Townsend, DEBuilt 1946 · S/N 1735N99115Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1738N99116Hallman Eugene A · Kasota, MNBuilt 1946 · S/N 1739N99121Sprott Robert L · Perkins, OKBuilt 1946 · S/N 1744N99124Stephany Peter T · Umatilla, FLS/N 1747N99129Wischmeyer Matthew R · Hopewell Junction, NYS/N 1752N99133Schmotzer Donald C · West Columbia, SCBuilt 1946 · S/N 1756N99134Balla Steve · Fallbrook, CAS/N 1757N99139Fahey Michael J · Fenton, MIBuilt 1946 · S/N 1762N99143Shannon Air Museum LLC · Fredericksburg, VABuilt 1946 · S/N 1766N99158Alexander Grayson T · Winthrop, WABuilt 1946 · S/N 1781N99159Chesak Jonathan J · Merlin, ORFirst renewal noticeBuilt 1946 · S/N 1782N99164Paul James W · Los Angeles, CAFirst renewal noticeBuilt 1946 · S/N 1787N99170Berry Darrell F · Norman, OKBuilt 1946 · S/N 1793N99174Vohlken Edward · Smithboro, ILBuilt 1946 · S/N 1797N99177York George T · Harvard, ILBuilt 1946 · S/N 1800N99180Rilling Norman I Jr · Bakersfield, CABuilt 1946 · S/N 1803N99181Wilhelm Kenneth H · Helena, MTBuilt 1946 · S/N 1804N99183Mahon David L · Payson, ILS/N 1806N99186Emerson Daniel B · Port Royal, PABuilt 1946 · S/N 1809N99187Bobbitt James Warren · Imboden, ARS/N 1810N99188Wallin Joshua M · Moreno Valley, CAS/N 1811N99189Young Jason C · Little River, KSBuilt 1946 · S/N 1812N99190Pitts Steven L · Anacortes, WABuilt 1946 · S/N 1813N99198Perry Gregory C · Maurice, LABuilt 1946 · S/N 1821
Back to AD 94-18-04 R1