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.

N87354Boehlke Kevin P · New Baltimore, NYBuilt 1946 · S/N 527N87361Winter Jack W · Custer, SDS/N 534N87362Dunbar Wilbur R · Brick, NJBuilt 1946 · S/N 535N87366Sanford Stephen R · Wichita, KSBuilt 1946 · S/N 539N87372Killhour Gilson · Fernandina Beach, FLBuilt 1946 · S/N 545N87373Kirkendall Richard S · Havre De Grace, MDBuilt 1946 · S/N 546N87374Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 547N87375Registration Pending · Arlington Heights, ILRegistration pendingBuilt 1946 · S/N 548N87379Scott Homer R Sr · Del City, OKBuilt 1946 · S/N 552N87385Hurst Edward E · Southlake, TXS/N 558N87391Specht Leo M · Towner, COS/N 564N87398John A Clairmont · Turner, MEBuilt 1946 · S/N 571N87399Lee Justin W · Maud, TXS/N 572N87410Harpole Bill · Dickinson, NDBuilt 1946 · S/N 583N87413Parker Thomas J · Hillsboro, WIBuilt 1946 · S/N 586N87414Sweitzer Michael C · Bruneau, IDBuilt 1946 · S/N 587N87416Amann David Paul · Wesley Chapel, FLBuilt 1946 · S/N 589N87424Porterfield Tom · Abernathy, TXBuilt 1946 · S/N 597N87431Hoffman Merle W · Juniata, NEBuilt 1946 · S/N 604N87433Four Five Air LLC · Traverse City, MIBuilt 1946 · S/N 606N87435Owen Nick F · Jacksboro, TXBuilt 1946 · S/N 608N87440Billings Christopher P · Seffner, FLBuilt 1946 · S/N 613N87448Myers Blane L · Browns Valley, CAS/N 621N87449Korzelius Matthew J · Niagara Falls, NYBuilt 1946 · S/N 622N87EVIllinois Ercoupe Flyers LLC · Belleville, ILBuilt 1946 · S/N 958N8CZRey Thomas A · Fort Worth, TXBuilt 1961 · S/N 5761N900FGCordle Christopher T · Howard, OHBuilt 1946 · S/N 2459N919RMHall Melvin E · Ocoee, FLS/N 698N919WQStone Jeffrey · Fort Collins, COBuilt 1966 · S/N A-107N9270YBrunettin Mark · Frierson, LAS/N 3442N93302Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 625N93318Broer Marc W · Des Moines, IABuilt 1946 · S/N 641N93320Devries Amy J · Sulphur Bluff, TXBuilt 1946 · S/N 643N93332Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 655N93334Dates Lauren C · Red Creek, NYBuilt 1946 · S/N 657N93337Oneel Cory · Ames, IABuilt 1946 · S/N 660N93346Deal Robert E · Hendersonville, TNBuilt 1946 · S/N 669N93358Rankins Todd E · Mohawk, NYBuilt 1946 · S/N 681N93383Wilson Theron C · Chugiak, AKBuilt 1946 · S/N 706N93389Lambert Brian L · Tahlequah, OKBuilt 1946 · S/N 712N93394Black Ronald D · Valley Center, KSBuilt 1946 · S/N 717N93395Hildebrandt Colin R · Neenah, WIBuilt 1946 · S/N 718N933PSCuellar Trajan A · Fargo, NDBuilt 1946 · S/N 3319N93405Newsom Robert V · Chandler, AZBuilt 1946 · S/N 728N93413Dodson Robert L · Ottawa, KSBuilt 1946 · S/N 736N93415Brannon Barry Gilmore · Bell, FLBuilt 1946 · S/N 738N93418Hougland David W · Rapid City, SDBuilt 1946 · S/N 741N93420Tres Amigos Flying Club LLC · Redding, CABuilt 1946 · S/N 743N93421Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 744N93427Doerfler Linda J · East Amherst, NYBuilt 1946 · S/N 750
Back to AD 94-18-04 R1