OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N279WYMccarty David · Baker City, ORBuilt 2017 · S/N 3279N279YRegistration Pending · Seneca, SCRegistration pendingBuilt 2008 · S/N 027N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306N27AMThom Jacob D · Wasilla, AKBuilt 1990 · S/N 001AMN27AUAndrews University · Berrien Springs, MIBuilt 2014 · S/N 2843768N27AZGilbert John K · Austin, TXBuilt 2022 · S/N 1217N27BATerrill Dana R · Port Angeles, WABuilt 1952 · S/N 22-819N27BEAir N Nautical LLC · Kalispell, MTBuilt 1998 · S/N 1418N27BLFairmont State University · Fairmont, WVBuilt 2020 · S/N 172S12467N27CMM & J Enterprises · Union, SCBuilt 1979 · S/N 571N27CWRebr Holdings LLC · Hernando, FLS/N 711N27CYSale Reported · Hastings, FLSale reportedBuilt 1976 · S/N 27-7654118N27DASiewruk Cameron M · Stuart, FLBuilt 1978 · S/N 32-7840084N27DRN504fl LLC · Killeen, TXBuilt 2003 · S/N 24703N27DWFritschle Derek R · Olney, ILBuilt 1975 · S/N 94N27EGVetterman Larry D · Hot Springs, SDBuilt 2017 · S/N 062N27EKPrecision Aviation Training LLC · Newberg, ORBuilt 2022 · S/N 1311N27GFAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274608N27GHNelson Aviation LLC · Chesterfield, MOBuilt 2017 · S/N 18283019N27GSMazzola Michael · Baton Rouge, LABuilt 1977 · S/N 28R-7737160N27GWWatson Gary R · Modesto, CABuilt 1982 · S/N 0002N27GZKelly Kristofor · Belton, TXBuilt 2000 · S/N 01N27HCCranston Courtland L · Santa Rosa, CAS/N 1N27HPTrinair Aviation LLC · Hampshire, ILBuilt 1962 · S/N 27-2034N27HRRemer Herbert I · Punta Gorda, FLBuilt 1999 · S/N 1444N27HSSchooler Harold L · Chico, CABuilt 1980 · S/N HS-1N27HTTaylor Arthur W · Oswego, NYBuilt 2020 · S/N 20685N27HUOlson Dorian J · Lake Park, MNBuilt 1997 · S/N 1359N27HWJacobs Jim · Great Barrington, MABuilt 2018 · S/N 1177-2018N27HYMiand Inc · Laporte, INBuilt 1999 · S/N 1457N27JOliver Paul D · Hedgesville, WVBuilt 1989 · S/N 1N27JSSmith Cattle Company LLC · Steamboat Rock, IABuilt 1974 · S/N 177RG0629N27JWGaither William W · Shallotte, NCS/N 17701148N27KHume James W · Valley View, TXBuilt 1987 · S/N 1067AN27KDArnold Lon B · Huntington, UTBuilt 1984 · S/N 667N27KKButler Robert Wynne Jr · Boyce, LABuilt 1962 · S/N 28-792N27KPMcgaughey Patrick L · Los Alamos, NMBuilt 2007 · S/N 22066N27LASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 17265689N27LMFrerichs Jacob L · Sidney, NEBuilt 2017 · S/N 02N27LTPitts Roger D DBA · Hickory, NCBuilt 1982 · S/N 32R-8213060N27LZAnderson Erik Hale · Albuquerque, NMBuilt 2006 · S/N 27N27MASchreder Buster S · Hailey, IDBuilt 2007 · S/N 2397N27MBPetrocelli James · St James, NYBuilt 2018 · S/N CC19-0033N27MCFratangelo Robert A · Sodus, NYBuilt 1969 · S/N 690043N27MERosario Theodore · Salome, AZS/N M-1N27MHCurry Michael J · Ardmore, TNS/N 198N27MRRedemption Inc DBA · Kodiak, AKS/N 884N27MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12599N27MWHempy David · Lexington, KYBuilt 2014 · S/N M001WN27NCNames Lock K · Eugene, ORBuilt 1989 · S/N NW-3
Back to AD 81-18-04 R2