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.

N5536JHanna Patricia A · Davis Junction, ILS/N 32-999N5536PGryhon Designs · Camden, SCBuilt 1958 · S/N 24-600N5536QWokini Air LLC · Tarpon Springs, FLS/N 621N5536UPittman Discover Flight LLC · Oshkosh, WIBuilt 1969 · S/N 28-26257N5536WSchilke Kenneth · Imperial, NES/N 28-626N55372Mccarroll Daniel C · Saint Augustine, FLS/N 1188N55374American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275170N55378Iacobacci Timothy · Fairborn, OHBuilt 1973 · S/N 34-7350207N5537ARobinson Albert B · Byhalia, MSS/N 20-776N5537HLine Michael · University Park, MDBuilt 1979 · S/N 15284121N5537KSales First LLC · Jasper, GABuilt 1978 · S/N 392-78N5537MWiglesworth David G · Lenexa, KSBuilt 1967 · S/N 123N5537PField Gerard · Middleboro, MABuilt 1958 · S/N 24-601N5537RBalady Nabih · Santa Clarita, CABuilt 1979 · S/N 172RG0073N5537SMcpeak Alan W · Colorado Springs, COBuilt 1980 · S/N R18201600N55380Clark Joseph David · Kilgore, TXS/N 28-7325388N55383Winkelman James R · Zionsville, INBuilt 1973 · S/N 28-7305371N55386Redlands Flying Club · Redlands, CAS/N 1189N5538ARado Robert L · Petersburg, MIBuilt 1952 · S/N 20-944N5538KHilowitz Andrew J · Anchorage, AKBuilt 1978 · S/N 1045-78N5538QDurkee Brenton J · Brooklyn, NYBuilt 1965 · S/N 622N5538UAircraft Sales LLC · Caledonia, MIBuilt 1969 · S/N 28-26260N5538ZBradburn William P · Pearl River, LAS/N 22-9328N55390Davis Hunter · Winters, TXBuilt 1973 · S/N 28-7310134N55392Fast Aircraft Aerowork Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325391N55397Stephens Ryan L · Gardner, ILBuilt 1973 · S/N 28-7305374N55398Three Wire LLC · Portland, ORBuilt 1981 · S/N 17275174N5539ASchneider Benjamin J · Wheeling, WVS/N 20-945N5539FAeronautical Technical Service Inc · Collierville, TNBuilt 1968 · S/N 28-24938N5539JCarr Paul · Ottumwa, IAS/N 32-1000N5539QJostad Leo D · Bottineau, NDBuilt 1965 · S/N 2958N5539TPattison Aero Inc · Henderson, NVS/N R18201889N5539UDickey Blaine K · Marion, ARBuilt 1969 · S/N 28-26261N553APAviation Paradise LLC · Homestead, FLBuilt 1980 · S/N 17274554N553BBJpm Flying Service LLC · Marine, ILBuilt 2017 · S/N 2014N553BCCarlson Robert A · Red Wing, MNBuilt 2001 · S/N 2171N553BDBooker Daniel R · Newaygo, MIBuilt 2020 · S/N 75-10566N553FLWalters Rande L Sr · Lock Haven, PABuilt 1971 · S/N 28-7125392N553HBrantley Hugh L · Hazlehurst, GABuilt 1971 · S/N AA1A-0295N553KMRieder Kenneth J · Cincinnati, OHBuilt 2004 · S/N 81553N553MBBickling Melvin T · Johnstown, COBuilt 2011 · S/N 91457N553PCSaint Louis University · St Louis, MOBuilt 2001 · S/N 4496072N553PGAnderson Adam Z · Bay City, MIBuilt 2005 · S/N 2318N553PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842090N553RARich Aviation Services LLC · Fort Worth, TXBuilt 2012 · S/N 172S11176N553RVLittmann Daniel M · Broken Arrow, OKBuilt 2018 · S/N 74536N553SWillhoite Steven B · Louisburg, KSBuilt 1998 · S/N 1998N553SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881342N553SFSmith Nancy R · Duluth, MNBuilt 1966 · S/N 247N553TPOakland Flyers LLC · Oakland, CABuilt 1975 · S/N 28-7690105
Back to AD 81-18-04 R2