OpenAirDocs.org
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.

N449PMMullenbach Michael R · Saint Ansgar, IABuilt 1999 · S/N 1466N449PSMid Atlanta Air Museum · Reading, PABuilt 1974 · S/N 12449N449RMRocky Mountain College · Billings, MTBuilt 2024 · S/N 28020198N449RVRobinson Stewart · San Jacinto, CABuilt 1998 · S/N 20449N449SPGolden Eagle Flying Club Ltd · West Islip, NYBuilt 1999 · S/N 172S8315N449WFGlenns Super Cub LLC · Fort Lauderdale, FLS/N 18-7773N44ABAnthony Ronald W · Claremont, CABuilt 1975 · S/N 22-1196N44ADTice Logan Edward · Noblesville, INBuilt 1979 · S/N 123ADN44AJMyers Nathan · Clarksburg, CABuilt 1981 · S/N 38-81A0113N44AKAvcom Co · Friday Harbor, WABuilt 1978 · S/N 61P-0481-194N44AYPartin Kathy L · Nacogdoches, TXS/N 28R-7535012N44BAKnop Horacio M · Miami, FLBuilt 1979 · S/N 38-79A0442N44BKBirum Kevin M · Kingston, WABuilt 2001 · S/N 5573N44BLBoehr Greg J · Mc Cool Junction, NES/N 17256854N44BWMariani Aviation Services LLC · Vero Beach, FLBuilt 1987 · S/N 219N44CAWiley Commercial Property Consulting Inc · Aitkin, MNBuilt 1980 · S/N R18201556N44CUAirstar Aviation LLC · Manawa, WIBuilt 1976 · S/N 17268037N44CZHeer James A · Lutz, FLBuilt 1988 · S/N 1N44DMGorge Winds Aviation Inc · Fairview, ORBuilt 1973 · S/N 17261488N44DQTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2005 · S/N 10821N44DZWanted Poster Owners Group LLC · York, PABuilt 1973 · S/N 32-7300046N44EBray Nick R Trustee · China Spring, TXBuilt 1947 · S/N 12-2575N44EKBas Part Sales LLC · Greeley, COS/N 0690N44EWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 1-0058N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500N44FMHolmgren David P · Kamas, UTBuilt 1995 · S/N LB-1N44FSJinsky Ronald G · Beloit, WIBuilt 1975 · S/N 717N44GDCarver Michael A · Ocala, FLBuilt 2009 · S/N 004N44HDAir Assault Agricultural Aviation LLC · New Castle, VABuilt 2005 · S/N 1498N44HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 1995 · S/N 0214N44HKBradt Joseph J · Inver Grove, MNBuilt 1997 · S/N 79597N44HNCedar Ridge Aviation LLC · Knox City, TXBuilt 2005 · S/N 1455N44HUFritsche James G · Greenleaf, WIBuilt 1997 · S/N 1353N44HYCochran Thomas S · Fort Collins, COBuilt 2001 · S/N 2145N44JAJersey Aero Club Inc · Lakewood, NJBuilt 1983 · S/N 32-8306031N44JLBushcat Goldie LLC · Oro Valley, AZBuilt 2015 · S/N 72279N44JRRodgers Jerry T · Bishop, CABuilt 1997 · S/N 24545N44JUEcho Mike Consulting LLC · Wilmington, DEBuilt 2004 · S/N 10517N44JYAcre LLC · Abilene, KSBuilt 1969 · S/N 32-40637N44KDSale Reported · Crystal, MNSale reported, canceledBuilt 1972 · S/N 28R-7235106N44KERegistration Pending · Charlo, MTRegistration pendingBuilt 1984 · S/N 001N44KGSpanogle Michael M · Chugiak, AKBuilt 1989 · S/N 4074CN44KLStell Brandon A · Mechanicsville, VAS/N 803N44KPHargrave Margarite D · Seattle, WABuilt 1978 · S/N 172-70904N44LETp Aviation LLC · Redding, CABuilt 2009 · S/N 3058N44LFFry Larry D · Ocala, FLBuilt 2021 · S/N 70947N44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273400N44LNBrown Bear Air Inc · Anchorage, AKBuilt 2005 · S/N 10848N44LRRouse Peter L · Parkville, MOBuilt 1996 · S/N 1N44LTLonderville Ross G · Stanwood, WABuilt 1984 · S/N 348
Back to AD 81-18-04 R2