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.

N7762NRegistered aircraftBuilt 1968 · S/N 28-5208N7762WHenson Russell K · Santa Fe, NMBuilt 1964 · S/N 28-1761N7763HBrown F Wilson · Bedford, VAS/N 12-660N7763MZimmerman Kurt L · Blacksburg, VABuilt 1974 · S/N 20-0016N7763NWever Marcus L · Lincolnton, NCBuilt 1969 · S/N 28-5209N7763PRegistered aircraftBuilt 1961 · S/N 24-2980N7763WSanchez Alyse Marie · San Antonio, TXBuilt 1964 · S/N 28-1762N7764DHorn Bruce D Trustee · Zephyr Cove, NVS/N 18-5944N7764GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259464N7764HVadakin Jeffrey M · Dover, DEBuilt 1946 · S/N 12-661N7764MEifert Steven W · Clarksville, TNBuilt 1974 · S/N 20-0017N7764PBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 24-2981N7764ZUnited Aerial Advertising Of Delaware Inc · Sparta, NJBuilt 1966 · S/N 25-3957N7765GJefferies Stanley J · Coos Bay, ORBuilt 1970 · S/N 17259465N7765HT R C Inc · Fairbanks, AKBuilt 1946 · S/N 12-663N7765MProgressive Medical Applications Corp · Allentown, PABuilt 1974 · S/N 20-0018N7765PRegistered aircraftBuilt 1961 · S/N 24-2982N7765WTri-City Aviation Inc · Hopewell, VABuilt 1964 · S/N 28-1765N7765YAce Vne LLC · Stevensville, MIBuilt 1965 · S/N 30-852N7766GAir Ally Asset Management LLC · Chisago City, MNS/N 17259466N7766NKenealy Ian Patrick · San Rafael, CABuilt 1969 · S/N 28-5212N7766WBair Dale Leroy · Canton, OHBuilt 1964 · S/N 28-1766N7767GPerformance Aviation LLC · Fort Myers, FLBuilt 1970 · S/N 17259467N7767PStock Keith A · Warrensburg, MOS/N 24-2983N7767WFinan Kevin P · Seattle, WAS/N 28-1767N7768MHoyle Charles D Jr · Eureka, CABuilt 1974 · S/N 22-0024N7768NLeap Frog Aviation LLC · Bentonville, ARBuilt 1968 · S/N 28-5215N7768PGreensburg Jeannette Airport Administration Inc · Jeannette, PAS/N 24-2984N7768VSky Sailing Inc · Warner Springs, CABuilt 1969 · S/N 1525N7768WKilo Niner Aviation LLC · Saint Petersburg, FLBuilt 1964 · S/N 28-1769N7769Sherburne Asher J · Redlands, CABuilt 1997 · S/N SN001LRN7769HCallahan Brian C · Marenisco, MIBuilt 1946 · S/N 12-669N7769MCorso Nicholas J · Stuart, FLBuilt 1974 · S/N 22-0025N7769NWoolsey Bradley W · Burleson, TXBuilt 1968 · S/N 28-5216N7769WSeverson Michael A · Nampa, IDBuilt 1964 · S/N 28-1770N7769ZCentral Air Parts Inc · Staunton, ILS/N 25-3963N776AASolo Aircraft Rental LLC · Farmingdale, NYBuilt 2005 · S/N 172S9928N776ACMonska Stephen M · Florence, MABuilt 1997 · S/N 1233-97N776AWKustatan Leasing LLC · Nikiski, AKBuilt 1964 · S/N 18-8139N776BCTyndall Darryl K DBA · Deep Run, NCBuilt 2000 · S/N 2079N776CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881764N776CHHassler William J · Houston, TXBuilt 1965 · S/N 30-753N776CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281776N776DGArmbruster Richard G · Chardon, OHBuilt 2018 · S/N 25101N776GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881472N776GAHinds Community College · Raymond, MSBuilt 1978 · S/N GA7-0065N776HCCyclic Aviation LLC · Millbrook, NYBuilt 2007 · S/N 2127N776JNSchemmel Grant P · Florence, COS/N 23785N776LHJones Aircraft Company LLC · Cross Plains, TNBuilt 2002 · S/N S1841N776MCCrew Sourcing Inc · Wilmington, DEBuilt 1957 · S/N 23-1078
Back to AD 81-18-04 R2