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.

N86SUHeavenly Realms Aviation LLC · Grand Junction, COBuilt 2005 · S/N 2844122N871DMId Air LLC · Apopka, FLBuilt 1975 · S/N 28R-7535147N872WLKryzsko Joshua Don · Livingston, MTBuilt 1971 · S/N 28R-7135123N8732CDiluzio Brad M · Graham, WABuilt 1976 · S/N 28R-7635179N8733EHoward Allan C · New Preston, CTBuilt 1976 · S/N 28R-7635207N8734EKrukowski Edward A · Miami, FLBuilt 1976 · S/N 28R-7635208N8757ELa Copious LLC · Pinetop, AZFirst renewal noticeS/N 28R-7635211N8758EMiller Kevin · Dover, DEBuilt 1976 · S/N 28R-7635212N8766ELoose Larry A · Jamestown, NDBuilt 1976 · S/N 28R-7635213N877HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 2844132N8788CSaflight Pilot Training Inc · Manchester, NHS/N 28R-7635182N8790EFenty Brandon · Normandy, TNBuilt 1976 · S/N 28R-7635214N8798EFuller Glenn C · Santa Paula, CAS/N 28R-7635215N87KGCherokee From Sebring LLC · North Brunswick, NJBuilt 1969 · S/N 28R-35043N8819ETransition Aviation LLC · Hummelstown, PABuilt 1976 · S/N 28R-7635209N8824ECornelius John A · Fort Worth, TXBuilt 1976 · S/N 28R-7635216N8828CHogan Dennis E · South Hadley, MABuilt 1976 · S/N 28R-7635183N883ACPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 28R-7535156N8842SMcdowell Karen · Dunedin, FLS/N 2837032N8852CWobken Mark E · Orange, CABuilt 1976 · S/N 28R-7635184N889TWUniversal Aviators Academy Inc · El Monte, CABuilt 1989 · S/N 2837023N8949CMorgan Aviation LLC · Greensboro, NCBuilt 1976 · S/N 28R-7635186N897ALJansky Sand & Gravel Inc · Hallettsville, TXBuilt 1973 · S/N 28R-7335331N897ECMatacia Thomas Eugene · Evergreen, NCBuilt 1969 · S/N 28R-35376N89HHStrissel Christopher A · Hilton Head Island, SCBuilt 1971 · S/N 28R-7135225N89SPSky'S The Limit Flying Club Inc · Findlay, OHBuilt 1976 · S/N 28R-7635218N8FNValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N 28R-7837272N8HNSol Property Group LLC · Rosenberg, TXBuilt 1975 · S/N 28R-7535277N901BBVisual Group Inc · Tampa, FLBuilt 1974 · S/N 28R-7435256N906KEDaniel Tayja · Brooklyn, NYS/N 28R-35631N9091YCsa Investments LLC · Wayne, PABuilt 1969 · S/N 28R-35197N9099KWallace Jacob M · Central Point, ORBuilt 1977 · S/N 28R-7837028N90FEPasley Michael Cole · Niceville, FLBuilt 1969 · S/N 28R-35121N90MHMooers Michael T · Hagerstown, MDBuilt 1976 · S/N 28R-7635158N9102KM & T Aircraft LLC · North Canton, OHBuilt 1977 · S/N 28R-7837029N910GSRobinson Nicholas Anthony · Westborough, MABuilt 1976 · S/N 28R-7635029N9111KWdiaz Design Inc · Sunny Isles Beach, FLBuilt 1976 · S/N 28R-7635221N911PSBittner Gregory L · Greensburg, PAS/N 28R-7435279N913FLL B Rocket Corp · Attleboro, MABuilt 1969 · S/N 28R-35128N9159KRoss Andrew · Yamhill, ORBuilt 1976 · S/N 28R-7635223N9180DSan Souci Holdings LLC · Reisterstown, MDS/N 2837014N9180HPiper Aircraft Inc · Vero Beach, FLS/N 2837015N9183WAerolina Inc · Hendersonville, NCBuilt 1989 · S/N 2837024N9201KGadamic LLC · Fresno, CABuilt 1976 · S/N 28R-7635224N9203KJoseph L Catania Dvm Pc · Alturas, CABuilt 1976 · S/N 28R-7635225N9236CRudloff Uwe K · Lake Village, INBuilt 1978 · S/N 28R-7837181N92605Sarratt Curtis H · Annapolis, MDS/N 2844002N9262CRick Aviation Inc · Newport News, VABuilt 1978 · S/N 28R-7837183N9266KRestrepo Aircraft Corp · Fort Lauderdale, FLBuilt 1996 · S/N 2844004N9274NOkuda Hideki · Rncho Pls Vrd, CABuilt 1996 · S/N 2844008
Back to AD 81-11-02 R1