OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N14398Dyke Milo D · Hazen, NDBuilt 1949 · S/N 14-516N1439JBeckler Scott · Omaha, NEBuilt 1976 · S/N 439N1439UCass Aviation LLC · Henderson, NVBuilt 1976 · S/N 17267106N1439XDovy Aviation LLC · Houston, TXBuilt 1975 · S/N 28-7525301N143AMMcgee Ronald S · Las Vegas, NVBuilt 1997 · S/N 1081N143BHTappan Holdings Inc · Cadiz, OHS/N 21003CN143BSMoses Charles · West Friendship, MDBuilt 1966 · S/N 28-3792N143CCAerial Messages Leasing Co · Longwood, FLBuilt 2003 · S/N 9956CCN143CHHiers Craig L · Moultrie, GABuilt 1978 · S/N 3562N143DROroca Flying Club LLC · Weehawken, NJBuilt 1972 · S/N 17261119N143DVBruns Luke J · Flower Mound, TXBuilt 2007 · S/N 40026N143DWCardinal Aviation LLC · Towson, MDBuilt 1974 · S/N 32-7440164N143EBLewis Thomas B · Granbury, TXBuilt 2007 · S/N 40307N143EEFour Bs Montana Ranch LLC · Kalispel, MTBuilt 2014 · S/N 3218N143EYTriple D Aviation LLC · Merritt Island, FLBuilt 1968 · S/N 28-24348N143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290178N143GLLiebert Glenn W · New Albany, OHBuilt 1996 · S/N LIEBERT 0001N143HAHartman Dave · Miles City, MTBuilt 2021 · S/N 74318N143HPDans Aircraft Repair LLC · Gardiner, MTS/N NF0007N143JDHarris Steven V · Springtown, TXFirst renewal noticeS/N 8083CN143JJKinery Clifford J · Kewadin, MIBuilt 1947 · S/N 12-1705N143JMMa Cedric Sek-Kong · Los Angeles, CABuilt 1964 · S/N 28-20358N143LKRobbins Larry K · La Follette, TNBuilt 1994 · S/N 190N143LWMurphy Law Office Pc · Rapid City, SDBuilt 1979 · S/N R18201265N143MMPalo Michael Scott · Melbourne, FLBuilt 1970 · S/N 39-18N143MYPeaks Rental LLC · Aurora, COBuilt 2004 · S/N 10478N143PCFuqua Royce Owen · Early, TXBuilt 2004 · S/N 1379-2004N143PROrtiz Ramon L · Teaneck, NJBuilt 1997 · S/N 22106N143PSDrake Barbara A · Pensacola, FLBuilt 1986 · S/N 045N143RNCollins Glen K Trustee · Appleton, NYBuilt 2012 · S/N 20385N143RRHale Arthur H · Angleton, TXBuilt 1972 · S/N AA1A-0397N143RVLefevre Garrett R · Tucson, AZBuilt 1998 · S/N 22143N143RWWendell Ross · Ankeny, IABuilt 2013 · S/N 40450N143SDWhiskey Fox Group LLC · Destin, FLS/N 25005CN143SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4132N143TMurray Paul M Trustee · Storm Lake, IABuilt 1953 · S/N 18-2257N143TBSmith Timothy T · Turkey, NCBuilt 1979 · S/N 28-8011053N143WScott Jeffrey E · Cherokee Village, ARBuilt 2011 · S/N 655N143ZLYoder F David · Wellington, FLBuilt 1999 · S/N 0030N1440CChamberlain Howard D · Lisbon, OHFirst renewal noticeBuilt 1953 · S/N 22-1194N1440UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020248N1440XAlldredge Brad · Redlands, CABuilt 1963 · S/N 24-3478N1441AStewart Aviation LLC · Seymour, INExpired dealer, pending cancellationBuilt 2018 · S/N 1441N1441CTroyer Cody L · Macon, MSS/N 20985N1441JErca Abby · Denton, TXS/N 441N1441PN1441p LLC · Pompano Beach, FLBuilt 1973 · S/N 17260993N1441RJorgensen John K · Dewey, AZS/N AA1B-0541N1441VYegge David J · Hartland, MIBuilt 1974 · S/N 17263579N1442CMakelbust Michael J · Ames, IABuilt 1977 · S/N 17702728N1442PJones Isaac W III · Alabaster, ALBuilt 2021 · S/N 140644
Back to AD 81-18-04 R2