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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N81737Our Props LLC · Lewes, DEBuilt 2004 · S/N 1397 N8173LBrown Tobias Jason · Gulf Shores, ALBuilt 2003 · S/N 1380 N8174HBeitins Mark · Rockville, MDBuilt 1980 · S/N 34-8070155 N8174RAngel Aviation Inc · Peoria, AZBuilt 1980 · S/N 34-8070157 N8174SCs74s LLC · Naples, FLBuilt 1980 · S/N 34-8070166 N8175JBas Part Sales LLC · Greeley, COS/N 28R-8231038 N81765Barco John Lee Trustee · Santa Clarita, CAS/N 28R-8231039 N81776Lewis County Flying Club Inc · Lowville, NYBuilt 1980 · S/N 28R-8031083 N81778Miranda Henry I · Sunnyvale, CABuilt 1980 · S/N 28R-8031084 N817RKBermudez-Santana Tacito Octavio · Conyers, GAS/N 28R-8031082 N81835Martin Tully · Idalou, TXS/N 34-8233137 N81837Central Sand & Gravel Inc · Alexandria, LABuilt 1982 · S/N 34-8233136 N8186MNelson Justin S · Farr West, UTBuilt 1980 · S/N 348070179 N8186RKarmic Aviation 1 LLC · Grand Rapids, MIBuilt 1980 · S/N 34-8070180 N8188XClark Anthony · Augusta, KSBuilt 1980 · S/N 34-8070182 N818DSCao Roger · Tomball, TXS/N 18 N818HCCherneski Heath W · Seaford, VAS/N 82519 N818NA25th Infantry Division Huey LLC · Hillsboro, ORS/N 69-18010 N8190SAthar Glenola LLC · Mars, PABuilt 1982 · S/N 34-8233121 N819CDWinter Aviation LLC · Hermantown, MNBuilt 2002 · S/N 1251 N819PDVah Aircraft Sales LLC · Pompton Beach, NJS/N 34-8070048 N819RKWheels Up Aviation II Inc · Arlington Heights, ILBuilt 1977 · S/N 34-7770347 N819VSStreeter Robert H · Lino Lakes, MNBuilt 2005 · S/N 1493 N81AWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 34-8133107 N81BKSingh Akash · Clovis, CABuilt 2000 · S/N 1082 N81CNColumbia Aircraft Inc · Columbia, SCBuilt 1981 · S/N 34-8133110 N81DZAcceler8 Aviation LLC · Livermore, CABuilt 1978 · S/N 34-7870325 N81MMajerle Joseph III · Anchorage, AKBuilt 1993 · S/N 714 N81MARoberts Max E · Loudon, TNBuilt 1946 · S/N 1183 N81THStrand Christian P · Grand Rapids, MIBuilt 1978 · S/N 34-7870178 N8203XLillieaire LLC · Olive Branch, MSS/N 34-8333029 N82073D K Engineering LLC · Sioux City, IABuilt 1982 · S/N 34-8233120 N82077Lewis David J · Porter, TXBuilt 1981 · S/N 28R-8131095 N820GLFrank Kevin M · Glenview, ILFirst renewal noticeBuilt 1986 · S/N 251046 N8212CPumpkin Seed Aviation LLC · Wilmington, DEBuilt 1975 · S/N 34-7670120 N82136Aviation Leasing LLC · Holts Summit, MOS/N 28R-8231054 N8218SThoroughbred Aviation Ltd · State College, PABuilt 1982 · S/N 34-8233165 N82208Bainum Michael Shane · Palestine, TXBuilt 1982 · S/N 28R-8231052 N8221TPhinney Hartley · Gallatin, TNS/N 34-8070227 N8222ACarr Paul W · Plano, TXBuilt 1980 · S/N 34-8070230 N8222BCordero Jose Robert · El Paso, TXBuilt 1980 · S/N 34-8070231 N82268268 Holdings LLC · North Salt Lake, UTBuilt 1982 · S/N 28R-8231057 N8228JJerome George A · West Hills, CABuilt 1980 · S/N 34-8070252 N8228QMahaffey & Gore Pc · Oklahoma City, OKBuilt 1980 · S/N 34-8070253 N82294Snow Robert L · Newman Lake, WABuilt 1980 · S/N 28R-8031117 N8229ZCentral Ohio Aircraft Leasing LLC · Columbus, OHBuilt 1980 · S/N 28R-8031115 N822ACWings Over Winyah Flying Club · Georgetown, SCBuilt 2003 · S/N 1362 N822GTExecutive Aero Flight Club LLC · Cedar Rapids, IABuilt 2004 · S/N 1456 N822MJSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 348133248 N822SR4ever Aviation LLC · Grantsville, UTBuilt 2005 · S/N 1567

Back to AD 81-13-10 R1