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.

N8919JKelly Kevin R · Ormond Beach, FLBuilt 1965 · S/N 28-2935N8919VChristiansen John · Vicksburg, MIBuilt 1974 · S/N 17264276N891CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282411N891DBSpivak Maxim · San Jose, CABuilt 2001 · S/N 891-2001N891DDDiehl James W · Williamsport, PABuilt 2012 · S/N 71976N891GPHancock Aircraft Sales LLC · Baton Rouge, LABuilt 1967 · S/N 28-23847N891MDCharbonneau John E · Manhattan, KSBuilt 1960 · S/N 24-2045N891NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 4496555N8920DReese Larry H · Raytown, MOS/N 22-6077N8920JSargent Timothy E · Pickerington, OHBuilt 1965 · S/N 28-2937N89215Delgado Ruben E · San Antonio, TXBuilt 1978 · S/N 15282676N8921DPetterson Jason G · Albert Lea, MNBuilt 1958 · S/N 22-6078N8921RPotters Aviation LLC · Haskell, OKBuilt 1960 · S/N 7GCA-168N8921VN2827n LLC · Pembroke Pines, FLS/N 17264278N8922Culver Marc D · Anchorage, AKBuilt 1973 · S/N 493-73N89225Lucky Dog Aviation LLC · Victoria, TXBuilt 2022 · S/N 18283169N89226Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282682N8922DHassell Clark R · Ketchikan, AKBuilt 1958 · S/N 22-6079N8922JTowner Jeffery D · Rose Hill, KSBuilt 1965 · S/N 28-2939N8922VTampa Bay Aviation Inc · Clearwater, FLBuilt 1974 · S/N 17264279N8923Brockway Troy D · Salina, KSBuilt 1973 · S/N 481-73N8923DWood Rhonda R · Livermore, CABuilt 1958 · S/N 22-6080N8923JVenture West LLC · Mesa, AZBuilt 1965 · S/N 28-2940N8924CHaines Delmar W · Rolla, MOBuilt 1953 · S/N 22-1519N8924DHickey Aero Services LLC · White Hills, AZS/N 22-6081N8924RMachler Lance J · Murphys, CABuilt 1959 · S/N 152N8924VDupree Johnny · Crossett, ARBuilt 1974 · S/N 17264281N8924WRiblet Jeffrey L · Portsmouth, VABuilt 1964 · S/N 28-10489N8924YPrestininzi Robert Anthony · Fort Mill, SCBuilt 1969 · S/N 30-1997N8925FAztec Aviation · Geneseo, ILBuilt 1964 · S/N 0307N8925YBlue Sky Adventures LLC · Hanover, PAS/N 39-81N8926Johnson David H · Jasper, GABuilt 1973 · S/N 367-73N8926DPlanes & Things Inc · Collinsville, OKBuilt 1958 · S/N 22-6083N8926JGreene Ronald F · Mc Alpin, FLBuilt 1965 · S/N 28-2944N8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1974 · S/N 17264283N89273Anderson Ben H · Fort Smith, ARBuilt 1978 · S/N 15282697N8927JTipton Thomas G · Walnut Grove, MOS/N 28-2945N8927PSmith Tracy L · Middletown, CTBuilt 2000 · S/N 20-0049N8927VTropical Aviation LLC · Gulf Shores, ALBuilt 1974 · S/N 17264284N8927WFiihr Travis A · Grand Junction, COBuilt 1964 · S/N 28-10492N8928Anding Jay B · Bryan, TXBuilt 1973 · S/N 483-73N8928CGiber Kristofor D · Manvel, TXBuilt 1953 · S/N 22-1521N8928FDenver Aerospace Science Museum · Watkins, COBuilt 1964 · S/N 0004N8928JHaybron David M · Sewickley, PABuilt 1965 · S/N 28-2946N8928MKeyt Jeffrey D · New Providence, NJBuilt 1963 · S/N TD-555N8929Cavanagh James B · Litchfield Park, AZBuilt 1973 · S/N 255-73N8929JRice Spencer F · Portland, ORBuilt 1965 · S/N 28-2947N8929LPeters Nicholas J · Eagle River, AKBuilt 1974 · S/N 18-7409127N8929WSimmons Ralph R Jr · Sadler, TXBuilt 1964 · S/N 28-10494N892ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881398
Back to AD 81-18-04 R2