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.

N70000Carson Mark L Trustee · Northfield, MNBuilt 1976 · S/N 17267178N70004Gbl Aviation LLC · Laurel, MSBuilt 1976 · S/N 17267179N7000RJilek Peter Andrew · River Falls, WIBuilt 1966 · S/N 28-21693N7000WIndy Air Sales LLC · Anderson, INBuilt 1962 · S/N 28-671N7000XWalsh Peter F · Walpole, MABuilt 1971 · S/N 28R-7135172N7000YSlowpoke Air LLC · Palm Harbor, FLBuilt 1966 · S/N 30-1188N7001DOwens Eldon J · Arimo, IDS/N 22-4894N7001KJersey Devil Dusters LLC · Southampton, NJBuilt 1950 · S/N 20-108N7001PPavlusik Tibor · Fort Mill, SCS/N 24-2146N7001WBrinc LLC · Lancaster, PABuilt 1963 · S/N 28-673N7002KHeinze Gregory L · Little Rock, ARBuilt 1950 · S/N 20-107N7002PMonterey Bay Aviation Inc · Watsonville, CABuilt 1960 · S/N 24-2147N7002ZKistler Michael J · Wasilla, AKS/N 18-8180N70032Alpha Wings Inc · Willoughby, OHBuilt 1976 · S/N 17267180N7003BByrd Kyle E · Unionville, MOBuilt 1956 · S/N 22-4253N7003PAviation Career Enrichment Inc · Atlanta, GABuilt 1960 · S/N 24-2148N70046Zane Newton F · Rllng Hls Est, CAS/N 17267183N7004FSouthern Vector Aerospace LLC · Huntsville, ALS/N 28-7790176N7004GMcgreen John R · Albany, NYBuilt 1969 · S/N 17258704N7004REasley Leroy · Novelty, MOFirst renewal noticeBuilt 1966 · S/N 28-21698N7004WLettsome Nesco · Beltsville, MDBuilt 1962 · S/N 28-676N7005Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020180N70052Hastings Heidi · Wasilla, AKBuilt 1976 · S/N 17267185N7005GHamilton Peter D · Bear, DEBuilt 1969 · S/N 17258705N7005QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260305N7006QToney Edward L · Hampton, GABuilt 1971 · S/N 17260306N7007Command Aero LLC · Newark, DEBuilt 1995 · S/N 20002N70075Kennel Isaac John · Salt Lake City, UTBuilt 1976 · S/N 28-7790177N7007JKeltner Kody M · Meadville, PAS/N 28-3162N7007KJackson Gary Lynn · Simms, TXBuilt 1950 · S/N 20-112N7007PAden Charles L · Hudson, COBuilt 1960 · S/N 24-2151N7007TAnderson Karen Lynn · Wasilla, AKBuilt 1960 · S/N 18-7322N7007WBiros Timothy D · Nya, MNBuilt 1962 · S/N 28-682N7007XConcho Aviation LLC · Sterling City, TXBuilt 1998 · S/N 2785N7008AMitchell Shawn J · Red Bluff, CAS/N 29108N7008BMayes Russell F · Farmersville, ILBuilt 1956 · S/N 22-4258N7008NRobinson Helicopter Company Inc · Torrance, CABuilt 1998 · S/N 0464N7008RPerchall Theodore G II · Fort Myers, FLBuilt 1966 · S/N 28-21701N7008YHeather Jordan Flying Services LLC · Port Saint Lucie, FLBuilt 1963 · S/N 30-9N70095Eastern Kentucky University · Richmond, KYBuilt 1976 · S/N 17267192N7009DRegistration Pending · Waupaca, WIRegistration pending, pending cancellationBuilt 1957 · S/N 22-4902N7009KRay Tyler D · Wasilla, AKBuilt 1950 · S/N 20-115N7009QJoiner Legacy Enterprises LLC · Joliet, MTS/N 17260309N7009RJackson Donald W · Carthage, MSS/N 28-21702N7009WFarrell Thurston Construction LLC · Las Cruces, NMBuilt 1999 · S/N 60126N700AC4sons LLC · Mayfield, KYBuilt 1980 · S/N 61P08018063412N700AGMash Kity J LLC · Grand Rapids, MIBuilt 1981 · S/N 172RG0670N700ASGunderson David A · Box Elder, SDBuilt 2005 · S/N 001N700AWTailwheel LLC · Logan, UTS/N 4032-CN700BVN700bv LLC · Zeeland, MIBuilt 1977 · S/N 61P-0448-171
Back to AD 81-18-04 R2