OpenAirDocs.org
AD 81-12-06 R1

Registered aircraft · 5,102

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-12-06-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-12-06-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.

N6754YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1968 · S/N 27-4083N675KAAllis Kevin J · Columbia, MDS/N 14152N6762LSummit Aviation LLC · Sun Valley, IDBuilt 1970 · S/N 31-664N6768YPiper Aircraft Inc · Vero Beach, FLBuilt 1968 · S/N 27-4100N676ARBlackdog Air LLC · Belton, SCS/N 31-8152182N676SAVincennes University · Indianapolis, INBuilt 1979 · S/N 31-7912122N677RARa Aviation LLC · Omaha, NEBuilt 1968 · S/N 24-4764N6786YMuhlenkort Mary Anna · Beresford, SDBuilt 1968 · S/N 27-4122N678RKJ2k Plane LLC · Liberty Twp, OHBuilt 2004 · S/N T18208273N678TBHunter Dennis F · Rohnert Park, CAS/N 1925N678THSky High Aviation LLC · Shelby Township, MIBuilt 1978 · S/N 32R-7887283N67MLBgdr LLC · Wilmington, DEBuilt 1975 · S/N 340-0519N67SPBird Aviation · Salt Lake City, UTBuilt 1980 · S/N 32R-8029066N67TFHorton Richard D · Woodland Park, COBuilt 1999 · S/N 27-0275N67TGMccall Andrew Keith · Abilene, TXBuilt 1989 · S/N 4622032N67WYTramel Air LLC · Midland, TXBuilt 1999 · S/N T20608122N6810YAtem LLC · Helena, ALBuilt 1969 · S/N 27-4148N6812JGottschalk William R · Fort Atkinson, WIBuilt 1976 · S/N 32R-7680352N6817YInternational Air Services Inc Trustee · Carson City, NVS/N 27-4156N681ATCaudullo Alfred A · Bolton, CTBuilt 1977 · S/N 32-7740038N681DLHampton Michael D · Marshfield, MOBuilt 1965 · S/N 32-178N6823YWingsleasing LLC · Wichita, KSBuilt 1969 · S/N 27-4163N6825YDenton J Frederick · Hutchinson Island, FLS/N 27-4165N6836YOld School Aircraft LLC · Jackson, TNBuilt 1969 · S/N 27-4176N683RLMach 10 Cap LLC · Fincastle, VABuilt 1978 · S/N 61P-0499-205N6840JBeineke Paul · Marion, OHBuilt 1976 · S/N 32R-7680361N6843YBarlam Theodore P · Poway, CABuilt 1969 · S/N 27-4187N6851JHem Properties LLC · Winston Salem, NCBuilt 1976 · S/N 32R-7680370N6856FSchuybroek Aviation Inc · Dover, DEBuilt 1976 · S/N 32R-7780040N6856YAviation Data LLC · Carson City, NVBuilt 1969 · S/N 27-4200N6857YGraves Jessica M · Anthony, KSBuilt 1969 · S/N 27-4202N6863YDempsey Donald B · Deland, FLBuilt 1969 · S/N 27-4208N6864JHudson Phillip Jr · Cookeville, TNBuilt 1976 · S/N 32-7640104N6865JPlanepals LLC · Waverly, MOBuilt 1976 · S/N 32R-7680372N6865YDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1969 · S/N 27-4210N6868AFlamingo Air Inc · Cincinnati, OHBuilt 1965 · S/N 27-3096N6868DFlamingo Air Inc · Cincinnati, OHBuilt 1969 · S/N 32-40608N6875YDodge Stanley R · Pocatello, IDBuilt 1969 · S/N 27-4222N6879JJackson Evan · Gaston, INBuilt 1976 · S/N 32R-7680376N687WE-Tan Transportation LLC · Malone, WIBuilt 1992 · S/N 4622124N6880JRobertson Ed J · Owasso, OKBuilt 1976 · S/N 32R-7680377N6880YLavalley Richard G Jr Trustee · Sylvania, OHBuilt 1969 · S/N 27-4228N6882YFlamingo Air Inc · Cincinnati, OHS/N 27-4231N6888FAtlanta Peach Air LLC · Oxford, GAS/N 32R-7780049N6888JMovable Air LLC · Oldsmar, FLBuilt 1976 · S/N 32R-7680380N6888YFlying W Leasing Inc · Bartlett, ILBuilt 1969 · S/N 27-4240N688AGrasky Endurance Coaching LLC · Tucson, AZS/N 32R7887184N688MBHill Frank G · Navarre, FLBuilt 1965 · S/N 24-4231N6890Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 31-7812003N6897YReabe Design LLC · De Pere, WIBuilt 1969 · S/N 27-4250
Back to AD 81-12-06 R1