OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,718

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.

N113FCDistributed Motion LLC · Sandpoint, IDBuilt 1969 · S/N M-1229N113FSHallahan Robert J · Central Square, NYBuilt 1974 · S/N 17262996N113GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881455N113HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281159N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226N113JCMcdonnell Bryant E · Boulder, COBuilt 1982 · S/N 28-8211027N113JGTaveniku Mikael · Painted Post, NYS/N DM0113N113JJRendleman Robert T · Murphysboro, ILBuilt 2000 · S/N 858-2000N113JKBusciglio Daren A · Tampa, FLBuilt 2009 · S/N 21369N113JRGrant Jose A · Jefferson, GABuilt 1975 · S/N M-1615N113JSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1992 · S/N 3134N113JWGrass Roots Aviation LLC · Bend, ORBuilt 2004 · S/N RV623839N113JYFreeman Alan M · San Antonio, TXS/N 482RN113KCGolden Valley LLC · Missoula, MTBuilt 2018 · S/N 41573N113KRIal Corp · Lewes, DEBuilt 1974 · S/N 28-7415211N113MAMyllyla Ray J · Woodland Hills, CABuilt 1999 · S/N 304N113MEButler Robyn L · Vale, ORS/N 909-76N113MSFly2walk LLC · Loveland, COBuilt 1996 · S/N 1217-96N113MXN113mx LLC · Redding, CAS/N 002N113NShaw Brandon L · Juneau, AKBuilt 1998 · S/N 1422N113PATundra Aviation Inc · Casselton, NDBuilt 1948 · S/N 14-113N113PCProp & Jet Air Museum Inc · Romoland, CABuilt 1982 · S/N 1N113PJLang Carl · Harper, TXBuilt 2003 · S/N 9957CCN113PVVaneau Philip M · Kerrville, TXBuilt 1987 · S/N DENTON GIVENS 1N113RVMason Chance L · Elwood, INBuilt 1988 · S/N 1029N113SJGlumac Stanley Jr · Grindstone, PABuilt 1993 · S/N 21400N113SVChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9512N113SWFargo Jet Center LLC · Fargo, NDBuilt 1977 · S/N 28-7890298N113TSMilitary Aviation Museum · Virginia Beach, VABuilt 2012 · S/N 081295N113UDRv8rs Anonymous LLC · Cincinnati, OHBuilt 2002 · S/N 80459N113UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1218N113VGN113vg LLC · Princeton, NJBuilt 1993 · S/N 2391N113WYRyals Barry · Rhine, GABuilt 1974 · S/N 28R-7535055N114Cooper Michael D · North Turner, MEBuilt 1954 · S/N 18-3937N11402Mcdowell Charles R II · South Charleston, WVBuilt 1973 · S/N 15075391N1140CAtkins Alvin R · Barnstead, NHBuilt 1953 · S/N 22-973N1140JGardner John D · Tallahassee, FLBuilt 1974 · S/N 140N1140PCromley Amanda J · Lewisburg, PABuilt 1955 · S/N 23-152N11411Baca Marciano A · Los Angeles, CAS/N 1506-20N1141MSunshine Flyers · Auburn, CAS/N 17260152N1141UFlight School Inc · Spring, TXBuilt 1976 · S/N 17266870N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338N1142QSteely Paul · Williamsburg, KYBuilt 1977 · S/N 28-7790378N1142UCorporacion Dbm LLC · Miami, FLBuilt 2005 · S/N 18281604N1143ENevarrow Leon · Spring Valley, CABuilt 1977 · S/N 1215-77N1143JDurrah Anthony E Sr · Charlotte, NCBuilt 1974 · S/N 143N1143MCastelletti Mark Anthony Trustee · Casa Grande, AZBuilt 1970 · S/N 17259443N1144AKramer John Edward · Conroe, TXBuilt 1951 · S/N 18-737N1144JLee Carl B · Bullard, TXBuilt 1974 · S/N 186N1144KYoung Bradley M · Vancouver, WABuilt 1981 · S/N 24-1185
Back to AD 81-18-04 R2