OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N24640Olive Aviation LLC · Anchorage, AKBuilt 1973 · S/N M-1461N24645Kangas Matthew W · Covington, WABuilt 1973 · S/N MB-564N24646Kosko Stanley G · Seattle, WABuilt 1973 · S/N MB-561N2464DAero Equities LLC · Ventura, CABuilt 2005 · S/N 172S10046N2464HSo Cal Leasing LLC · El Cajon, CABuilt 2005 · S/N 172S10049N2464MRosenquist Eugene C · Kasilof, AKBuilt 1947 · S/N 12-1548N2464PAdams Gregory L · Lake Stevens, WABuilt 1955 · S/N 22-2839N2464QWilson Jeff · White Bluff, TNBuilt 1977 · S/N 28R-7737035N2464SShellabarger Edwin L · Anchorage, AKBuilt 1979 · S/N 18-7909150N2464WOktela Steven L · Melbourne, FLS/N 3213093N24652Graber Howard J · Montgomery, INBuilt 1973 · S/N M-1430N24653Phillips Alan K · Junction City, ORBuilt 1973 · S/N MB-570N2465AWhite Andrew R · Dubois, WYS/N 22-797N2465ELeal Felipe · Missouri City, TXBuilt 1978 · S/N 17271292N2465RDarrow Brett · Minerva, NYS/N 28-5629N2465UProtzair LLC · Aiken, SCBuilt 2005 · S/N 17281272N24660Arey Dale W · Laramie, WYBuilt 1973 · S/N MB-565N24662Dumay Chad · O Fallon, MOBuilt 1973 · S/N MC-139N24663Stuber Paul A · Kansas City, MOS/N M-1425N24665Axiom Development & Consulting LLC · Atlanta, GAS/N MC-147N2466BFoecking James · Valley City, OHS/N 38-79A0073N2466EMarkham Dean F Jr · Greenville, NCBuilt 1978 · S/N 17271293N2466HRaven Girl LLC · Eagle River, AKS/N 18-7909187N2466MDonalds Flying Service Inc · Pantego, NCBuilt 1947 · S/N 12-1687N2466PGriffin Scott M · Springfield, OHBuilt 1955 · S/N 22-2841N2466TSvetfur Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10062N2466VD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 2005 · S/N 172S10063N2466XSpengler Raymond F Jr · Longview, TXBuilt 2005 · S/N 172S10064N24671Mustang Sally Aviation LLC · Signal Hill, CABuilt 2000 · S/N 17280925N24672Gurgainous Larry K · Fredericksburg, VABuilt 1973 · S/N MC-154N24673R66 And Cattle LLC · Southlake, TXBuilt 2006 · S/N 18281745N24676Goren Matthew B · Wilmette, ILBuilt 1972 · S/N M-1414N24679No Limits Aviation Inc · Hayden, IDBuilt 1973 · S/N MB-576N2467CKsg Capital LLC · Casper, WYBuilt 2000 · S/N 18280789N2467MToelle Neill · Fairbanks, AKBuilt 1947 · S/N 12-1693N24686Larsen Rick D · Fond Du Lac, WIBuilt 1939 · S/N 3352N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294N2468FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2000 · S/N 18280780N2468HStallings Cameron G · Clovis, NMBuilt 1979 · S/N 18-7909191N2468JJh Investments LLC · Henderson, NVBuilt 1996 · S/N 24-3391N2468MSmith Steven Paul · Dammeron Valley, UTBuilt 2024 · S/N 8389N2468NSouth Texas Air Force LLC · Mission, TXBuilt 1979 · S/N 38-79A0858N2468TMackie Robbie L · Murfreesboro, TNBuilt 1971 · S/N 28-7225074N2468WGodwin Gerald · Orange, TXS/N 886-2001N2468ZPetersen Danny R · Exeter, NEBuilt 2018 · S/N 101N24693Anderson Mark D · Eureka Springs, ARBuilt 1973 · S/N M-1443N24696Lucas Charles W · Ladson, SCBuilt 1973 · S/N M-1422N24697Ritton Air Company LLC · Pittsburgh, PABuilt 2005 · S/N 172S10068N2469ABossola Raymond L · Suffolk, VAS/N 22-806N2469KPilot Ready LLC · Lime Springs, IABuilt 1979 · S/N 38-79A0654
Back to AD 81-18-04 R2