OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,700

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.

N102SJHelms Robert J · Alton, UTBuilt 1971 · S/N 17259570N102TRegistration Pending · Anchorage, AKRegistration pendingBuilt 1954 · S/N 18-2216N102TCMason Brian L · Eagle River, AKS/N 18-7909038N102UCWest Valley Flying Club · Palo Alto, CABuilt 1980 · S/N 15284832N102VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5806N102WPGarcia Randy S · Montebello, CABuilt 1991 · S/N S1572N102WRSt Onge Adam R · Sterling, AKBuilt 1952 · S/N 20-919N102WZVcxi Red LLC · Sheridan, WYBuilt 2019 · S/N 70737N102ZMann Arthur A III · Cartersville, GABuilt 2019 · S/N 2018-001N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319N1030NDcaw Aviation LLC · Advance, NCBuilt 2006 · S/N 3246242N1030TZamora Milamaedelza · Panorama City, CAS/N 65N1030ZLenhart Thomas E · Barnesville, GABuilt 1997 · S/N 23041CN1031SRedmon James A · Frisco, TXBuilt 1977 · S/N 15279996N10329Lissow William M · New Port Richey, FLS/N 22018CN1032JKornegay Kenneth D · Roanoke, VABuilt 1973 · S/N 32N1032SThurber Matthew Calbraith · Vancouver, WABuilt 1980 · S/N 144-HN10339Yarbro Floyd A · Kenton, TNBuilt 1997 · S/N 21022CN1033AAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 17281238N1033CHuson Lee E · Port Townsend, WABuilt 1997 · S/N 25012CN1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35N1033XHorizon Enterprises LLC · Kalispel, MTBuilt 1975 · S/N 28-7515376N1033YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 172S10598N1034AHawk Don · Shady Cove, ORS/N 18-606N1034ENexga Aircraft Inc · Greensboro, NCBuilt 1977 · S/N 1205-77N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198N1035EJobe Ronald G · Sedalia, MOBuilt 1977 · S/N 983-77N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222N10365Air Heritage Inc · Beaver Falls, PABuilt 1954 · S/N 54-2533N1036JPremier Jets Inc · Hillsboro, ORS/N 36N1036MMangon Aircraft Inc · Petaluma, CABuilt 2007 · S/N 172S10599N1036NKovaleski Thomas J · Chugiak, AKBuilt 1997 · S/N 23035CN1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079N10375Tactical Turtle LLC · Ortanna, PAS/N 67-18376N1037JTate Andrew E · Chapel Hill, NCBuilt 1973 · S/N 37N1038EFueston Vernon A · Montague, CABuilt 1977 · S/N 971-77N1038FPetrick Dan A · Punta Gorda, FLBuilt 1969 · S/N 28-25552N1038JLandgraf Robert J · Sussex, WIBuilt 1973 · S/N 118N1038NSome Beech LLC · Bolivar, MOS/N 85-0360N1039DPetro Jerry R · Williamsburg, VABuilt 1982 · S/N 50N1039JN1039j LLC · Casa Grande, AZBuilt 1973 · S/N 101N1039MManly James H · Reno, NVBuilt 1998 · S/N 513N1039PN1039p LLC · Suwanee, GABuilt 2005 · S/N 18281566N1039UIowa Lakes Community College · Estherville, IABuilt 1971 · S/N 34-7250024N1039XSilvered Wings LLC · Howell, MIBuilt 1975 · S/N 28-7525265N103AASmith George Barker · Lexington, KYBuilt 2007 · S/N 2411N103ACKrueger Douglas K Trustee · Aurora, NEBuilt 1992 · S/N 362-92N103ARHd Outdoor Advs LLC · Coalgate, OKBuilt 2005 · S/N 18281663N103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084
Back to AD 81-18-04 R2