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.

N916GW9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12760N916HPNeustaeter Pedro Thiessen · Anthony, NMS/N 28-2658N916HT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12761N916JFHammett Gary N · Prince Frederick, MDBuilt 1974 · S/N 28-7405130N916JGGriffin Aerospace Solutions LLC · Bridgeport, WVBuilt 1996 · S/N 0041N916JTRugg Ranches LLC · Pilot Rock, ORBuilt 2021 · S/N CCK-2000-0064N916KSmith Brandon D · Laguna Beach, CABuilt 2005 · S/N 001N916KTPelican Flight Training LLC · San Carlos, CABuilt 2021 · S/N 172S12763N916LTTillman Tracy S · Webberville, MIBuilt 2002 · S/N 25088CN916MABusch Brett · Stanford, MTBuilt 1999 · S/N 172S8265N916MHHelmerich Jonathan D Jr · Tulsa, OKBuilt 1969 · S/N 17258177N916MRReyes Michael L · Kansas City, MOBuilt 2007 · S/N 70760N916MV3b Aircraft Inc Trustee · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 14359N916NT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12762N916PBM & G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12765N916PYBragg Kris M · Embden, MEBuilt 1968 · S/N 17257159N916QTElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12766N916RDUssery Donald R · Blytheville, ARS/N 23-1743N916RKGrant Aviation Inc · Anchorage, AKBuilt 2012 · S/N GA8-12-176N916RR9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12767N916SEEiland James · Phenix City, ALBuilt 1977 · S/N 17269640N916SLWiseman Susan · Sacramento, CABuilt 2012 · S/N 40015N916STHorizon Aviation LLC · Kalispell, MTBuilt 2019 · S/N CCK-1865-1056N916TBShearer Gregory L · Avon, INBuilt 1987 · S/N 1690N916TMMo Properties & Investments LLC · Lakewood, COBuilt 1994 · S/N 1809101N916TTReyes-Hernandez Jose R · San Juan, PRBuilt 1989 · S/N 2841146N916UT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12768N916WGGammell Bernard W · Nampa, IDBuilt 2022 · S/N 122-231/232-1281N916YEggimann William W Trustee · Anchorage, AKBuilt 1973 · S/N 18-7309023N9170DSmith Glen R · Tracy, MNBuilt 1958 · S/N 22-6224N9170SLee Benjamin W Trustee · Chandler, AZBuilt 1976 · S/N M-1783N9170VMitchell Kevin L · Glen Saint Mary, FLBuilt 1969 · S/N 690032N9170WWyatt Jeffrey Ron · Lubbock, TXBuilt 1966 · S/N 28-10825N9171CCartright Eugene · Pelham, NHBuilt 1978 · S/N R18200435N9171DJensen Timothy G · Junction City, ORBuilt 1958 · S/N 22-6226N9171HSonday Terrance · Spring, TXBuilt 1975 · S/N 17265990N9171JRichardson Adam D · Franklin, INBuilt 1966 · S/N 28-3232N9171LBrolan Aviation LLC · Kansas City, MOBuilt 1970 · S/N 258-71N9171VMau Allen D · Stockton, CABuilt 1969 · S/N 690044N9171YAirelibre Aviation Inc · Wilmington, DEBuilt 1987 · S/N 1N9172Eggett John D · Pacoima, CABuilt 1969 · S/N MG10214N9172SShuffield Brian D · Oregon House, CAS/N M-1793N9172YMohammadreza Sabzi · Los Angeles, CABuilt 1985 · S/N 28-8616034N9173CBettendorf Nicholas L · Mchenry, ILBuilt 1978 · S/N R18200436N9173HSmitty 172 LLC · Rockford, MIBuilt 1975 · S/N 17265992N9173XLinzel Jesse G Jr · Southern Pines, NCBuilt 1996 · S/N 11-176N9174HBarf Aviation LLC · Huntsville, ALBuilt 1946 · S/N 12-288N9174JOrleans Flying Club Inc · Orleans, INBuilt 1966 · S/N 28-3238N9174MParis Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8616035N9174TPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 18-8009013
Back to AD 81-18-04 R2