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.

N68211American Aviation Inc · Brooksville, FLS/N 15282188N68212Dynasty Adventure Inc · Mentone, CABuilt 1978 · S/N 15282189N6821PComanche Logistics LLC · Lake City, FLBuilt 1960 · S/N 24-1954N6821URed Baron LLC · Middletown, DES/N 2536N6821VMiller Titan G · Tehachapi, CAS/N 20-0003N68220Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282194N68225Brown Steven E · Paynesville, MNBuilt 1978 · S/N 15282198N68228Van Thomme Wayne A · Faribault, MNBuilt 1981 · S/N 15285320N6822KGoad Graham · Mcminnville, ORBuilt 1949 · S/N 16-653N6822LDavis Robert E · Wasilla, AKBuilt 1974 · S/N 18-7409105N6822NBianchi Marion A · Goose Creek, SCBuilt 1968 · S/N 680116N6822VDk Aero LLC · Greenville, SCBuilt 1971 · S/N 22-0007N6822WAjf Enterprises LLC · Des Moines, IAS/N 28-20960N68234Bryant William E · Fort Bragg, NCBuilt 1978 · S/N 15282203N68237Registration Pending · Tacoma, WARegistration pendingBuilt 1978 · S/N 15282204N6823HClay Howard C II · San Francisco, CAS/N 17265596N6823NTawil Anan · Salem, ORBuilt 1968 · S/N 680108N6823PKoopmans Caleb · Bridgewater, SDBuilt 1960 · S/N 24-1956N6823UClark Bradley K · Ypsilanti, MIBuilt 1963 · S/N 182N6823WThomas Kevin A · Selbyville, DEBuilt 1965 · S/N 28-20961N68242Wilson Timothy J · Arlington, AZBuilt 1978 · S/N 15282205N68246M2g Aviation LLC · China Grove, NCBuilt 1978 · S/N 15282208N6824JMorrison Justin Gregory · Houston, TXBuilt 1976 · S/N 28-7625243N6824PAtlas Equipment LLC · Casper, WYBuilt 1960 · S/N 24-1957N6824ULefevre Duane S · Grover, WYS/N 183N6824WRoberts John R Jr · Homestead, FLBuilt 1965 · S/N 28-20962N68257Bates Steven B · Phelan, CAS/N 15282213N6825BAlborn Wyatt A · Homer, AKBuilt 1956 · S/N 22-4121N6825JByrd Mark L · Belpre, OHBuilt 1976 · S/N 28-7615368N6825NWilliams Jerry Riley Sr · Wabbaseka, ARS/N 680118N6825URipley Holdings Ltd · Santa Monica, CABuilt 1963 · S/N 184N6825VRegistered aircraftBuilt 1971 · S/N 21-0008N68260Flycarolina LLC · Rock Hill, SCBuilt 1978 · S/N 15282214N682666s Aviation Corp · Orlando, FLBuilt 1978 · S/N 15282218N6826NInterwest Management · Angwin, CABuilt 1968 · S/N 680109N6826VMcwilliams Michael K · Villa Ridge, MOBuilt 1971 · S/N 22-0008N6826WMartinak Charles J · Rehrersburg, PABuilt 1965 · S/N 28-20966N6827ULeong Thomas M · El Monte, CABuilt 1963 · S/N 186N6827VAerostar Air LLC · Kilgore, TXBuilt 1971 · S/N 20-0005N6827WShort Final Aviation LLC · Branson, MOBuilt 1965 · S/N 28-20967N68280Frint Michael R · Elk Grove, CABuilt 1978 · S/N 15282226N68287Lockwood Albert G · Eden, IDS/N 5-1475N6828BVantreese Jason B · Quanah, TXS/N 22-4125N6828JKdrd Holdings LLC · Texas City, TXBuilt 1976 · S/N 28R-7635337N6828NFisher Scott · Searcy, ARBuilt 1968 · S/N 680120N6828VEvanson Mark A · Wharton, TXBuilt 1971 · S/N 21-0009N6828WOleary David L · Framingham, MABuilt 1965 · S/N 28-20968N6829NWilliams Mark J · Ojai, CAS/N 680110N6829VE N Entertainment Inc · El Dorado Hills, CABuilt 1971 · S/N 22-0012N682ABPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010082
Back to AD 81-18-04 R2