AD 81-18-04 R2

Registered aircraft · 81,733

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

N9613UGlenn Thomas Joel Hr · Fort White, FLS/N AA5-0813N9613WAir Wilma LLC · Tijeras, NMS/N 28-23067N9614CBravo Foxtrot Zulu Holdings LLC · Unionville, CTBuilt 1978 · S/N 32-7840106N9614EWeber William J · Durham, NCBuilt 1991 · S/N 1179N9614HC&H Elite Air LLC · Johnstown, COBuilt 1975 · S/N 17266265N9614JSkinner Roger · Delanson, NYBuilt 1966 · S/N 28-3767N9614MSmith Michael O · Conroe, TXBuilt 1966 · S/N 670191N9614QConrad Terry E · Lancaster, OHBuilt 1975 · S/N 17265699N9614SFlatonia Veterinary Clinic Inc · Flatonia, TXBuilt 1966 · S/N 46N9614WByrne Matthew A · West Allis, WIBuilt 1967 · S/N 28-23069N9615CD Wayne Hollar Jr Dds Pa · Lenoir, NCBuilt 1978 · S/N 32-7840107N9615DPeterson Thomas M · Park Rapids, MNBuilt 1959 · S/N 22-6525N9615LHansen Aviation LLC · Savannah, GABuilt 1973 · S/N AA1B-0115N9615MMorgan Mark · Durango, COBuilt 1966 · S/N 670192N9615RAlbright Frank · Elba, ALBuilt 1991 · S/N 1185N9615TEtzel Gregory J · Lafayette, INBuilt 1978 · S/N 38-78A0145N9615UKnutson Duane G · Brookings, SDBuilt 1975 · S/N AA5-0815N9615ZTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1963 · S/N 1018N9616ABoyd Ronald J · Genoa, COBuilt 1990 · S/N 1170N9616JGarsteck Paula · Put In Bay, OHBuilt 1966 · S/N 28-3769N9616LMid Island Air Service Inc · Ronkonkoma, NYBuilt 1986 · S/N 17276590N9616MBohn Aaron L · Valdosta, GAS/N 670193N9616QClearview Flying Club Inc · Westminster, MDBuilt 1975 · S/N 17265701N9616RPray Aviation Inc · Augusta, KSS/N TD-295N9616WKohut Jeanette G · Southern Pines, NCBuilt 1967 · S/N 28-23071N96177B2 Cpr Plus Inc · Bermuda Dunes, CABuilt 1970 · S/N 17701543N9617CPete And Pete Sales Inc · Williamsville, NYBuilt 1978 · S/N 32R-7885060N9617DWinton Christopher M · Valley Center, KSBuilt 1958 · S/N 22-6528N9617HShinn Lake D · Stevensville, MTBuilt 1976 · S/N 17266267N9617JBeaverdam Aeronautics LLC · Chatom, ALBuilt 1966 · S/N 28-3771N9617MSlusser Dennis G · Biggs, CAFirst renewal noticeBuilt 1966 · S/N 670194N9617QKagin Corp · Wilmington, DEBuilt 1975 · S/N 17265702N9617SAnderson David R · Hastings, MNBuilt 1966 · S/N 366N9617WPoskevich Douglas P · Deland, FLS/N 28-23072N96180Jb Aviation · Bolingbrook, ILBuilt 1983 · S/N 17276034N96186Registered aircraftBuilt 1991 · S/N 1186N9618DRich Beryl G · Brush Prairie, WABuilt 1958 · S/N 22-6529N9618FCoady Siegfried · Dallas, TXBuilt 1991 · S/N 1189N9618MPatton Jeremy M · Dolores, COBuilt 1966 · S/N 670195N9618SBradley Christopher · Juneau, AKBuilt 1965 · S/N 385N9618UN9618u LLC · Grand Haven, MIBuilt 1975 · S/N AA5-0818N96192Hannah Charles B · Skiatook, OKBuilt 1983 · S/N 17276039N9619BEuroaviation Inc Trustee · KematenBuilt 1981 · S/N 172RG0924N9619DSciotti Michael V · Wasilla, AKBuilt 1958 · S/N 22-6530N9619JFlick Kristina R · Port Ewen, NYBuilt 1966 · S/N 28-3773N9619LPeace Robert L II · Santa Fe, TXBuilt 1943 · S/N AA1B-0119N9619SCulp Barney L Jr · Emerald Isle, NCBuilt 1965 · S/N 13N9619WId Rather Knot LLC · Louisville, KYBuilt 1967 · S/N 28-23075N961AUAuburn University · Auburn, ALBuilt 2018 · S/N 172S12154N961CLRegistration Pending · North Las Vegas, NVRegistration pendingBuilt 1986 · S/N 0594
Back to AD 81-18-04 R2