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.

N723LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13202N723MRaber Micah D · Wasilla, AKS/N 23003CN723MDTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13487N723MGInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 40.832N723MLVertical Corp · Kalispell, MTBuilt 1996 · S/N 2639N723PC43rd Aviation Flying Club Inc · Norfolk, CTFirst renewal noticeBuilt 1998 · S/N 2843194N723PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 17280675N723PMCeu LLC · Greer, SCBuilt 1967 · S/N 28-4329N723RGHatchett Creek Leasing Inc · Delta, ALBuilt 2005 · S/N 10658N723RVSmith Stuart T · Murrieta, CABuilt 1981 · S/N 727N723SSmaltz David I · Newmanstown, PAS/N M-1384N723SEFrost Cavin Bert · Odessa, TXBuilt 2022 · S/N 18283188N723THSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 15281348N724Morrison Richard L Trustee · Anchorage, AKBuilt 1999 · S/N 2009N72400Brown Michael · Greeneville, TNFirst renewal noticeBuilt 1999 · S/N 2031N72403Drury Edward D · Little Silver, NJS/N 33701576N7240FDewberry Dylan C · Springfield, ORBuilt 1968 · S/N 28-25153N7240GKendallville Flying Club Inc · Auburn, INBuilt 1970 · S/N 17258940N7240JFlytt LLC · Naples, FLBuilt 1968 · S/N 28-24577N7240YHodges David S · Reidsville, GABuilt 1964 · S/N 30-264N72418Bishop Raymond Max · Chandler, AZBuilt 1964 · S/N RB-3N7241CHeritage Timothy D · Glendale, AZBuilt 1975 · S/N 28-7625073N7241DFrisby James A · Palmer, AKBuilt 1957 · S/N 22-5262N7241JHopkins Justin C · Benson, AZFirst renewal noticeS/N 28-24578N7241WBurtchett Tyler D · Buckeye, AZBuilt 1963 · S/N 28-1075N72421N83882 Inc · Huntington, NYBuilt 1968 · S/N 17257407N72424Magill William J · Moncks Corner, SCS/N 241523N7242FDjair · Winchester, VAS/N 28-25155N7242GIrizarry Heriberto J · Homestead, FLBuilt 1970 · S/N 17258942N7242WSouthwest Fluid Products Inc · Weatherford, TXS/N 28-1065N7242ZHamilton Randel L · Quitaque, TXBuilt 1965 · S/N 25-3167N72432Kaono Jerry C · Carson, CABuilt 1973 · S/N 33701581N7243FBlack Diamond Real Estate · Roseville, CABuilt 1968 · S/N 28-25159N7243GKrumbine David A · Lebanon, PABuilt 1970 · S/N 17258943N7243JNova Flight LLC · Gainesville, VABuilt 1968 · S/N 28-24583N7243VRobarge Chad Steven · Duluth, MNBuilt 1947 · S/N 123238N7243WLejeune Ovey Eugene · Roanoke Rapids, NCBuilt 1963 · S/N 28-1066N72448Clay Jason I · Imperial Beach, CABuilt 1957 · S/N 185841N7244CMullinx Victor L · Holt, MOBuilt 2004 · S/N 10547N7244PPaden Stanley R · Diamond Bar, CABuilt 1961 · S/N 24-2418N7244QBuckley Gregory L · Melba, IDS/N 17260544N7244YJ Mac Aviation Services LLC · Andalusia, ALBuilt 1964 · S/N 30-269N72454Dawson Adam J · Eveleth, MNBuilt 1952 · S/N 18-1715N7245FLeinart Brannon B · Merit, TXBuilt 1968 · S/N 28-25161N7245JKallen David A · Northville, NYBuilt 1968 · S/N 28-24586N7245KKnuckles Dennis P Trustee · Custer, SDBuilt 1950 · S/N 18-140N7245PMontcalm Kevin L · Mansfield, LABuilt 1960 · S/N 24-2419N7246CValiair Limited Co Trustee · Casper, WYBuilt 1975 · S/N 28-7615048N7246GHale Warren P · Martinsburg, MOBuilt 1970 · S/N 17258946N7246JCooper Christopher B · Crowley, TXBuilt 1968 · S/N 28-24587
Back to AD 81-18-04 R2