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.

N8175NClassical Organs Of Texas LLC · Liberty Hill, TXBuilt 1982 · S/N 32-8206030N8175PCunningham James L · Tucson, AZBuilt 1963 · S/N 24-3431N8176Lewandowski Mark J · Wilton, CABuilt 1971 · S/N 1207N8176CShaffer Glenn · Vinemont, ALBuilt 1954 · S/N 18-3632N8176PHundley Jeffrey S · Parker, COBuilt 1963 · S/N 24-3432N81771Skyfusion II LLC · Atlanta, GABuilt 1980 · S/N 28-8090269N81774Pc Limited LLC · N Dighton, MABuilt 1982 · S/N 32-8206015N8177NAspiras Dionisio O Jr · Rosharon, TXBuilt 1968 · S/N 28-25373N8177WDavis James Warren · Albemarle, NCBuilt 1965 · S/N 28-2301N81795Flat Land Aviation & Training LLC · Seward, NEBuilt 1980 · S/N 32R-8013080N8179AFelker Lonnie A · Burbank, CABuilt 1980 · S/N 28-8011065N8179DGarza Jose R Jr · West Jordan, UTBuilt 1971 · S/N 177RG0009N8179HSam Air LLC · Daphne, ALBuilt 1982 · S/N 28-8216138N8179NFletcher William J · Mason, NHBuilt 1968 · S/N 28-25375N8179THill Jason M · Bakersfield, CABuilt 1960 · S/N 17556879N8179WLynch Gary L · Ocala, FLBuilt 1965 · S/N 28-2303N8179ZGambacorta Paul E · Leonardtown, MDBuilt 1980 · S/N 32-8006024N817AAnderson Jennifer M · Biggs, CAS/N 22-121N817ABHawaii Pacific Aviation Inc · Kailua Kona, HIS/N 1258N817ACCannon Air Force Base - Aero Club · Clovis, NMBuilt 2003 · S/N 2842190N817AKZweifel Brad · Palmer, AKBuilt 1958 · S/N 55101N817ARLive More LLC · Crowley, TXBuilt 1981 · S/N 60-0894-8161253N817ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496536N817BWWalker Baylor L · Big Spring, TXBuilt 2001 · S/N S1813N817CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281257N817DHMastrangelo John A · Phoenix, AZBuilt 2003 · S/N 1341-2003N817DMRegistered aircraftBuilt 2007 · S/N 40401N817EPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13592N817FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13457N817GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881465N817HAIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280828N817HSMoore Stephen T · Ellensburg, WABuilt 2012 · S/N 91132N817JJenkins Jay T · Burnsville, MNBuilt 1999 · S/N 80017N817JCCain Jerome M · Lincoln, MTBuilt 1999 · S/N 1465N817JVRusyniak Anthony J · Syracuse, NYBuilt 1995 · S/N 1283N817KBaquero Eric P · New Castle, COBuilt 1963 · S/N 24-3445N817KCCrawford Michael R · Gainesville, GABuilt 1976 · S/N AS-1N817LHHavelka Lambert H · Mc Gregor, TXBuilt 2017 · S/N 41054N817NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881047N817TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881594N817YLandon William Walton IV · Fairbanks, AKS/N 8085-CN817ZBennett Condon P · Stormville, NYBuilt 1976 · S/N 17266787N81809Corporation Of The Catholic Archbishop Of Anchorag · Anchorage, AKBuilt 1980 · S/N 28-8016221N8180CSnoopy Air LLC · Kalispell, MTBuilt 1954 · S/N 18-3637N8180MLeap Aviation Inc · Wilmington, DES/N 17260570N8180PGriffin Robert · Middletown, DES/N 24-3436N8180WD And D Air Inc · Paola, KSBuilt 1965 · S/N 28-2305N8180YG2g Aviation LLC · Wray, COBuilt 1966 · S/N 30-1296N8181DMuleshoe Ranch Inc · Belle Fourche, SDBuilt 1957 · S/N 18-6116N8181HLao Investments LLC · Meeker, COBuilt 1980 · S/N 288011073
Back to AD 81-18-04 R2