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.

N972FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13462N972GJPolk County Sheriffs Office · Winter Haven, FLBuilt 2006 · S/N 18281843N972GLWelch Gary A · Groveland, CABuilt 2016 · S/N 6-8947N972KCMustang Sally Aviation LLC · Camden, SCBuilt 2000 · S/N 17280972N972LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844172N972NCIal Corp · Lewes, DEBuilt 1971 · S/N 17259818N972PGLaw Office Of Thamir A R Kaddouri Jr P A · Albany, GABuilt 2019 · S/N 40343N972PMNp Aviation Inc · Naguabo, PRS/N 17264940N972RTMellott Stephen G · Berthoud, COBuilt 2003 · S/N 17N972SALindeman Inc · D'Hanis, TXS/N 0394N972TAConfluence Systems Consulting · San Jose, CABuilt 2002 · S/N 172S9171N972THUtah State University · Logan, UTBuilt 2023 · S/N 172S12972N972WWChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2002 · S/N 172S9072N9730DFlood Ashley · Gibbstown, NJBuilt 1959 · S/N 22-6642N9730LSundowner N9730l LLC · Calhoun, GABuilt 1971 · S/N M-1357N9730PDreger Dean R · Wilbur, WABuilt 1975 · S/N 18-7609007N9730QWheat Land Aviation LLC · Andover, KSBuilt 1971 · S/N MC-82N9730USherry-Aire LLC · Sidney, MTBuilt 1976 · S/N AA5A-0130N9730VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264494N97313Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276177N9731FN9731f LLC · Stuart, FLBuilt 1997 · S/N 17280035N9731HCreative Strategies Inc · Proctorville, OHS/N 17266339N9731LMaine Instrument Flight · Augusta, MEBuilt 1971 · S/N M-1358N9731MHausaman Jeffrey S · Las Vegas, NVBuilt 1967 · S/N 670291N9731UNatale Louis H · Cedar Park, TXBuilt 1976 · S/N AA5A-0131N9731WDacy David M · Harvard, ILBuilt 1967 · S/N 28-23210N9732DTouzeau Raymond V · Newberg, ORS/N 22-6644N9732HLand & Leave LLC · Helena, MTBuilt 1975 · S/N 17266340N9732JWalborn Gary D · Youngstown, OHBuilt 1967 · S/N 28-3925N9732VSiguaw Robert E · Deming, WABuilt 1974 · S/N 17264496N9732WFlying Elvis · Jacksonville, FLBuilt 1967 · S/N 28-23212N9733ACloud Dancer Aviation Inc · Deland, FLBuilt 1978 · S/N 15281329N9733DMcfalls Caleb Parker · York, SCBuilt 1959 · S/N 22-6645N9733LStock Craig A · Devon, PABuilt 1986 · S/N 17276604N9733MJc Mooney LLC · Tallahassee, FLBuilt 1967 · S/N 670293N9733VTyler Ronald J · Martville, NYBuilt 1974 · S/N 17264497N9733WWilson Lyndon K Sr · Ringgold, GAS/N 28-23214N9734BPreston Aviation LLC · Henderson, KYBuilt 1981 · S/N 172RG0999N9734JPiper Perfect LLC · Panama City, FLBuilt 1967 · S/N 28-3927N9734MHaddle Eddie · Lindon, UTS/N 670294N9734PHornyak Ryan J · Girard, PABuilt 1975 · S/N 18-7609008N9734USls Aviation LLC · Poquoson, VABuilt 1976 · S/N AA5A-0134N9734WNimbus Air LLC · Frankfort, ILS/N 28-23215N97358Rick Aviation Inc · Newport News, VABuilt 1984 · S/N 17276180N9735DSkinner Timothy G · Archer, FLS/N 22-6647N9735PSprenger Mark R · Eagle River, AKBuilt 1975 · S/N 18-7609009N9735UFreeman George W · Wolcottville, INBuilt 1976 · S/N AA5A-0135N9736DCamp Doug A · Starkville, MSBuilt 1959 · S/N 22-6648N9736QGregory Charlie E · Blairsville, GABuilt 1971 · S/N MC-88N9737DFolkvord Darrel L · Toston, MTS/N 22-6649
Back to AD 81-18-04 R2