OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,718

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.

N11684Pepper Richard V · Henderson, TXBuilt 1972 · S/N 309-72N11686Hopewell Jeffrey D · Temple, TXS/N 310-72N11687Young William A · Delta Junction, AKBuilt 1972 · S/N 313-72N1168CPartridge James R · Chino Valley, AZBuilt 1953 · S/N 22-994N1168LDepaul Thomas J · Juneau, AKBuilt 1966 · S/N 330N1168PLangford Michael J · Middletown, MDS/N 3703N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219N11690Evers William J · Sussex, WIBuilt 1972 · S/N 355-72N11695Rvi Aviation LLC · Clay Center, KSBuilt 1972 · S/N 856-72N1169AK-Air Service LLC · Gakona, AKBuilt 1951 · S/N 18-767N1169HSwihart Matthew Allen · San Marcos, TXBuilt 1975 · S/N AA5B-0063N1169N69 November LLC · Driftwood, TXBuilt 1982 · S/N 24-1309N1169RClayton Alfred T Jr · Anchorage, AKBuilt 2007 · S/N 004N116AJJewett Chris E · Lexington, SCBuilt 2004 · S/N DC03N116ARLower Timothy C · Biglerville, PABuilt 1997 · S/N 24850N116ATTrevisan Hugo S · Polk City, FLS/N 38-78A0731N116AVValleortiz Hector J · Laurel Hill, NCBuilt 1984 · S/N 28-8416094N116BBretana Charles Jr · Prescott, AZS/N E006N116BHBighorn Airways Inc · Sheridan, WYBuilt 1963 · S/N 18-8041N116BKDacy Roy W · Rockport, TXS/N 32-782N116BWButler Ross W · Jackson, CABuilt 2001 · S/N 24986N116CCCrawford E Clarke · Flagstaff, AZBuilt 1992 · S/N 824N116CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283012N116CRConti Christine M · Plantation, FLBuilt 1976 · S/N 17266985N116CWJazun Carlos Walter · Parker, COBuilt 2015 · S/N 0073385N116DRegistration Pending · Reese, MIRegistration pendingBuilt 2022 · S/N 18283203N116DHHoover David · Foster City, CAFirst renewal noticeBuilt 1990 · S/N 0001N116DPPaup Dennis C · Carroll, IABuilt 2006 · S/N 70194N116DWWalters Douglas B · Templeton, CABuilt 2020 · S/N 21807N116FLMerdes Gordon B · Corpus Christi, TXBuilt 1974 · S/N 18-7509029N116FPRandall David J · Balsam Lake, WIBuilt 1978 · S/N 17271241N116FRCloverfield Aero LLC · Los Angeles, CABuilt 2014 · S/N 2844150N116GRegistration Pending · Sheridan, WYRegistration pendingBuilt 1995 · S/N 23019CN116GSTharp Thomas J · Nampa, IDBuilt 2001 · S/N 1298009N116JEAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12167N116JMMorgan James E · Everett, WABuilt 2009 · S/N RV20260N116JTParks Kevin J · Arlington, TNBuilt 2009 · S/N 80982N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820N116MRDibuono Michael · Clearwater, FLBuilt 2025 · S/N 0700N116MSArps Alan D · Schuyler, NEBuilt 1997 · S/N 203N116NJUsda Forest Service Fepp · Trenton, NJBuilt 1964 · S/N 18-8104N116PMiller Robert J · Casselton, NDBuilt 1977 · S/N M79470N116PCGlobal Piloting Solutions LLC · Mankato, MNBuilt 2001 · S/N 1320-2001N116PGUnusual Attitudes LLC · Bates City, MOBuilt 2004 · S/N 3547N116PWRm Construction LLC · Greeley, COS/N 116N116QCigarroa Jorge J · Laredo, TXBuilt 1997 · S/N 1360N116RJRegistered aircraftS/N 3227N116RVJordan Jimmy W · Winnfield, LABuilt 1999 · S/N 60136N116SB114b Holding Inc Trustee · Wilmington, DEBuilt 2000 · S/N 14678N116SDA L Aviation LLC · Boiling Springs, SCS/N 359-73
Back to AD 81-18-04 R2