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.

N5768LWilliams Charles J · Murfreesboro, TNBuilt 1969 · S/N AA1-0168N5768PBrooks David Paul · Mantorville, MNBuilt 1959 · S/N 24-846N5768UParsons Clinton K DBA · Etna, MEBuilt 1969 · S/N 28-26591N5768VSkyzure LLC · Chelsea, MIBuilt 1966 · S/N MA-21N57690Stockton Robert E · North Pole, AKBuilt 1974 · S/N 3-74N57691Heitz Joel L · Cozad, NEBuilt 1973 · S/N 418-74N57694Bishop David DBA · Butlerville, INBuilt 1973 · S/N 1000-74N57698Falkner Jeffrey A · Glennallen, AKBuilt 1977 · S/N 18-7709126N5769UKim Sungtae · Fort Worth, TXBuilt 1969 · S/N 28-26593N5769ZFox John F Jr · Mc Cormick, SCS/N 22-9611N576CACivil Air Patrol · Montgomery, ALBuilt 2008 · S/N 18282122N576DSLcb Leasing · Bristow, VABuilt 2010 · S/N 18282229N576FLRocky Top Corp · Erin, TNBuilt 1971 · S/N 28-7125425N576KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843937N576NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10962N576PAClear Skies LLC · Whitehall, PABuilt 1975 · S/N 28-7525331N576RDEmerian Rick S Trustee · Fresno, CABuilt 2009 · S/N 40249N576SPSo Cal Leasing LLC · El Cajon, CABuilt 2000 · S/N 172S8501N5770HBellino Dominic P · Florence, COBuilt 1949 · S/N 16-386N5770QJohnson Darryl · Fowler, COBuilt 1965 · S/N 3087N5770VAkins Terral S · Grain Valley, MOBuilt 1966 · S/N MA-25N5770WGallo Danny P · Nashotah, WIBuilt 1964 · S/N 28-1578N5771DEllison Stephen · Anchorage, AKBuilt 1956 · S/N 18-5273N5771HHill Bruce T · Ramona, CABuilt 2014 · S/N 91894N5771PWhisky Zulu Inc · Klamath Falls, ORBuilt 1959 · S/N 24-849N5771QLuchterhand Charles · Salem, ORS/N 744N5771VLow & Slow Aviation LLC · Westminster, COBuilt 1966 · S/N MA-22N5771WCrumpton Bradley N · Caddo Mills, TXBuilt 1964 · S/N 28-1579N5771ZDavenport Brad E · Eagle River, AKBuilt 1963 · S/N 22-9613N5772DLong Randy B · Coleman, TXBuilt 1956 · S/N 18-5274N5772PKasakoff Lloyd Abraham · Houston, TXBuilt 1959 · S/N 24-850N5772QTweten Gary L · Glasgow, MTS/N 3088N5772UBernstein Matthew D · North Charleston, SCBuilt 1970 · S/N 28-26596N5772VSouthwest Truck Parts Inc · Pratt, KSS/N MA-24N5772WBallard Gary H · Soddy Daisy, TNBuilt 1964 · S/N 28-1580N5773EOppegard Nicholas · Eagle River, AKS/N 17273N5773HSchneider Beth A · Midway, UTBuilt 1949 · S/N 16-384N5773MHulslander Taylor · North Pole, AKBuilt 1975 · S/N 18-7509082N5773QGunnerson Spencer · Murfreesboro, TNBuilt 1965 · S/N 745N5773UNelson Francis A · Winchester, VABuilt 1970 · S/N 28-26597N5774HPerron Ted J · White Bear Lake, MNFirst renewal noticeBuilt 1949 · S/N 16-385N5774LHickman Robert D · Mobile, ALS/N AA1-0174N5774ZLiming Danny O · Andrews, TXS/N 22-9610N5775EGates Rebecca S · GeorgetownNon-citizen corporation, flight hours not reportedS/N 17275N5775PChelf James Michael · Cedar Park, TXBuilt 1959 · S/N 24-853N5775QSinger David · Vandalia, OHBuilt 1965 · S/N 746N5775UBravo Tango Aviation · Spearfish, SDBuilt 1970 · S/N 28-26599N5776HMastre Joshua M · Soldotna, AKBuilt 1949 · S/N 16-389N5776LCollins Timothy · Northfield, MNBuilt 1969 · S/N AA1-0176N5776UBrainard Gary Keith · Olney, ILBuilt 1969 · S/N 28-26600
Back to AD 81-18-04 R2