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.

N76XPCag Interional Inc DBA · Longmont, COBuilt 1976 · S/N R1722084N770CBTeton Avjet LLC · Driggs, IDBuilt 1976 · S/N R172-2175N770CDCunningham Campers & Rvs · Clarksville, INBuilt 1976 · S/N 33701774N771PMaxq Composites LLC · Oxford, MEBuilt 1969 · S/N 337-1165N771SMGilbreath Tony C DBA · Olustee, OKBuilt 1967 · S/N 337-0614N7724CBiedenharn John D · Sunset Beach, CABuilt 1975 · S/N 34-7670102N7724THedding/Neff Aviation LLC · Moore, OKS/N 1266N7728ALynch James Kevin · Forsyth, GABuilt 2004 · S/N 1454N772KWTime Flies LLC · Loxahatchee, FLS/N R1722854N772MABaumbaugh Randal Kelly · Granger, INBuilt 1978 · S/N R1722959N772MVAir And Sea LLC · Oak Bluffs, MAS/N R1722823N7734ZWollert Aircraft Sales · Wiley, COBuilt 1996 · S/N 2293N773TMSouthern Mooney Inc · Wilmington, DEBuilt 2012 · S/N 3449463N7742GEmmons Michael R · Temple, TXBuilt 1984 · S/N 34-8433047N774CHigear Aviation LLC · O Fallon, MOBuilt 2003 · S/N 1282N7751LU S Air Force Owner · Beale Afb, CABuilt 1970 · S/N R1720427N7752LUnited States Airforce Owner · Albuquerque, NMBuilt 1970 · S/N R1720428N7753LUnited States Air Force · Usaf Academy, COBuilt 1970 · S/N R1720429N7754LUnited States Air Force · U S A F Academy, COBuilt 1970 · S/N R1720430N77551Otto Robert E · Battle Ground, WABuilt 1977 · S/N R1722711N7755LUnited States Air Force · U S A F Academy, COBuilt 1970 · S/N R1720431N7756LUnited States Air Force · U S A F Academy, COBuilt 1970 · S/N R1720432N7757LUnited States Air Force · Usaf Academy, COBuilt 1967 · S/N R172-0259N775JDPolakewich Gerald F · Biddeford, MEBuilt 1979 · S/N R1723124N7764CJrh Trading LLC · Grapevine, TXBuilt 1946 · S/N 166N776MFBering Capital LLC · Anchorage, AKBuilt 1981 · S/N 34-8133186N7770LEiler Donald L · Des Moines, WABuilt 1974 · S/N 34-7570046N777CD777cd LLC · Rochester, MNBuilt 1978 · S/N 28R-7803255N777HEUsoarflorida LLC · Fort Myers, FLS/N 172S8120N777JDFwm Aviation Inc · Washington, DCBuilt 1977 · S/N 28R-7703156N777MBCullen Maryrose · Longmont, COBuilt 1977 · S/N R1722601N777MDMateusz Dziuda · CambridgeBuilt 1981 · S/N 28R-8131117N777MTNortheast Cub LLC · Hudson, NYBuilt 1980 · S/N 25-0418N777NDFreed David · Santa Barbara, CABuilt 2002 · S/N 1258N777SNInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N P3370325N777TWMcdonald Timothy J · Daytona Beach, FLBuilt 1977 · S/N R1722585N777VYBloomfield Management Inc · Dodgeville, WIBuilt 2006 · S/N 71017N7788TIn Motion Aviation Group LLC · North Hollywood, CABuilt 2000 · S/N 1088N779CDHiatt John Trustee · West Des Moines, IABuilt 2004 · S/N 1445N77AHPate Steven H · El Paso, TXBuilt 1977 · S/N 28R-7703223N77CMRegistered aircraftBuilt 1973 · S/N P337-0015N77DNGrant County Mosquito Dist #1 · Moses Lake, WABuilt 1969 · S/N 33701234N77ENEuroaviation Inc Trustee · KemtenBuilt 1982 · S/N 28R-8231030N77FTCapeplane LLC · Cape May, NJBuilt 1997 · S/N 3449018N77KPInformation Softworks Inc · Ann Arbor, MIBuilt 1981 · S/N 34-8133067N77SZMermoz Inc Trustee · Wilmington, DEBuilt 1977 · S/N 34-7770198N78006Johnson Mildred J Executor · Boerne, TXS/N 2006N78037Bartholomew Don · Gardnerville, NVBuilt 1946 · S/N 2037N78056Plane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N 2056N78057Hampton Gerald N · Cameron Park, CABuilt 1946 · S/N 2057
Back to AD 81-13-10 R1