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.

N6304ZVintage Aero Sports LLC · Easton, PABuilt 1960 · S/N 25-388N6305CDanko Aviation Inc Trustee · Wilmington, DES/N 1873N6305LBrewe Matthew P · Odessa, MOBuilt 1971 · S/N AA1A-0305N6305NPerera Nandana L · Logan, OHBuilt 1967 · S/N 207N6306JCampbell Christopher J · Enterprise, ALBuilt 1968 · S/N 28-4717N6306NSmith Michael J · Chebanse, ILBuilt 1967 · S/N 228N6306QMaxwell Paul · Longview, TXBuilt 1967 · S/N 670399N6306VCoyle William L · Kiowa, COS/N 2526N6306WNovotny Warren · Wadsworth, OHS/N 28-20350N6307JMiloud Chadd · Fort Worth, TXBuilt 1980 · S/N 17273860N6307LSheltra Reese Hanna · Margate, FLS/N AA1A-0307N6307MN6307m LLC · Terra Ceia, FLBuilt 1985 · S/N 306N6307WJohnson Bradley M · Belgrade, MTS/N 28-20351N6308DBjornoos Robert · Cambridge, MNBuilt 1974 · S/N 28-7510023N6308JKatuzienski Joseph C · Yorktown, VABuilt 1980 · S/N 17273861N6308NJ Squared Enterprises Corp · Hendersonville, TNBuilt 1967 · S/N 194N6308PWilloughby Duane L · Amissville, VABuilt 1959 · S/N 24-1418N6308RIngalls Randy · Alexandria, LABuilt 1979 · S/N 172RG0159N6309AWilliams Mike · Hartsville, INBuilt 1978 · S/N 38-78A0378N6309LMauro Diogo T · Little Elm, TXBuilt 1971 · S/N AA1A-0309N6309NJohnson Darrick C · Wolford, NDBuilt 1967 · S/N 233N6309QRegistered aircraftBuilt 1967 · S/N 670402N6309RAerowolfe Aircraft Services LLC · Spokane, WABuilt 1966 · S/N 28-21475N6309VHamilton Paul L · Arlington, VABuilt 1980 · S/N 172RG0617N630APThomas Lucas G · Beebe, ARBuilt 1974 · S/N 69-74N630BJJones Robert M · Brooksville, FLBuilt 1969 · S/N 28-26111N630FTAilabouni Adam · Northfield, MNBuilt 1991 · S/N 10042N630HCDgsz Aero Inc · Bear, DEBuilt 1980 · S/N 28-8090268N630HRMiga Holdings LLC · Flower Mound, TXBuilt 2006 · S/N 172S10205N630KTLetourneau Duane R · Oconto, WIBuilt 2000 · S/N 28-43397N630MSHelicrop LLC · Menlo, IAS/N 0885N630RLSieverling John M · Conway, ARBuilt 2001 · S/N 80458N630RVBialon Mark C · Pine River, MNBuilt 2017 · S/N 101N630TFlying Cow Farm LLC · Mount Pleasant, ARBuilt 1988 · S/N MII-889N630TCN630tc LLC · Nashville, TNBuilt 1976 · S/N 17267047N63101Gill Michael J · Marshfield, MABuilt 1981 · S/N 17275391N6310LKuczer Ronald R · Chesterfield, MOBuilt 1971 · S/N AA1A-0310N6310NHumbert Jeff M · Cottonwood, CABuilt 1967 · S/N 463N6310PPopel John G Sr Trustee · Piqua, OHBuilt 1959 · S/N 24-1420N6310RCcb Warriors LLC · Lawrence, KSBuilt 1966 · S/N 28-21476N63113High Road Time LLC · West Palm Beach, FLS/N 17275392N63128Crutchfield Richard E · Alpine, CABuilt 1998 · S/N 1N6312CLibra Air Inc · Las Vegas, NVBuilt 1978 · S/N 28-7816405N6312NSmith Sabra L · Danville, CABuilt 1967 · S/N 308N6312QBarker Silas J · Sanford, FLBuilt 1967 · S/N 670405N6312VMoss Lake Ski Club LLC · Cherryville, NCBuilt 1998 · S/N 24068N6313CShouling & Philip Enterprise · Lancaster, CABuilt 1978 · S/N 28-7816406N6313FTeens In Flight Inc · Palm Coast, FLBuilt 1979 · S/N 17273188N6313UJones Aaron C · Hesperia, CABuilt 1997 · S/N 22165N6313WFlight Plan LLC · Friendswood, TXBuilt 1964 · S/N 28-20359
Back to AD 81-18-04 R2