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.

N9887CLeonard Paul A Jr · Grand Beach, MIBuilt 1978 · S/N R18200484N9887DRegistered aircraftBuilt 1959 · S/N 18-6911N9887LSkywarrior Flight Training Inc · Pensacola, FLBuilt 1986 · S/N 17276645N9887QTupelo Aeronautics Inc · Tupelo, MSS/N 17265831N9887VDarby Holly M · Midland, TXBuilt 1974 · S/N 17264549N98887Jodkin Jason · Confluence, PABuilt 1985 · S/N 17276373N9888GRegistration Pending · Atlanta, TXRegistration pending, pending cancellationBuilt 1971 · S/N 17259788N9888UTreasure Valley Flying Club LLC · Melba, IDBuilt 1978 · S/N AA1C0150N9888WSchlafer Antone · Lincoln, CABuilt 1967 · S/N 28-23408N98893Pape Jason C · Sykesville, MDBuilt 1985 · S/N 17276374N98896Two Tails LLC · Las Vegas, NVBuilt 1998 · S/N 18280350N9889DBorth Johnny D · Meade, KSBuilt 1959 · S/N 18-6914N9889GWright Flight Inc · Tucson, AZBuilt 1971 · S/N 17259789N9889LBowers Thomas · Grand Terrace, CABuilt 1975 · S/N AA1B-0489N9889QTack-Morse Patricia M · Sweet Home, ORBuilt 1975 · S/N 17265833N9889WFaix James M · Sarasota, FLBuilt 1967 · S/N 28-23409N988AMM & G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 2881579N988BBForbes Donald L · Central Point, ORS/N BB1N988BEN988be LLC · Manassas, VABuilt 2005 · S/N 172S10006N988BGMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265795N988BSJonsson Erik R · Twin Falls, IDS/N 600RN988BZRauh William · New Hope, PABuilt 2011 · S/N 18282305N988CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280254N988DDSchumacher Christopher R · Destin, FLBuilt 1989 · S/N 4075CN988GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881493N988JBBard John A · Mount Vernon, WABuilt 2004 · S/N 001N988JFMcdaniel Patrick D · State College, PABuilt 1999 · S/N 2843287N988MLLong Mark Allen · Stanton, MIBuilt 2026 · S/N 74961N988MSLong Mark A · Stanton, MIBuilt 1988 · S/N 11058CN988NPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 1606N988NADion William J · Coupeville, WABuilt 2006 · S/N 2088N988NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 4496592N988RAFifteen-Sixty LLC · Ottawa Hills, OHBuilt 1997 · S/N 18280022N988RLRegistration Pending · Hot Springs, ARRegistration pendingS/N RL1227-10-0009N988TCSpaulding Bernard B · Terrell, TXBuilt 1998 · S/N 18280297N988TSFerrand Kathy · Cornelia, GABuilt 2001 · S/N 90251N988UPKame Steven H · Roseburg, ORBuilt 2017 · S/N 466N988WUBravo Whiskey Aviation LLC · Louisville, KYBuilt 1998 · S/N 17280567N98900Bruton Jerry C Trustee · Wasilla, AKS/N 12-246N98901Haley Lawrence E II · Naples, FLS/N 12-247N98906Ison Larry D · Anchorage, AKBuilt 1946 · S/N 12-251N9890KWilliams Robert · Dawsonville, GABuilt 1977 · S/N 28R-7837046N9890WKoryciak Robert L · Boling, TXBuilt 1967 · S/N 28-23410N98910Wikle Artic C · Wasilla, AKBuilt 1946 · S/N 12-255N98912Allen John B · Sutter Creek, CABuilt 1946 · S/N 12-258N98913Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276378N98917Lee Mark D · Palmer, AKBuilt 1946 · S/N 12-268N98919Gehring Robert A · Rubicon, WIBuilt 1946 · S/N 12-270N9891GOuellette Kevin E · Frederick, OKBuilt 1971 · S/N 17259791N98922Mitchell Mark J · Wrangell, AKFirst renewal noticeBuilt 1946 · S/N 12-275
Back to AD 81-18-04 R2