OpenAirDocs.org
AD 81-23-03 R2

Registered aircraft · 421

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-23-03-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-23-03-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.

N6069PAirborne Helicopters LLC · Hendrum, MNBuilt 1978 · S/N P21000136N6088PSide Deck Event Management LLC · Lexington, SCBuilt 1978 · S/N P21000141N6099WGriffith Aviation Co · Tulsa, OKBuilt 1981 · S/N P21000713N60DWJohnson Boyd · Apple Valley, MNBuilt 1981 · S/N P21000696N60MKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N P21000670N60RSVolare Alto LLC · Sanford, NCBuilt 1980 · S/N P21000521N6102WPlane Blessings LLC · Montrose, COBuilt 1981 · S/N P21000715N6134ECf Ranch & Cattle Co LLC · Burbank, OHBuilt 1981 · S/N P21000737N6178WBlu Sky Key West LLC · Key West, FLBuilt 1981 · S/N P21000724N6209PFly Fast Live Slow LLC · Chiefland, FLBuilt 1978 · S/N P21000151N6262KBrz Air LLC · Beaumont, TXBuilt 1979 · S/N P21000395N627BTAviation Global Inc · Saint Augustine, FLBuilt 1981 · S/N P21000768N6280PAirborne Equipment Inc · Hendrum, MNBuilt 1979 · S/N P21000159N6290WLord Of The Wings LLC · Syracuse, NYBuilt 1981 · S/N P21000742N6294PMarkowich Darren K · Gilbert, AZBuilt 1978 · S/N P21000163N6299PDanlars Aircraft Sales · Mccall, IDBuilt 1978 · S/N P21000165N62SK55x LLC · Kalispell, MTS/N P21000096N6300PSchrempp Aviation LLC · Winnemucca, NVBuilt 1978 · S/N P21000166N6320PSims Jacob Trustee · Montrose, COBuilt 1978 · S/N P21000168N6328PSabath Kenneth J Trustee · Powell, WYBuilt 1978 · S/N P21000170N6359WScarlett Cameron O · Madison, WIBuilt 1981 · S/N P21000757N6385PBada Alfredo · Mcallen, TXBuilt 1978 · S/N P21000173N6389WSpenco Inc · Sale Creek, TNBuilt 1981 · S/N P21000764N6398WPivac Jorge I · Chandler, AZBuilt 1982 · S/N P21000767N6399KI B Development LLC · Monahans, TXBuilt 1979 · S/N P21000397N639FSC&Bh LLC · Vernal, UTBuilt 1980 · S/N P210-00639N6409WBreedlove Joe · Skiatook, OKBuilt 1981 · S/N P21000770N6413PAlta Air LLC · Boise, IDBuilt 1978 · S/N P21000176N6416WGallien Anthony · Livermore, CABuilt 1981 · S/N P21000773N642DSJgm Aviation LLC · The Woodlands, TXBuilt 1980 · S/N P21000510N6431PHhd Aviation LLC · Hamilton, OHBuilt 1978 · S/N P21000182N6444WBas Part Sales LLC · Greeley, COBuilt 1982 · S/N P210-00781N6446WRichter Aviation Inc · Maxwell, CABuilt 1981 · S/N P21000782N644VCElder Daniel R · Kalispell, MTBuilt 1979 · S/N P21000249N6476WWill Investments Inc · Englewood, COBuilt 1981 · S/N P21000784N6489WReed Michael · Temple, TXBuilt 1981 · S/N P21000785N6527PKaci Property Management Inc · Boise, IDBuilt 1978 · S/N P21000186N6531WInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N P21000791N6537WSilver Eagle Holdings LLC · Jerome, IDS/N P21000793N6582PGrand High Way LLC · Gallatin, TNBuilt 1978 · S/N P21000191N6586WMair LLC · Lenexa, KSBuilt 1982 · S/N P21000800N6593WSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N P21000801N6598WValiair Lc Trustee · Casper, WYS/N P21000802N6609WKingsford Smith LLC · Tulsa, OKBuilt 1982 · S/N P21000804N6634PAviation-Avsec Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1978 · S/N P21000194N665SWAmerican Classic Corp · Ludington, MIBuilt 1980 · S/N P21000588N666JGGronemeyer Jens · Deland, FLBuilt 1981 · S/N P210-00657N66TEFly4fun LLC · El Segundo, CABuilt 1978 · S/N P21000154N66VSEurovation Inc Trustee · KematenBuilt 1979 · S/N P21000421N66WSDighans Murray · Peerless, MTBuilt 1979 · S/N P210-00363
Back to AD 81-23-03 R2