OpenAirDocs.org
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.

N3652MSorensen Parker J · Homer, AKBuilt 1947 · S/N 12-2602N3652QNolen David S · Wimberley, TXBuilt 1967 · S/N MA-239N3652RShales Rene J · Hampshire, ILBuilt 1969 · S/N 28-5756N3652WValiair Limited Co Trustee · Casper, WYS/N 32-557N3653NBurch Herbert K · Milan, OHBuilt 1967 · S/N 680025N3653PWright Michael · Hurricane, UTS/N 22-3404N3653QFlying Naked Muskteers LLC · Palm City, FLBuilt 1967 · S/N MA-240N3653RSingh Harsimran · Las Vegas, NVBuilt 1970 · S/N 28-5758N3653ZMandibles Edward Jr · Lompoc, CABuilt 1960 · S/N 22-7550N36541Plains Aviation · Mitchell, SDBuilt 1978 · S/N 28-7890521N36546Lighthouse Drones LLC · New Smyrna Beach, FLBuilt 1978 · S/N 32R-7885193N3654KBeaber Michael J · Fremont, OHBuilt 1967 · S/N 28-23673N3654MLunoe Finn · Anchorage, AKBuilt 1947 · S/N 12-2526N3654RSierra Delta 1 LLC · Dover, DEBuilt 1969 · S/N 28-5759N3654ZSandland Christopher A · North Pole, AKBuilt 1959 · S/N 18-7184N36555Smith Jeffrey D · Murrells Inlet, SCBuilt 1978 · S/N 32R-7885194N3655NPeterson Jesse D · Wasilla, AKBuilt 1947 · S/N 12-1906N36563Ware Richard A · Versailles, OHBuilt 1978 · S/N 28-7890513N36567Kempton Larry G Jr · Grand Junction, COBuilt 1978 · S/N 28-7890522N3656AHughes James D · Stanhope, IABuilt 1954 · S/N 22-1916N3656PKennedy Lukas · Anchorage, AKS/N 22-3407N3656WNuvision Heaqlth Center · Macomb, MIBuilt 1966 · S/N 32-562N36574California In Nice Inc · San Jose, CABuilt 1978 · S/N 28R-7837284N36575Brill Charles F · Spring, TXBuilt 1978 · S/N 32R-7885195N3657NEstes Aviation LLC · Vicksburg, MSBuilt 1967 · S/N 680027N3657QFaith Builders Family Church Inc · Rogers, ARBuilt 1968 · S/N M-1136N3657ZBagdon Albert B · Elbert, COBuilt 1960 · S/N 22-7554N36583Pray Aviation Inc · Augusta, KSBuilt 1978 · S/N 28-7816647N36588Moseley Richard W · Lakewood Ranch, FLBuilt 1978 · S/N 32R-7885196N3658APrice James H · Abilene, KSBuilt 1953 · S/N 22-1918N3658MHowker John A · Louisville, KYBuilt 1947 · S/N 12-2608N3658NUnivair Aircraft Corp · Aurora, COBuilt 1947 · S/N 12-1911N3658WFlying 20 Club Inc · Springfield, ILBuilt 1966 · S/N 32-564N36590American Aircraft Sales LLC · Lincolnshire, ILBuilt 1978 · S/N 32R-7885197N36593Kentucky Stick And Rudder Academy LLC · Springfield, KYBuilt 1973 · S/N 112-73N36594Hayward Casey W · Anchorage, AKBuilt 1973 · S/N 578-73N3659AZientara Jim A · Zephyrhills, FLS/N 22-1919N3659KDumont Mark · Brush Prairie, WABuilt 1967 · S/N 28-23676N3659MTrent Daniel E · Las Vegas, NVBuilt 1978 · S/N 28-7890320N3659RInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-5762N3659XAiello Bailey H · Eugene, ORBuilt 1968 · S/N 311N365AKColville Inc · Anchorage, AKS/N 3065N365BSHarders Justin M · Cairo, NEBuilt 2024 · S/N 009N365CB.R.S. Leasing Inc · Wilmington, DEBuilt 2001 · S/N 2163N365CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282117N365CCSki Sawmill Family Resort Inc · Ulysses, PABuilt 2004 · S/N 9963CCN365DAJeffries Ian Mcgoff Douglas · Clover, SCBuilt 2013 · S/N 82704N365DBRutan Aircraft Flying Museum · Waller, TXBuilt 2012 · S/N 1697N365DLSoehner Harold D · Winslow, AZBuilt 2009 · S/N DAL001N365DRPace Ryan · Morgan, UTBuilt 2023 · S/N 002
Back to AD 81-18-04 R2