OpenAirDocs.org
AD 81-13-10 R1

Registered aircraft · 4,000

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.

N1555XShelton Brad · Wildwood, MOBuilt 1975 · S/N 34-7570284N1556VSquires Daniel Douglas · Wakefield, RIBuilt 1976 · S/N R1722201N1570XTmstarservices LLC · Lewes, DEBuilt 1975 · S/N 34-7570290N157BJHolm Brian · Buckley, WABuilt 1975 · S/N 34-7570282N157CDSierra Sky Aviation LLC · Carson City, NVBuilt 2000 · S/N 1061N159CDN159cd LLC · Buford, GAS/N 1063N15CSBartlett Branden S · Chugiak, AKBuilt 1974 · S/N R172-GC-3N15EEBorn To Fly LLC · Booker, TXBuilt 1981 · S/N 34-8133054N15FRScl Enterprises LLC · Waukesha, WIBuilt 1979 · S/N R1723280N15FSHappytails Aviation LLC · Fort Collins, COBuilt 1981 · S/N 34-8133046N15MZCaillarec Philippe · Le RheuNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28R-7803274N161KWKirtland Aero Club · Albuquerque, NMBuilt 1976 · S/N R1722002N161MPJb Aviation LLC · Newark, OHBuilt 1992 · S/N 24-3276N1623VHues Oulton A Jr · Norwood, MABuilt 1976 · S/N R1722206N162BWSimply Living LLC · Fort Myers, FLBuilt 1975 · S/N 34-7570147N162CDDudley Joseph · Huffman, TXS/N 1066N162FRFlying Restaurants LLC · Minot, NDBuilt 1993 · S/N 3448033N162RRDubosque John Leroy Jr · Saint Helena, CABuilt 1979 · S/N 25-0094N163CDRadioflyer Aviation LLC · Lathrup Village, MIBuilt 2000 · S/N 1067N164CDStovall Ryan T · Alpharetta, GABuilt 2000 · S/N 1069N165CDGray Andrew Trustee · San Diego, CABuilt 2000 · S/N 1070N1660BKanode William E · Delaware, OHS/N 17268123N166ABSafford Aviation Service Inc · Coolidge, AZBuilt 1981 · S/N 34-8133134N167CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 1073N168CDCirrusly LLC · Kalispell, MTBuilt 2000 · S/N 1079N1698VStem Aviation Academy · Carlsbad, CABuilt 1976 · S/N R1722209N169CDGroseth Cyler D Sr · Surprise, AZS/N 1077N169EBMutyala Susheel V · Bellevue, WABuilt 2001 · S/N 3449230N169WWPro Aire Inc · Chisago City, MNBuilt 1967 · S/N 1057CN16EWElliott Frank F · Mojave, CABuilt 1979 · S/N 26N16PFTurbine Financial Group LLC · Ogden, UTS/N R1722771N16TKKane Thomas E · Mc Alpin, FLBuilt 2008 · S/N 82055N16VVLaughlin R C Jr · Boerne, TXBuilt 1967 · S/N R1720058N1700MDeltahawk Engines Inc · Racine, WIBuilt 1970 · S/N 33701300N1708ZVr Jet LLC · Goshen, INBuilt 1963 · S/N 336-0008N170CDStrategic Leasing Investments And Consulting LLC · Madison, WIBuilt 2000 · S/N 1076N170DWarr Victor L · Star, IDBuilt 1951 · S/N 20194N170GKipp Robert C · Woodinville, WABuilt 1952 · S/N 20456N170HSAero Leasing LLC · Brandon, MSBuilt 1982 · S/N 34-8233164N170PYYates James H · Edmond, OKBuilt 1951 · S/N 19949N1713MOne Zero Four LLC · Germantown, TNBuilt 1970 · S/N 33701313N1717VThorsness David A · Foley, MNS/N R1722210N171CDBartlett John M · Everett, WABuilt 2000 · S/N 1080N1723MStahlman Richard D · Beaverton, ORS/N 33701323N1724MDickehut Donna C · Cloverdale, INBuilt 1971 · S/N 33701324N1725ZDavid B Curliss · Beavercreek, OHBuilt 1963 · S/N 336-0025N172CBRed Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1977 · S/N R1722290N172CXBias Aviation LLC · Crossville, TNBuilt 1980 · S/N R1723373N172DDMurphy Dylan James · Murphys, CABuilt 1977 · S/N R1722547N172REStinchcomb Jonathan C · Palmer, AKS/N 0041
Back to AD 81-13-10 R1