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.

N99703Treece Charles M · Morristown, TNFirst renewal noticeBuilt 1946 · S/N 2326N99707Henk Edward W · Pine River, MNBuilt 1947 · S/N 2330N99711Posada Hernan · Valencia, CABuilt 1946 · S/N 2334N99714Scroggins James R · Hollywood, FLBuilt 1946 · S/N 2337N99716Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 2339N99720Morrison Donald H · Saint Cloud, FLS/N 2343N99727Scott Bixler Edwin · Rising Fawn, GABuilt 1946 · S/N 2350N99729Arndt Eric A · Jacksonville, FLBuilt 1946 · S/N 2352N99732Scholz Jeffrey K · Perris, CABuilt 1946 · S/N 2355N99739Herzog Eric M · New Waverly, TXS/N 2362N99753Holliday Robert W · Tucson, AZBuilt 1946 · S/N 2376N99757Walter Daniel E · Palmyra, PABuilt 1946 · S/N 2380N99764D&Km Enterprises LLC · Mobile, ALS/N 2387N99768Loveless Aaron Lee · Castroville, CABuilt 1946 · S/N 2391N99778Downs Milo W · Lake Benton, MNBuilt 1946 · S/N 2401N99780Toledo City School District · Swanton, OHBuilt 1946 · S/N 2403N99790Rush Francis N · Rayne, LABuilt 1946 · S/N 2413N99796Smith David L · Bellevue, NES/N 2419N99807Hamilton Raymond W Trustee · Chillicothe, MOBuilt 1946 · S/N 2430N99808Godbold Joshua M · Perdido Beach, ALS/N 2431N99812Butts Thomas E · Nicholls, GABuilt 1946 · S/N 2435N99816Sale Reported · Oklahoma City, OKSale reportedBuilt 1946 · S/N 2439N99820Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 2443N99825Graham James L · Columbus, OHBuilt 1946 · S/N 2448N99828Hale Larry E · Granbury, TXBuilt 1946 · S/N 2451N99840Zmrzel David J · Port Saint Lucie, FLBuilt 1946 · S/N 2463N99843Smith Maynard · Colfax, CABuilt 1946 · S/N 2466N99851Kimmel Jonathan R · Lebanon, PABuilt 1946 · S/N 2474N99879N46p Inc · Fort Wayne, INBuilt 1946 · S/N 2502N99894Hard Alan N · North Aurora, ILFirst renewal noticeBuilt 1946 · S/N 2517N99899Dicksion William D · Bremerton, WABuilt 1946 · S/N 2522N99902Hainen Michael J · Traverse City, MIBuilt 1946 · S/N 2525N99904Dickson James · Salida, COBuilt 1946 · S/N 2527N99906Snyder James J · Morgantown, WVBuilt 1946 · S/N 2529N99907Rentoumis Michael G · Altoona, FLBuilt 1946 · S/N 2530N99908Ryan Thomas S · Greenfield, WIBuilt 1946 · S/N 2531N99916Nuremberg Auto Service Inc · Nuremberg, PABuilt 1946 · S/N 2539N99919Poliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 2542N99920Anderson King David · Lenexa, KSBuilt 1946 · S/N 2543N99924Harvell Randall W · Manteno, ILBuilt 1946 · S/N 2547N99928Kinker Christopher C · Charlestown, INS/N 2551N99929Radle Steven H · Baker City, ORBuilt 1946 · S/N 2552N99932Taylor Alexander M · Inwood, WVBuilt 1946 · S/N 2555N99934Specht Leo M · Towner, COS/N 2557N99935Otto Dennis M · South Haven, MIBuilt 1946 · S/N 2558N99936Abell Eric E · Centerville, OHBuilt 1946 · S/N 2559N99939Poliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 2562N99955Cox Kermit R · Sterling, ILBuilt 1946 · S/N 2578N99956Chase 13 LLC · Wilmington, DES/N 2579N99958Moltz Larry D · Seguin, TXBuilt 1947 · S/N 2581
Back to AD 94-18-04 R1