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.

N8958DPoulton Daniel D · Belton, SCBuilt 1958 · S/N 226121N8958JDavis William M · New Lenox, ILBuilt 1966 · S/N 28-2979N8958LBarron John C · Tulsa, OKBuilt 1974 · S/N AA1B-0408N8958PVan Dyke David M · Portland, ORBuilt 1966 · S/N 24-4415N8958VHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264314N89594Executive Aviation LLC · Peoria, AZBuilt 1983 · S/N 17276009N8959CHanson Dan H · Lusk, WYBuilt 1954 · S/N 18-3260N8959JRegistration Pending · Fairmont, WVRegistration pendingS/N 28-2980N895AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2026 · S/N 172S13540N895AGProffetty Stephen D · Bridgewater, MABuilt 2010 · S/N 25235N895DSGuida Associates Consulting Inc · Sandpoint, IDS/N 20530N895NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 4496503N895TCHeisecke Raul Torres · Tyler, TXS/N 3246004N895VSpurlock Ricky DBA · Jensen, UTBuilt 1958 · S/N 18-6736N89600Philbrick Rodney C DBA · Bishop, CABuilt 1978 · S/N 15282801N8960CChristensen Todd S · Wasilla, AKBuilt 1954 · S/N 18-3261N8960JRegistered aircraftFirst renewal noticeBuilt 1965 · S/N 28-2982N8961CHuguenard Jefferson · Alpharetta, GABuilt 1976 · S/N 28-7615135N8961LStanton Kathleen Z · Burneyville, OKS/N AA1B0661N8961VHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17264317N8961ZHein-Reece Linda K · Shelton, WABuilt 1973 · S/N 17262110N8962FEmbry Aero Ltd · Greenville, ILBuilt 1973 · S/N 430196N8962JStory Allen D · Arlington, TXBuilt 1965 · S/N 28-2984N8962MAshcraft Todd W · Elgin, ILBuilt 2010 · S/N 001N8962YChoate Cass Joseph · Toone, TNS/N 39-122N8963DDoyle Patrick H · Keller, TXBuilt 1958 · S/N 22-6127N8963YNess Rent A Car Inc · Fargo, NDS/N 39-123N896482fly-Safety LLC Trustee · Azle, TXBuilt 1977 · S/N 15282816N8964DThomas Daniel C · Shady Shores, TXBuilt 1958 · S/N 22-6128N8964JKemper Kevin K · Granite Bay, CABuilt 1992 · S/N 028N8964VOneill Jared · Gilroy, CABuilt 1974 · S/N 17264320N8964W3720 To 1 Inc · Greenwood Village, COBuilt 1964 · S/N 28-10540N89652Lexington Flying Club Inc · Lexington, KYBuilt 1978 · S/N 15282819N89653Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282820N8965CMisner Darrell R · Kasilof, AKBuilt 1953 · S/N 18-2945N8965DSale Reported · Beech Creek, PASale reportedBuilt 1958 · S/N 22-6129N8965JN8965j LLC · Anchorage, AKBuilt 1966 · S/N 28-2987N8965LWeber Daniel M · Oconomowoc, WIBuilt 1974 · S/N AA1B-0415N8965WWarlick Bradley Q · Negaunee, MIBuilt 1964 · S/N 28-10541N8965YLucid Thought Consulting LLC · Terre Haute, INS/N 39-127N89661Kelly William W · Springfield, ORBuilt 1978 · S/N 15282821N89664Mulligan James Michael Trustee · Mesa, AZBuilt 1978 · S/N 15282822N8966DDodd Robert L · Humboldt, IABuilt 1958 · S/N 22-6130N8966JBrown Bradford K · Leoti, KSBuilt 1965 · S/N 28-2988N8966LMoffatt Thomas O · Kennesaw, GABuilt 1974 · S/N AA1B-0416N8966VCreider Paul E · Tulsa, OKBuilt 1974 · S/N 17264322N8967JJust Plane Fun LLC · Sunrise, FLBuilt 1965 · S/N 28-2990N8967LGoertz Anton O · Santa Fe, NMS/N AA1B-0417N8967TKellys Flying Service LLC · Warrensburg, MOBuilt 1981 · S/N 28-8190209N8967YQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-130
Back to AD 81-18-04 R2