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.

N8890PElliott Charles · New Smyrna Beach, FLBuilt 1965 · S/N 24-4242N8891PTobias Ethan · West Haven, UTBuilt 1965 · S/N 24-4344N8892PN8892p LLC · Glendale, AZBuilt 1965 · S/N 24-4345N8893ERegistration Pending · Pompano Beach, FLRegistration pendingBuilt 1976 · S/N 32R-7680186N8894PGarms Walter I III Trustee · Berkeley, CABuilt 1965 · S/N 24-4347N8897PFey Ray D · Middleton, WIBuilt 1965 · S/N 24-4351N8899PLavoie Paul · Macon, GAS/N 24-4353N889ACKdx Air Ventures LLC · Naples, FLS/N 60-8423024N88CMTurner Ronald A · Tulsa, OKBuilt 1974 · S/N 61-0150-080N88CXChamplin Aviation LLC · Kerens, TXBuilt 1974 · S/N 61P-0160-002N88HLLiberty Aero LLC · Carlsbad, NMS/N T18208377N88NPRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1976 · S/N 27-7754006N88PZ88pz LLC · Clifton Park, NYS/N 27-7754112N88RARusso Mark · Stevensville, MTBuilt 1996 · S/N 4636034N88RHKeystone Flyer LLC · Avon, INBuilt 1975 · S/N 32R-7680065N88TGMakushin Logistics LLC · Fairbanks, AKBuilt 1984 · S/N 31-8452020N88TLAh Legacy LLC · Orlando, FLBuilt 1980 · S/N 31-8152066N88VBBjelland Richard A · Galt, CABuilt 1967 · S/N 27-3609N88ZMFlorida Aero Services Sales Division Inc · Brandon, FLBuilt 1976 · S/N 31-7752016N8900PCabrejos-Guillen Roberto · Wichita, KSBuilt 1965 · S/N 24-4355N8901PRead Robert S · Peoria, AZBuilt 1966 · S/N 24-4356N8902PFarris Greg T · Ann Arbor, MIBuilt 1966 · S/N 24-4357N8903PBeyer Marvin A Jr · Taft, TXBuilt 1966 · S/N 24-4358N8905NHigh Noon Leasing LLC · Anchorage, AKS/N 32-40690N8905PBulle Jason L · Phoenix, AZBuilt 1966 · S/N 24-4360N8906PComanche Inc · Leoti, KSBuilt 1966 · S/N 24-4361N8907NCrain Roan · Cookeville, TNS/N 32-40693N8908NH & H Aviation LLC · Provo, UTBuilt 1969 · S/N 32-40695N8909NKrull Doug · Hendersonville, TNS/N 32-40696N890HMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052194N8910KCoulter Ts LLC · Midway, UTBuilt 1977 · S/N 32-7840046N8910NRam Aeronautics LLC · Wichita Falls, TXBuilt 1969 · S/N 32-40698N8910PComanche LLC · Peachtree City, GABuilt 1966 · S/N 24-4365N8911PVarga Craig S · Chino Valley, AZBuilt 1966 · S/N 24-4366N8914NTreetop Flyers LLC · Vashon, WABuilt 1969 · S/N 32-40704N8914WDines Stephen R · Monument, COBuilt 1964 · S/N 28-10483N8915PLegacy Aviation Mid-Michigan LLC · Kalamazoo, MIBuilt 1966 · S/N 24-4370N8916NBundy Richard · Little Egg Harbor, NJBuilt 1969 · S/N 32-40707N8917PLogsdon James C · Hanford, CABuilt 1966 · S/N 24-4372N8918NStratton Erin B · Baton Rouge, LABuilt 1969 · S/N 32-40711N891AWColonial Aviation LLC · Morristown, NJBuilt 1989 · S/N 4622024N891CBKal-1 LLC · Wichita, KSBuilt 1980 · S/N 31-8012064N8921POwens Gregory E · Kendallville, INBuilt 1966 · S/N 24-4377N8922NKew Malcolm M · Hercules, CABuilt 1969 · S/N 32-40717N8923NMiller Jarred J · Burton, OHBuilt 1969 · S/N 32-40718N8924NRobinson Andrew · Auburn, CABuilt 1969 · S/N 32-40720N8925NMackay James R · Corunna, MIS/N 32-40721N8925PGriffith James E · Gig Harbor, WABuilt 1966 · S/N 24-4381N8927NHoffman Gary D · Spencer, NEFirst renewal noticeBuilt 1969 · S/N 32-40724N8928PGeorg John B · La Crosse, KSBuilt 1966 · S/N 24-4384
Back to AD 81-12-06 R1