OpenAirDocs.org
AD 81-11-02 R1

Registered aircraft · 1,753

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-11-02-R1')
    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-11-02-R1')
  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.

N6083HAerotyne Aviation LLC · Omaha, NEBuilt 1977 · S/N 28R-7837052N60SULuther Frank E · Amanda, OHBuilt 2005 · S/N 2844121N61011Inter American University Of Puerto Rico · Bayamon, PRBuilt 2008 · S/N 2844139N6116JGlobal Technical Services Inc · Fort Worth, TXBuilt 1976 · S/N 28R-7635299N611CMMasters Charles O · Garden Ridge, TXBuilt 1978 · S/N 28R-7837210N61260Syracuse Flight School Inc · Syracuse, NYBuilt 1978 · S/N 28R-7837255N6136JTennessee Flight Academy LLC · Bristol, TNBuilt 1976 · S/N 28R-7635301N6153JLange Scott A · Rapid City, SDBuilt 1976 · S/N 28R-7635303N6159HJeva Ventures LLC · Charleston, SCBuilt 1977 · S/N 28R-7837055N6164JSchumar James F · Grand Rapids, MIBuilt 1976 · S/N 28R-7635315N6170JSeeler John A · Bristol, NHBuilt 1976 · S/N 28R-7635316N6197JN6197j LLC · Dallas, TXBuilt 1976 · S/N 28R-7635319N61BLLong Darrin · Rincon, GABuilt 1979 · S/N 28R-7918182N6208JCranbrook Aviation LLC · Vienna, VABuilt 1976 · S/N 28R-7635321N6222HMortenson Lyle · Kennebec, SDBuilt 1977 · S/N 28R-7837058N6222SClear Sky Aviation LLC · Lewis Center, OHBuilt 1973 · S/N 28R-7335197N6236CAviation Equipment Company LLC · Leesburg, VABuilt 1978 · S/N 28R-7837151N6238JDanish Air LLC · Wahpeton, NDBuilt 1976 · S/N 28R-7635324N6239JBlack Diamond Aviation LLC · Cullman, ALBuilt 1976 · S/N 28R-7635325N623WJAir Mods And Repair · Robbinsville, NJBuilt 1974 · S/N 28R-7435109N6256CKing David M · Plainville, CTBuilt 1978 · S/N 28R-7837154N625RSIndiana State University · Terre Haute, INBuilt 1979 · S/N 28R-7918253N627FGGulla Frank W Jr · The Villages, FLBuilt 1981 · S/N 28R-8118062N6289JS K Bound LLC · Missoula, MTBuilt 1976 · S/N 28R-7635332N6290JMclaen Family LLC · Queen Creek, AZBuilt 1976 · S/N 28R-7635333N6298JPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N 28R-7635334N6304CHarben LLC · Albemarle, NCBuilt 1978 · S/N 28R-7837155N6320CHeme Flying LLC · Lewisville, NCBuilt 1978 · S/N 28R-7837157N6345CKrajewski Jerry J · Elgin, ILBuilt 1978 · S/N 28R-7837158N6347CXclusive Level Aircraft World LLC · Kissimmee, FLBuilt 1978 · S/N 28R-7837160N6366CHalpin Aviation Inc · Eden Prairie, MNS/N 28R-7837161N6367CWings High Aviation LLC · Fayetteville, NCBuilt 1978 · S/N 28R-7837162N63RLVolland Aimee C · Tavernier, FLBuilt 1976 · S/N 28R-7635368N643PAYablonsky Richard R · Plymouth, MNBuilt 1979 · S/N 28R-7918218N64STStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1973 · S/N 28R7335185N6507JBarnes Brandon M · Metamora, ILS/N 28R-7635331N659DEEisenhauer Dwight · Lehighton, PAS/N 28R-35232N65CNJohnston Charles Wc Jr · Newfield, NJS/N 28R-35111N66CSWolf Steven T · De Graff, OHBuilt 1973 · S/N 28R7335107N66JJWilliams Nicholas Indrais · Pickerington, OHBuilt 1972 · S/N 28R-7235157N670XBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 2844055N671CMElite Air Solutions LLC · Decatur, GABuilt 1974 · S/N 28R-7435250N673CTCentral Texas College · Killeen, TXBuilt 2017 · S/N 2844169N674CTCentral Texas College · Killeen, TXBuilt 2017 · S/N 2844170N674DTMiller Jeffrey Dale · Brookhaven, GABuilt 1969 · S/N 28R-35074N6808JHot Seat Aviation · Blacksburg, VAS/N 28R-7635335N6828JKdrd Holdings LLC · Texas City, TXBuilt 1976 · S/N 28R-7635337N6849JSecker David A · San Jose, CAFirst renewal noticeBuilt 1976 · S/N 28R-7635340N6857JSkyward3 LLC · Kalispell, MTS/N 28R7635341N6862JTraut Joseph W · Sharon, MABuilt 1976 · S/N 28R-7635353
Back to AD 81-11-02 R1