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.

N56866Skelton David W · Baker, FLBuilt 1973 · S/N 32-7440033N56934Low Allen R · San Francisco, CABuilt 1973 · S/N 32-7400011N574PRSoto Angel L · Las Piedras, PRBuilt 1965 · S/N 32-241N574TMJohnson Tristan O · Pensacola, FLBuilt 1974 · S/N 32-7540019N589VWPierce Thurlow L · Attica, MIBuilt 1967 · S/N 32-908N596TCWinyah Aviation LLC · Wilmington, DEBuilt 1979 · S/N 32-7940165N5986VLampin Aviation LLC · Brielle, NJBuilt 1977 · S/N 32-7700018N59SWLg Services LLC · Chino, CABuilt 1966 · S/N 32-753N5MHGould Ralph Harvey Jr · White Cloud, MIBuilt 1967 · S/N 32-40268N5YPMo'S Ventures LLC · Lakeside, CABuilt 1974 · S/N 327440067N600JGWiltcher Christopher Alex · Gallatin, TNBuilt 1969 · S/N 32-40726N600JLMinisterio Internacional Gracia Y Poder Inc · Houston, TXBuilt 1973 · S/N 32-7400010N6051HFlying Six Inc · Mc Cool Junction, NEBuilt 1977 · S/N 32-7840033N6073HHall Aviation Inc · Phenix City, ALS/N 32-7840034N60LYLeon Roberts Enterprises LLC · Vienna, VABuilt 1965 · S/N 32-10N60PLPapa Lima LLC · York, NEBuilt 1967 · S/N 32-870N60TTOurhappyfamilyplane LLC · Mason, OHBuilt 1979 · S/N 32-7940151N610MAThomas Michael J · Malabar, FLBuilt 1966 · S/N 32-40105N612JSWings Of Eagle LLC · Leo, INBuilt 1970 · S/N 32-40935N616JPWb Painting Contractors LLC · Greenville, MSBuilt 1967 · S/N 32-40420N617ETBunck Richard DBA · Apple Valley, CABuilt 1967 · S/N 32-40205N6198JBess Michael S · Niceville, FLBuilt 1976 · S/N 32-7640098N61DEBergabo Bjorn E · Norwalk, CTBuilt 1979 · S/N 32-7940030N620BCBlair Bob Jr · Essex, MOBuilt 1974 · S/N 32-7400037N621TGSchmotzer Donald S · Ladson, SCS/N 32-7940056N6228JRegistration Pending · Fort Myers, FLRegistration pendingBuilt 1976 · S/N 32-7600018N625PBForward Aviation LLC · Statesville, NCBuilt 1965 · S/N 32-271N626RNFerguson & Son Inc · Lebanon, TNBuilt 1967 · S/N 32-40246N629FCDoherty Paul A · Van Buren, ARBuilt 1979 · S/N 32-7940182N62DJZig Zag Inc · Wilmington, DES/N 32-7640062N6300MShortfin Holdings LLC · Seneca, SCBuilt 1974 · S/N 32-7440141N6300YSullivan Mark F · Cocoa Beach, FLFirst renewal noticeBuilt 1974 · S/N 32-7540044N63146C M B Aviation LLC · Farmington Hills, MIBuilt 1974 · S/N 32-7440117N631BWHaase Eric J · Woodland Hills, CABuilt 1973 · S/N 32-7340041N6326CBridges Gerald Lloyd · Chelsea, MIBuilt 1978 · S/N 32-7840079N632WBKesner Ronald H Jr · Troy, VABuilt 1966 · S/N 32-620N633SGCherokee N633sg LLC · Leonardtown, MDBuilt 1972 · S/N 32-7340051N636EBPoint To Point Air LLC · Arlington, WAS/N 32-7940115N6409CCrider Richard S · Prescott, AZS/N 32-7840083N645BCNolan Kevin J · North Bend, ORBuilt 1974 · S/N 32-7540056N645CHWebster Jason M · Orlando, FLBuilt 1972 · S/N 327240135N646SDBiton Liad · San Diego, CABuilt 1965 · S/N 32-294N647BMaxiao Aviation Corp · Milpitas, CABuilt 1979 · S/N 32-7940040N649BCFlyport LLC · Crossville, TNS/N 32-7840147N64CTFly2dig LLC · Laclede, IDS/N 3240528N64EHRed Stick Brothers LLC · Baton Rouge, LABuilt 1966 · S/N 32-769N64EWLapp Philip D · Weatherford, TXBuilt 1973 · S/N 32-7340089N64USJc Investors Group LLC · Coral Springs, FLBuilt 1974 · S/N 32-7440122N64WCTrahan Stewart K · Little Rock, ARBuilt 1977 · S/N 32-7740095N65194Vliegen LLC · Urbandale, IABuilt 1965 · S/N 32-38
Back to AD 74-18-13