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.

N7107UJohnson Kenneth D · Camdenton, MOBuilt 1964 · S/N 2765N7107WCaufield Dennis R · Carl Junction, MOBuilt 1962 · S/N 28-895N7108DWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1957 · S/N 22-4966N7108GLakes Area Aviation LLC · Little Falls, MNS/N 17258808N7108LWeiland Scott J · Howe, INBuilt 1973 · S/N AA5-0408N7108QAnderson Michael · Hillsboro, NDBuilt 1972 · S/N 17260408N7108RChristian Mark A · South Point, OHBuilt 1966 · S/N 28-21805N7108WRed Rock Flying School LLC · Mesa, AZS/N 28-896N7109BEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4326N7109KSheffield Vana Riggs Executrix · Amarillo, TXS/N 18-328N7109LSimpson Brian · Indian Trail, NCS/N AA5-0409N7109QLawless Bruce A · Lago Vista, TXBuilt 1972 · S/N 17260409N7109SCitation Companeros LLC · Seguin, TXBuilt 1999 · S/N 2952N7109UOyler Joseph B · Kokomo, INBuilt 1964 · S/N 2739N7109WV1 Air Inc · Hibbing, MNS/N 28-897N710APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843766N710AFFranke Stuart A · Hondo, TXBuilt 2023 · S/N 41996N710AWBrown Dustin · Rossburg, OHBuilt 1966 · S/N 32-473N710BWise Matthew A · Chambersburg, PABuilt 1990 · S/N 20017N710BJBluebird LLC · Vestavia, ALBuilt 2003 · S/N 60062N710BTMunoz Tanen J · Lockeford, CABuilt 1970 · S/N 32-1295N710CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881730N710CBPruitt Ron A · Stoneville, NCBuilt 1980 · S/N 1N710CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281710N710CTGibson William V · Aberdeen, MSBuilt 2000 · S/N 80451N710DYAirshare LLC · Anchorage, AKBuilt 2004 · S/N 10383N710EHRatcuffe Howard Clark · Huntsville, UTBuilt 2000 · S/N 23446N710FGKimbrell Jeffrey L · Greenville, SCBuilt 1970 · S/N 177RG0016N710GMaj Enterprises LLC · Missoula, MTBuilt 2013 · S/N 460N710GZB & B Readi-Mix LLC · Ruidoso Downs, NMBuilt 2024 · S/N 18283248N710JFStearns Todd C · Cora, WYBuilt 2008 · S/N J-001N710LESoaring LLC · Auburn, CABuilt 2012 · S/N 40154N710LGCollette John D · Las Vegas, NVS/N 710N710LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 172S11420N710MEQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-101N710MYInterstate Helicopters Inc · Bethany, OKBuilt 2006 · S/N 11242N710PXAura LLC · Frederick, MDBuilt 2006 · S/N 81788N710RDPurll Samuel B · Mechanicsville, MDBuilt 1966 · S/N 28-21809N710RRMulcahy Michael T · Perris, CABuilt 2000 · S/N 20608106N710RVPuryear Sean T · Graham, TXBuilt 2006 · S/N 40044N710SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13577N710SPElite Approach LLC · Chesterfield, MOBuilt 1999 · S/N 172S8106N710TLBarker John Van · Smyrna, GABuilt 2007 · S/N 1398-2007N710UBoard Of Regents Of University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020229N710VEFour With Two LLC · San Francisco, CABuilt 2003 · S/N 70254N710WHColberg Arien G · Deer Island, FLBuilt 2006 · S/N 40071N7110BSeven-Eleven Brick Inc · Dalton, MNBuilt 1956 · S/N 22-4327N7110LNorris Bobby L · Ocala, FLBuilt 1976 · S/N AA1B-0610N7110PTobias Gregory L · Ottawa Lake, MIBuilt 1960 · S/N 24-2267N7110QLawson Virgil · Sylvar Grove, KSS/N 17260410
Back to AD 81-18-04 R2