OpenAirDocs.org
AD 81-13-10 R1

Registered aircraft · 4,001

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-13-10-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-13-10-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.

N231LULewis Matthew G · Wilmington, MABuilt 1980 · S/N 25-0302N231LVFalcon Global LLC · Sedona, AZBuilt 1980 · S/N 25-0303N231LWNewberg Edgar T · Hector, MNBuilt 1979 · S/N 25-0147N231MMitchell Philip A · Rhome, TXBuilt 1978 · S/N 25-0011N231MEBass Daniel · Winona, MNBuilt 1979 · S/N 25-0166N231MFCoker Steve L · Tyler, TXBuilt 1979 · S/N 25-0077N231MGRichard F Marshall Inc · Fort Jones, CABuilt 1978 · S/N 25-0023N231MHPacific Commonwealth Mortgage Co · Incline Village, NVBuilt 1980 · S/N 25-0307N231MKEastman Gregory L · Pueblo, COBuilt 1980 · S/N 25-0309N231MLL8n Aero LLC · New Harmony, UTBuilt 1980 · S/N 25-0310N231MNMacair LLC · Santa Barbara, CAS/N 25-0717N231MPCraig Steven A · Olympia, WAS/N 25-0049N231MSKimmerly Andrew · Chandler, AZBuilt 1980 · S/N 25-0313N231MTBell Kenneth M · Cedar Park, TXBuilt 1979 · S/N 25-0189N231MUStorey Otto John · Lake Oswego, ORBuilt 1980 · S/N 25-0314N231MYCastle Compu Systems LLC · New Castle, PABuilt 1979 · S/N 25-0152N231NABrien Lucas M · Norwich, VTBuilt 1980 · S/N 25-0318N231NCCross Joshua A · San Antonio, TXBuilt 1980 · S/N 25-0447N231NDPowers Jimmy Lee · San Antonio, TXBuilt 1979 · S/N 25-0207N231NET & M Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 25-0320N231NFAratreus Holdings LLC · South Charleston, WVS/N 25-0321N231NHBooska Steven A · Angwin, CABuilt 1980 · S/N 25-0323N231NJQuinton Aaron S · Columbus, INBuilt 1980 · S/N 25-0324N231NLBurkhart Scott C · Livermore, CABuilt 1980 · S/N 25-0325N231NNKelly Luciano LLC · Independence, OHBuilt 1980 · S/N 25-0326N231NSLawrence Steven R · Chowchilla, CABuilt 1980 · S/N 25-0329N231NUMcmillan Keith A · Milwaukee, WIBuilt 1980 · S/N 25-0331N231NZSchumacher Kim L · Beach City, OHBuilt 1980 · S/N 25-0336N231PWilverding Jerome C · Stockton, CABuilt 1979 · S/N 25-0066N231PDDuncan William Thomas Jr · Virginia Beach, VAS/N 25-0337N231PEHiawatha Valley Aviation Inc · Hawley, MNBuilt 1980 · S/N 25-0338N231PFStephans Emery J · Waitsfield, VTBuilt 1979 · S/N 25-0102N231PGHartford Aircraft LLC · Monument, COBuilt 1979 · S/N 25-0242N231PLBryan Shawn D · Kempner, TXBuilt 1979 · S/N 25-0110N231PNTaylor Richard · Pacific Palisades, CABuilt 1980 · S/N 25-0341N231PPBlackdog Air LLC · Seattle, WABuilt 1980 · S/N 25-0342N231PQHutchens David · Pikeville, KYBuilt 1980 · S/N 25-0343N231PRHoegg Thomas K · Mountain Home, IDBuilt 1980 · S/N 25-0344N231PSVero Flyboys LLC · Vero Beach, FLBuilt 1980 · S/N 25-0345N231PXLeading Edge Aviators LLC · Denver, COBuilt 1980 · S/N 25-0349N231PZTurner Robert A Jr · Elmhurst, ILBuilt 1980 · S/N 25-0351N231QBBeamalloy Inc · Houston, TXBuilt 1979 · S/N 25-0237N231QECarter David A · Charlotte, MEBuilt 1980 · S/N 25-0355N231QGD4 Enterprises LLC · Longview, TXFirst renewal noticeBuilt 1980 · S/N 25-0357N231QHWalworth County Holdings LLC · Lake Geneva, WIBuilt 1980 · S/N 25-0358N231QJLecl Air Corp Trustee · Wilmington, DEBuilt 1980 · S/N 25-0359N231QPRaney Chad T Trustee · San Antonio, TXBuilt 1982 · S/N 25-0670N231QZAlexander Michael · Brentwood, TNBuilt 1980 · S/N 25-0373N231RBDemotechnics LLC · Deerfield Beach, FLBuilt 1978 · S/N 25-0016N231RCKc Initiative LLC · Canyon, TXBuilt 1980 · S/N 25-0374
Back to AD 81-13-10 R1