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.

N5633VMcwilliams Stephen C · Hollywood, MDBuilt 1977 · S/N 32R-7780349N56340Mja Aviation LLC · Channahon, ILBuilt 1973 · S/N 327340173N563JTRick Crum Aircraft Sales Inc · Prestonsburg, KYBuilt 2000 · S/N 3257181N5644YGantt William M · Port Orange, FLBuilt 1965 · S/N 27-2758N5649YPotenza Austin · Phoenix, AZBuilt 1964 · S/N 27-2764N56510Brocon Aviation LLC · West Des Moines, IABuilt 1973 · S/N 327340187N56527Kappel Kyle D · Crossville, TNBuilt 1973 · S/N 32-73-40189N56540Schilling Aviation Services LLC · Salina, KSBuilt 1973 · S/N 34-7350347N565BTGsg Aviation LLC · Fort Lauderdale, FLBuilt 1980 · S/N 31-8052118N56613Cochran Earnest · Texarkana, TXBuilt 1973 · S/N 32-7440009N56631Kalbfell Kenneth · Fallbrook, CABuilt 1973 · S/N 32-7440010N56655White James T · Ardmore, ALBuilt 1973 · S/N 32-7440012N5668VDrb Transport Inc · Alma, MIBuilt 1977 · S/N 32-7740071N566MEKaiser Aviation LLC · Spring, TXBuilt 2005 · S/N T20608566N56709Vola Acosta LLC · Lake Forest, CABuilt 1973 · S/N 32-7440020N5671YShore Gerry · Inez, TXBuilt 1965 · S/N 27-2785N56728Morris Air LLC · Tillar, ARBuilt 1973 · S/N 32-7440021N5677VAnnies Aviation LLC · Bloomington, INBuilt 1977 · S/N 32R-7780359N5678Hutter Peter S · Aspen, COBuilt 1969 · S/N 60-0017N56824Roberts Jeremy · Draper, UTBuilt 1973 · S/N 32-7440029N5683YCaribbean Flyer LLC · Kinshill, VIBuilt 1965 · S/N 27-2799N56866Skelton David W · Baker, FLBuilt 1973 · S/N 32-7440033N5688YYates Mary A · Haysi, VABuilt 1965 · S/N 27-2806N568CHigh Tech Aviation LLC · Lubbock, TXBuilt 2001 · S/N 3257264N568MCChristianson Kelly · Lusk, WYBuilt 2001 · S/N T18208010N5693YAlligator Air Transport LLC · Fort Lauderdale, FLS/N 27-2813N569DVDelta Victor LLC · Wilmington, DEBuilt 2002 · S/N T18208173N56ADTifc LLC · Winnsboro, SCBuilt 1971 · S/N 27-4642N56CXThinair LLC · Dover, DEBuilt 2000 · S/N 4636279N56GFInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N TG-29N56MHB S Aviation LLC · Stuart, FLBuilt 1979 · S/N 31-7952068N56MJBishop Ronald Daniel · Port Orange, FLBuilt 1981 · S/N 31-8152108N56PCValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 31-8052005N56PGElite Holdings Inc · Wilmington, DEBuilt 2001 · S/N 3257216N5702YLil Dawg Aviation Inc · Wilmington, DES/N 27-2823N5713YAnderson Leroy · San Angelo, TXBuilt 1965 · S/N 27-2835N5714YWild Frederick E Jr · Oklahoma City, OKBuilt 1965 · S/N 27-2836N571DTHardy Donald K · Beach, NDBuilt 2002 · S/N T18208120N57262Steelesky Ltd · Maineville, OHBuilt 1975 · S/N 3239N57266Department Of Public Safety · Baton Rouge, LABuilt 1974 · S/N 3208N5740YJts Aero LLC · New Hampton, NYS/N 27-2864N5742YAustin Mario A · Charlotte Amalie, VIBuilt 1965 · S/N 27-2867N5746YM C Flyers Inc · Port Orange, FLBuilt 1965 · S/N 27-2871N574HFKilo Romeo LLC · Anchorage, AKBuilt 2001 · S/N T20608308N574TMJohnson Tristan O · Pensacola, FLBuilt 1974 · S/N 32-7540019N5752YShackelford John S Jr · Roanoke, TXS/N 27-2877N5757International Air Services Inc Trustee · Carson City, NVBuilt 1997 · S/N 4636114N575EHajdukovich Robert M · Fairbanks, AKBuilt 1976 · S/N 31-7652006N5773YMccabe Aero LLC · Grand Haven, MIBuilt 1965 · S/N 27-2902N577JHLlopis USA LLC · Rockledge, FLBuilt 1999 · S/N 27-0281
Back to AD 81-12-06 R1