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.

N9504FRons Air Service Inc · Two Buttes, COBuilt 1968 · S/N 870334N9504HPatterson Clifford Wayne · Murphy, TXBuilt 1975 · S/N 17266184N9504LTaylor William C · Portsmouth, NHBuilt 1998 · S/N 18280210N9504MNawratil Nicholas · Richmond, TXBuilt 1966 · S/N 670081N9504TWilloughby Dan J · Linden, MIBuilt 1978 · S/N 38-78A0119N9504WS&J Aviation LLC · Burlington, WABuilt 1967 · S/N 28-22926N95053Jamesweathers Robi J · Blaine, MNBuilt 1969 · S/N 28-25788N9505DJutzi Curtis E · Ridgefield, WABuilt 1958 · S/N 22-6420N9505HFinal Approach Aviation LLC · Danville, CABuilt 1975 · S/N 17266185N9505JConnors Paul J II · Murrieta, CABuilt 1966 · S/N 28-3626N9505LClark Gabrial Scott · Humble, TXBuilt 1972 · S/N AA5-0105N9505MLeahy Michael P · Downers Grove, ILBuilt 1966 · S/N 670082N95063Dugan Jason · Wellington, TXBuilt 1969 · S/N 28-25794N95069Tower Aviation Of Reading Inc · Reading, PABuilt 1969 · S/N 28-25797N9506JEspinal Branhder · Union, NJBuilt 1966 · S/N 28-3627N9506WAttitude Aviation Inc · Livermore, CABuilt 1997 · S/N 18280110N95071Lund Jonathan J · Glencoe, MNBuilt 1969 · S/N 28-25798N9507DKimball Raymond E · North Bend, ORBuilt 1958 · S/N 22-6422N9507LBatra Sanjeev · Roseville, CABuilt 1986 · S/N 17276566N9507MSanford Russell G · Brooks, GABuilt 1966 · S/N 670084N95080Johnson Patrick W · Toney, ALBuilt 1969 · S/N 28-25800N95084Lyons Nathaniel R · Fort Scott, KSBuilt 1969 · S/N 28-25801N95089Moll Michael J II · Mechanicville, NYBuilt 1969 · S/N 28-25804N9508BRegistered aircraftBuilt 1981 · S/N 172RG0842N9508DLewis Stephen A III · Fleming, GABuilt 1958 · S/N 22-6423N9508JGandas Aero Inc · Eagan, MNS/N 28-3629N9509DMorrison Jim · Grandview, TXBuilt 1958 · S/N 22-6424N9509JStevens Sheldon D · Clark, SDBuilt 1966 · S/N 28-3630N9509LDexter Fred H · Live Oak, FLBuilt 1972 · S/N AA1B-0031N950ACRed Carpet Aviation LLC · Carlsbad, CABuilt 1983 · S/N 17276058N950CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282185N950DRRjc Skyhawk LLC · Middletown, DES/N 17268169N950DSSchmitt Douglas F · Bloomsbury, NJBuilt 1978 · S/N 28R-7837167N950DTDanison George D · Decatur, ALBuilt 1969 · S/N AA1-0180N950HPKansas Highway Patrol · Topeka, KSBuilt 1998 · S/N 20608002N950JCCorbett John P · Austell, GABuilt 2023 · S/N 1298N950MEN950me LLC · Manassas, VABuilt 1976 · S/N 17266539N950MMAngelo Gary P · Jonesboro, ARBuilt 2024 · S/N 016-0950N950MTMiddle Tennessee State University Aerospace · Murfreesboro, TNBuilt 2023 · S/N 40.1241N950TBWeiss Elliott · Fresno, TXBuilt 1980 · S/N 020N950TECrutchfield Randolph E · Scottsdale, AZBuilt 2003 · S/N 10229N950TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881950N95103Shelton Aviation Inc · Christiansburg, VABuilt 1984 · S/N 15285849N95105Airbud Aviation LLC · Morristown, NJBuilt 1969 · S/N 28-25806N9510HRegistered aircraftBuilt 1975 · S/N 17266188N9510LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276568N9510PMadsen Travis E · New Underwood, SDBuilt 1972 · S/N 24-5028N95111Tiny Tin Aviation LLC · Groveland, FLBuilt 1969 · S/N 28-25808N9511DEglin Aero Club · Eglin Afb, FLS/N 17280359N9511GBurdette Ernest L · Pass Christian, MSBuilt 1998 · S/N 18280121
Back to AD 81-18-04 R2