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.

N7266NBeck Robert A · Cove, ORS/N 20608058N7266PGrover Donald G · Canby, ORBuilt 1961 · S/N 24-2442N7266QLima-001 LLC · Muscatine, IABuilt 1972 · S/N 17260566N7266WNewland Hunter R · West Valley City, UTBuilt 1963 · S/N 28-1099N7266YAvero Aviation LLC · Dover, DEBuilt 1999 · S/N 20608059N7266ZBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1999 · S/N 20608060N72671Vfr Aircraft And Training LLC · Jackson, MOBuilt 1999 · S/N 18280495N72675Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2001 · S/N 172S8977N7267FRegistered aircraftBuilt 1968 · S/N 28-25187N7267GWells Jack D · Newtown, MOBuilt 1970 · S/N 17258967N7267JSe Aviation LLC · Boise, IDBuilt 1968 · S/N 28-24464N7267TDmcc LLC · Lewes, DEBuilt 1999 · S/N 18280523N7267WGillespie Michael Lee · Jacksonville, FLBuilt 1963 · S/N 28-1185N7267YVolatilis Aviation LLC · Collinsville, ILS/N 18280500N7267ZHoffpauir Jeremy · Broussard, LABuilt 1999 · S/N 18280525N72681Riggs Benjamin D · Reynoldsburg, OHBuilt 1946 · S/N 9857N72689Brown Nathan · Snellville, GABuilt 2000 · S/N 18280820N7268DLarsen Daniel R · Kenai, AKBuilt 1957 · S/N 18-5676N7268FFarber Gerald · Las Cruces, NMBuilt 1999 · S/N 18280527N7268GSteel & Supply Co LLC · Pensacola, FLBuilt 1999 · S/N 18280528N7268KFelts Field Flying Club · Spokane Valley, WABuilt 1999 · S/N 18280491N7268LFletchair Inc · Comfort, TXS/N AA1A-0468N7268PSurdex Corp · Chesterfield, MOBuilt 1999 · S/N T20608043N72692Mccurdy Dwight B · Anderson, INBuilt 2000 · S/N 20608139N7269416 Sandals LLC · Tuscaloosa, ALBuilt 1999 · S/N 18280479N72697Cbt Aviation LLC · Bellingham, WABuilt 1999 · S/N 20608031N7269BReece Vance · Winnsboro, TXBuilt 1999 · S/N 18280490N7269FChandler Joseph · Amana, IABuilt 1968 · S/N 28-25191N7269GBranson Barry R · Shasta Lake, CABuilt 1970 · S/N 17258969N7269PBoucher Bobbi · Fredericksburg, VABuilt 1961 · S/N 24-2445N7269QBaker Mark · White Bear Lake, MNBuilt 1972 · S/N 17260569N7269RSm1019 LLC · Gillette, WYBuilt 1976 · S/N 292/24-04N7269WButtercup Express LLC · Woodward, OKS/N 28-1103N726ACGrass Roots Aviation LLC · Bend, ORBuilt 1999 · S/N 1276-99N726AJStarr Alan D · Senoia, GABuilt 1969 · S/N 17701378N726AMRegistered aircraftBuilt 1953 · S/N 26009N726BBStater Christopher B · Charlotte, NCBuilt 1986 · S/N 2811003N726CMEvans Douglas A · Amarillo, TXBuilt 2001 · S/N 1347N726CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11566N726DFTactical Aviation LLC · Brownstown, MIBuilt 1981 · S/N 28-8216023N726DTThompson Donald H · Tallahassee, FLBuilt 2000 · S/N 002N726EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13029N726GHead David A Trustee · Livermore, CABuilt 2012 · S/N 40746N726GASouth Texas Air Force LLC · Mission, TXBuilt 1978 · S/N GA7-0025N726JHClearview Flying Club Inc · Westminster, MDBuilt 1977 · S/N 17269494N726JVGill James J · Anchorage, AKBuilt 1978 · S/N 18-7809088N726LLRegistration Pending · Fargo, NDRegistration pendingBuilt 2010 · S/N LL001N726LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13587N726MBBurgos Orlando · Venice, FLBuilt 1982 · S/N 17275766N726MMRiverside Flight Academy LLC · Riverside, CABuilt 1979 · S/N 17272970
Back to AD 81-18-04 R2