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.

N4238RMarianas Air Transfer Inc · Saipan, MPBuilt 1969 · S/N 32-40603N4239RWilson John T · Castalian Springs, TNBuilt 1969 · S/N 32-40604N423JWSkeens Gregory Jr · Encinitas, CAS/N 32-7840163N4241RFsi Aviation LLC · San Antonio, TXBuilt 1969 · S/N 32-40606N4250RNewsome George W III · Palmyra, NYBuilt 1969 · S/N 32-40617N4254RStar Marianas Air Inc · Saipan, MPBuilt 1969 · S/N 32-40625N4259RThorn Robert L · Clovis, NMBuilt 1969 · S/N 32-40631N425CHKeeton Farms LLC · Monticello, KYBuilt 1966 · S/N 32-770N4260RColin Irons Diving And Pool Service · Crawfordville, FLBuilt 1969 · S/N 32-40634N4262RKirkpatrick Alan E · Oklahoma City, OKS/N 32-40636N4266RBig Guy Enterprise Transportation LLC · Portland, ORBuilt 1969 · S/N 32-40639N4270RKreiser Foster E Jr · Middletown, PABuilt 1969 · S/N 32-40645N4270TAllen Aero LLC · Saint Cloud, FLBuilt 1971 · S/N 32-7240048N4272RModic David J · Escondido, CABuilt 1969 · S/N 32-40647N4277RFoxtrot Golf LLC · Kalispell, MTBuilt 1969 · S/N 32-40648N4279RCummins Dan D · Blencoe, IABuilt 1969 · S/N 32-40651N4280RRupp Amanda E · Osteen, FLBuilt 1969 · S/N 32-40653N4289RShaughnessy Paul V Jr · Norwood, MABuilt 1969 · S/N 32-40665N4290RLadet David E · Lavonia, GABuilt 1969 · S/N 32-40666N4292RSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 32-40669N4293RLaws Chris · Mckenzie, TNS/N 32-40671N4296RJohnstone Colin · Enterprise, ALS/N 32-40674N4297R4297 Romeo Aviation LLC · Owasso, OKBuilt 1969 · S/N 32-40675N4298RAv79 Aviation LLC · Dover, OHBuilt 1969 · S/N 32-40677N4299RRimlinger Timothy Trustee · Audubon, PABuilt 1969 · S/N 32-40678N429SFLewis Jason M · Camden, ARBuilt 1979 · S/N 32-7940136N42CJNewman Robert A · Discovery Bay, CABuilt 1979 · S/N 32-7940149N42CXSilver Hawks Ltd · Columbus, OHBuilt 1973 · S/N 32-7340142N43070Wkb Aviation LLC · Walnut Creek, CABuilt 1974 · S/N 32-7440115N4307TMartin Russell L · Atascadero, CAS/N 32-7240061N43108Hunter Aviation Inc · Albany, GABuilt 1974 · S/N 32-7440116N4315TCommunity Health Alliance · Fairfield, OHBuilt 1971 · S/N 32-7200016N43170Craig John IV · Lilburn, GABuilt 1974 · S/N 32-7400041N43276Wilson Steven D Trustee · Mount Pleasant, IABuilt 1974 · S/N 32-7440120N4332TOld Fart Aviation LLC · Carroll, OHBuilt 1972 · S/N 32-7240065N4334TMacphail Douglas J · East Longmeadow, MABuilt 1971 · S/N 32-7240054N4339TJpm Investment Group LLC · Pascoag, RIBuilt 1971 · S/N 32-7200018N433STCirrus Chaser LLC · Thomasville, GABuilt 1971 · S/N 32-7100014N43451Redwood Air LLC · Roanoke, TXBuilt 1974 · S/N 32-7440127N43527Ball Fred E · College Place, WABuilt 1974 · S/N 32-7440131N43618Ferrandi Pierre · Phoenix, AZBuilt 1974 · S/N 32-7440137N4362TYost Jim · Flora, INBuilt 1971 · S/N 32-7240058N4365TStruckmeyer Ingo H · Normandy, TNBuilt 1972 · S/N 32-7200019N43664Johnston William R · Jackson, NCBuilt 1974 · S/N 32-7400046N4370FRmr Inc · Exeter, CABuilt 1976 · S/N 32-7640114N4371TBlevins John · Huntsville, ALBuilt 1972 · S/N 32-7240073N4371XBaptist Mid Missions · Cleveland, OHBuilt 1975 · S/N 32-7640016N43796Tpa LLC · Augusta, GABuilt 1977 · S/N 32-7700022N4384XPennell Bobby · Hobbs, NMBuilt 1975 · S/N 32-7540123N4394TLinden'S Aviation LLC · Lagrange, OHBuilt 1972 · S/N 32-7200020
Back to AD 74-18-13