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.

N99432Sullivan Patrick Joseph · East Hampton, NYS/N 2055N99433Louden Andrew R · Corvallis, ORS/N 2056N99448Howe Larry G · Florence, ORBuilt 1946 · S/N 2071N99458Muldoon Kevin M · Berlin, MDBuilt 1946 · S/N 2081N99463Myers Kenneth O · Niskayuna, NYBuilt 1946 · S/N 2086N99466Kenny Edward P · Montauk, NYS/N 2089N99485Hilton Loye L · Bullhead City, AZBuilt 1946 · S/N 2108N99488Murphy Peter S · Indianapolis, INS/N 2111N99493Beem Ray M · Apison, TNS/N 2116N99495Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 2118N99506High Plains Flying LLC · Burlington, COS/N 2129N99514Workman James E · Zanesville, OHBuilt 1946 · S/N 2137N99518Coats Christopher R · Vinita, OKBuilt 1946 · S/N 2141N99520Graham William T · Gilroy, CABuilt 1946 · S/N 2143N99529Allen John R III · Denton, MDBuilt 1946 · S/N 2152N99530Hibler Kenith R · Newcastle, OKBuilt 1946 · S/N 2153N99539Peppas George D Jr · Fort Wayne, INS/N 2162N99543Horne Lynn E · Adel, GABuilt 1946 · S/N 2166N99558Jacobelli Michael C · Wayne, PAS/N 2181N99561Harvell Randall W · Manteno, ILBuilt 1946 · S/N 2184N99564Spiegel Darren J · Chicago, ILBuilt 1946 · S/N 2187N99568Lloyd Ernest W III · Morrison, COBuilt 1946 · S/N 2191N99573Take Off LLC · Boise, IDBuilt 1946 · S/N 2196N99591Olson Bruce I · Osceola, WIBuilt 1946 · S/N 2214N99592Gregory Vernon L · Swansea, SCS/N 2215N99596Miller Steve L · Naperville, ILBuilt 1946 · S/N 2219N99597Vardara Philip G · Penn Valley, CABuilt 1946 · S/N 2220N995PGPratt Mark J · Sikeston, MOBuilt 1946 · S/N 1091N99600Jacobs Paul M Trustee · Hernando, MSS/N 2223N99601Burch Genevieve · Phoenix, AZBuilt 1946 · S/N 2224N99618Lull William G · Ramona, CABuilt 1946 · S/N 2241N99633Huschle Micheal D · Hitterdal, MNBuilt 1946 · S/N 2256N99641Oltz Walter H · Sauk Rapids, MNBuilt 1946 · S/N 2264N99642Roberts Raymond J · Rockledge, FLS/N 2265N99643Bernstein Matthew D · Charleston, SCS/N 2266N99646Shuler Donald · Punta Gorda, FLBuilt 1946 · S/N 2269N99648Morris Steven R · East Waterboro, MEBuilt 1946 · S/N 2271N99649Taylor Edward J · Cedar Hill, TXBuilt 1946 · S/N 2272N99657Newbury Dennis M II · Brea, CABuilt 1946 · S/N 2280N99664Planes Of Fame Air Museum · Chino, CAS/N 2287N99666Lemenager Mark A · Ashkum, ILBuilt 1946 · S/N 2289N99671Howell Kenneth A · Long Beach, CABuilt 1946 · S/N 2294N99672Cuthbert Alan R · Edwardsburg, MIBuilt 1946 · S/N 2295N99673Schupp Edward W · Hedgesville, WVBuilt 1946 · S/N 2296N99674Haley Billie Jo · San Martin, CABuilt 1946 · S/N 2297N99680Eaa Chapter 1590 Inc · Morrilton, ARBuilt 1946 · S/N 2303N99684Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 2307N99685Greany Ralph · Ramona, CABuilt 1946 · S/N 2308N99686Cullen Thomas E · Wakeman, OHBuilt 1946 · S/N 2309N99701Davenport Jimmy J · Hayesville, NCBuilt 1946 · S/N 2324
Back to AD 94-18-04 R1