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.

N3987WPhipps Robert Sean · Euless, TXS/N 32-959N3988WGrant Robert M Trustee · Farmington Hills, MIBuilt 1967 · S/N 32-960N3989WHigher Plane Inc · Wilton Manors, FLBuilt 1967 · S/N 32-893N3989XEdgar Mary E · Butler, TNBuilt 1975 · S/N 32-7640007N3991WAllways LLC · Missoula, MTBuilt 1967 · S/N 32-911N39941Devoll Jeffrey · Sacramento, CABuilt 1978 · S/N 32-7840179N3994WKramer Jeffrey P · Burlington, WIBuilt 1967 · S/N 32-962N3997FMatthews David L · Floyds Knobs, INBuilt 1976 · S/N 32-7600021N3997WJaroch Eric J · Houghton Lake, MIBuilt 1967 · S/N 32-965N3999XK-Viation LLC · Paulding, OHBuilt 1975 · S/N 32-7640008N399LMPepper LLC · Winter Garden, FLBuilt 1975 · S/N 32-7540023N399RCSouthwestern Development & Leasing Inc · Costa Mesa, CABuilt 1965 · S/N 32-212N3BSEcho 7 Tango Aviation LLC · Pottsboro, TXBuilt 1973 · S/N 32-7340179N3FNFreedom Wings LLC · Spout Spring, VABuilt 1974 · S/N 32-7500007N4001RPrusso Douglas M · Woodstock, GABuilt 1967 · S/N 32-40286N4002WBall David J · Shreveport, LABuilt 1966 · S/N 32-40019N4003RRowley Stephen A · Burlington, WIBuilt 1967 · S/N 32-40289N4004RHoche-Mong Michel · Campbell, CABuilt 1967 · S/N 32-40291N4004WWatson Worldwide LLC · Buzzards Bay, MAS/N 32-40003N4009RFagerberg Albert · Hot Springs Villag, ARBuilt 1967 · S/N 32-40301N4010WOne Zero Whiskey LLC · Savannah, GAS/N 32-40012N4011RHot Shots Aerial Photography LLC · Mesa, AZBuilt 1967 · S/N 32-40304N4011WAdami Devin · Truckee, CABuilt 1966 · S/N 32-40014N4015RJ And J Av8 LLC · Eatonton, GAS/N 32-40310N4016RNorsworthy Aviation LLC · Redington Shores, FLBuilt 1967 · S/N 32-40312N4018RRyan Jeromie · Allen, TXBuilt 1967 · S/N 32-40315N4019RFdmas LLC · Bellevue, WABuilt 1967 · S/N 32-40316N4019WSmith Timothy A · Granbury, TXBuilt 1966 · S/N 32-40027N4020RDemers James D · Firestone, COBuilt 1967 · S/N 3240297N4020WRoss Hx LLC · Lebanon, OHBuilt 1966 · S/N 32-40029N4021R21 Romeo Inc · Horton, MIBuilt 1967 · S/N 32-40248N4021WClark Darrell E Jr · Edna, TXBuilt 1966 · S/N 32-40031N4022RZ Aviation LLC · North Ridgeville, OHBuilt 1967 · S/N 32-40299N4024RCheuvront Jevon K · Seminole, TXBuilt 1967 · S/N 32-40319N4025WMcgee Mark K · Port Alsworth, AKS/N 32-40039N4028WCmor Properties LLC · Saint Augustine, FLBuilt 1966 · S/N 32-40045N4029WBadger 29w LLC · Waukesha, WIBuilt 1966 · S/N 32-40047N4030RDsp Investments LLC · Long Beach, CABuilt 1967 · S/N 32-40325N4032WRegistered aircraftBuilt 1966 · S/N 32-40053N4033RSwanson Terence S · Montrose, COBuilt 1967 · S/N 32-40329N4033WHolladay Grant L · Lamesa, TXBuilt 1966 · S/N 32-40055N4034RBryant Jonathan E · Joaquin, TXS/N 32-40330N4042RSutton Aircraft Salvage LLC · Palmer, AKBuilt 1967 · S/N 32-40339N4044RFour M Aviation LLC · St Petersburg, FLBuilt 1967 · S/N 32-40342N4048RHarris Heights LLC · Tyler, TXBuilt 1967 · S/N 32-40348N4051WHenningsen Gregory Mark · Arvada, COBuilt 1966 · S/N 32-40071N4053RDorsett Brandon · Buckeye, AZBuilt 1967 · S/N 32-40355N4055RBroadhurst Eric Clark · Brookline, NHBuilt 1967 · S/N 32-40358N4055WDiehl Frances M · Alamogordo, NMBuilt 1966 · S/N 32-40079N4056WHighwing Flyers Inc · Cape May Ch, NJBuilt 1966 · S/N 32-40081
Back to AD 74-18-13