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.

N3452HDuddy Donald Patrick · White City, ORBuilt 1947 · S/N 4077N3454HBost Kenneth A · Rockwell, NCBuilt 1948 · S/N 4079N3461HJones Jeffrey W · San Antonio, TXBuilt 1946 · S/N 4086N3471HPritchett Otis R · Avery, TXBuilt 1946 · S/N 4096N3475HBrownback Terry R · Emporia, KSS/N 4100N3477HSprott Robert L · Perkins, OKBuilt 1946 · S/N 4102N3480HRusch Edward J · Oak Harbor, OHBuilt 1948 · S/N 4105N3488HHeath Jackie · Radcliff, KYS/N 4113N3496HBlackwell Steve · Lewisburg, TNS/N 4121N3502HCavallaro Jack C · Jordan, NYBuilt 1947 · S/N 4127N3520HBushnell Cody A · San Antonio, TXS/N 4145N3524HRabaut Chuck P · Oceanside, CABuilt 1946 · S/N 4149N3530HUltraflight LLC · Angola, INBuilt 1946 · S/N 4155N3538HJugeau Jean-Louis · Thomasville, PABuilt 1946 · S/N 4163N3539HDresback Glen Lloyd · Cleveland, OKBuilt 1946 · S/N 4164N3548HGresley Ross A · Catawba, NCBuilt 1946 · S/N 4173N3550HShinn Larry J · Victor, CABuilt 1946 · S/N 4175N3560HBlakley Jordan A · Lake Point, UTBuilt 1946 · S/N 4185N3563HBoelman Scott · Whittier, CABuilt 1947 · S/N 4188N3564HPittinger Sandra Lee · Beggs, OKS/N 4189N3569HHess James L · Honey Brook, PAS/N 4194N3571HLang James L · Buckley, WAS/N 4196N3579HBucciarelli Dominick · Pueblo, COBuilt 1946 · S/N 4204N3587HIlatina LLC · Carson City, NVS/N 4212N3589HJones David F · Memphis, TNBuilt 1946 · S/N 4214N3593HYanks Air Museum · Baldwin Park, CABuilt 1946 · S/N 4218N3595HRowe William S · Argyle, TXBuilt 1946 · S/N 4220N3602HSale Reported · Jadwin, MOSale reportedS/N 4227N3615HKent Larry A · Gaylord, MIS/N 4240N3617HRegistration Pending · Beebe, ARRegistration pendingBuilt 1946 · S/N 4242N3618HEricson Eric · St Charles, ILBuilt 1946 · S/N 4243N3619HVanberg David O · Mineral Wells, TXBuilt 1946 · S/N 4244N3621HWallin Joshua M · Moreno Valley, CAS/N 4246N3626HPost Greg G · Mapleton, KSBuilt 1946 · S/N 4251N3627HPina Gabriel · Pasadena, CAS/N 4252N3633HMaximus Aviation LLC · Cheyenne, WYS/N 4258N3637HDe Young Robert · Napa, CABuilt 1946 · S/N 4262N3642HMccoy Bill · Deland, FLBuilt 1946 · S/N 4267N3644HJohnston David W Sr · Vero Beach, FLBuilt 1946 · S/N 4271N3649HVlahos James M · Brigham City, UTBuilt 1946 · S/N 4274N3668HSheridan Walter S · Indianapolis, INS/N 4293N3675HCarlson Kim R · Swartz Creek, MIBuilt 1946 · S/N 4300N3677HWalkup Richard A · Pioneer, OHBuilt 1946 · S/N 4302N3678HWilliams Terry R · Vinita, OKBuilt 1946 · S/N 4303N3679HJohnson Richard E · Mulberry, FLBuilt 1946 · S/N 4304N3688HTench William Carroll · Belton, SCBuilt 1946 · S/N 4313N3689HO Handley Hugh Jr · Rogersville, TNBuilt 1946 · S/N 4314N3694HAshburn Lauren W · Alta Vista, KSBuilt 1946 · S/N 4319N3695HGem Utilities Inc · Greenfield, INBuilt 1946 · S/N 4320N3697HFuller Randy M · Mooresville, NCBuilt 1946 · S/N 4322
Back to AD 94-18-04 R1