AD 74-18-13

Registered aircraft · 1,642

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:74-18-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
  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.

N4105RWertz Travis F · Richland Center, WIBuilt 1968 · S/N 32-40424N4107RSatnews Publishers Inc · Carson City, NVBuilt 1967 · S/N 32-40426N4108WArrow Ventures Inc · Lake Preston, SDS/N 32-40171N4110WRaschio Ernesto G · Doral, FLBuilt 1967 · S/N 32-40173N4112RLangenegger Glenn · Burns, KSBuilt 1968 · S/N 32-40431N4112WLian Ian · Beaumont, TXBuilt 1967 · S/N 32-40175N4114WWilliams Frank J · Mendon, MABuilt 1967 · S/N 32-40177N4118RHampsch Jeremy · Hauser, IDBuilt 1968 · S/N 32-40437N4118WWisniewski Travis J · Porter, TXBuilt 1967 · S/N 32-40181N4119RMott Patrick T · Ballston Spa, NYBuilt 1967 · S/N 32-40188N41208Scott Kevin L · Kissimmee, FLBuilt 1974 · S/N 32-7440076N4120WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1967 · S/N 32-40184N41210Fisher Jordan L · Bennington, NEBuilt 1974 · S/N 32-7440061N4122WGo West Aviation LLC · Gillette, WYBuilt 1967 · S/N 32-40186N4123WSchaal Donald P · Wauconda, ILS/N 32-40187N4127RStar Marianas Air Inc · Saipan, MPBuilt 1968 · S/N 32-40445N4127WSkipgen Holdings LLC · Miami, FLBuilt 1967 · S/N 32-40192N4128RRose Brandon R · Lockhart, TXS/N 32-40446N4129WH & L Air LLC · Charlotte, MIS/N 32-40195N412PMWettstein Jay · Ontario, ORBuilt 1969 · S/N 321142N412RBReel Believers II LLC · Palm City, FLBuilt 1979 · S/N 32-7940046N412TGThompson Larry N · Artesia, NMBuilt 1970 · S/N 32-40916N4130RMaverick Hunter Airlines LLC · Stuart, FLBuilt 1968 · S/N 32-40448N4131WRudd Joshua A · Cresson, TXBuilt 1967 · S/N 32-40197N4132WTopken William F · Fallon, NVBuilt 1967 · S/N 32-40198N41335Doherty Gordon W Jr · Garden Plain, KSBuilt 1974 · S/N 32-7440083N4133RFlying Friends LLC · Lynchburg, VABuilt 1968 · S/N 32-40450N4133WHochstedler Wilford L · Parsons, KSBuilt 1967 · S/N 32-40199N4135RHinkle Robert J · Caldwell, IDBuilt 1968 · S/N 32-40452N41365Henke Cory William · Rosendale, WIBuilt 1974 · S/N 32-7440086N4136RRobinson Douglas A · Derry, NHBuilt 1968 · S/N 32-40492N4137RDavis Charles E · Mount Dora, FLBuilt 1968 · S/N 32-40455N4138RReece Doyle · Bentonville, ARBuilt 1968 · S/N 32-40493N41408Drixhurst Six LLC · Lindon, UTBuilt 1974 · S/N 32-7440088N4140RStewart Mike F · Chugiak, AKBuilt 1968 · S/N 32-40459N4141RHard Landing LLC · Fort Pierce, FLS/N 32-40460N4142WDale Mike S · Boise, IDBuilt 1967 · S/N 32-40210N4143RCon Air Aviation LLC · Borger, TXBuilt 1968 · S/N 32-40462N4144RRacer Investments LLC · Long Beach, CAS/N 32-40463N4147RRamos George L · Conroe, TXBuilt 1968 · S/N 32-40347N4147WRalls Michael Todd · Crawfordsville, IABuilt 1967 · S/N 32-40217N4150WMathews Brandon · Eunice, NMS/N 32-40221N4151RMartin Michael T · Las Vegas, NVBuilt 1968 · S/N 32-40465N41545Faulks Carson · Wellington, TXS/N 32-7440097N41579Walker John Brandon · Thaxton, MSBuilt 1974 · S/N 32-7400034N4159RArmstrong Scott T · Navasota, TXBuilt 1968 · S/N 32-40474N4159WNorthern Sky Aviation LLC · Howard Lake, MNBuilt 1967 · S/N 32-40231N415LLost Pines Tours LLC · Bastrop, TXBuilt 1977 · S/N 32-7740073N4162REckman Jason · Waterford, WIBuilt 1968 · S/N 32-40477N4162WBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 32-40235
Back to AD 74-18-13