OpenAirDocs.org
AD 86-08-06 R1

Registered aircraft · 519

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:86-08-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:86-08-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.

N40261Jones Aviation Inc · Biggs, CABuilt 1999 · S/N G10-158N404VAInternational Bank Of Commerce · Laredo, TXBuilt 1987 · S/N 8120N405SAWpp Nautical LLC · Helena, MTBuilt 1980 · S/N T329N405VAInternational Bank Of Commerce · Laredo, TXS/N 8144N406VAInternational Bank Of Commerce · Laredo, TXS/N 8149N4089QBruces Flying Service Inc · Arlington, GABuilt 1999 · S/N G10-163N4090MCorsair Turbines LLC · Georgetown, TXBuilt 1979 · S/N TC290N4090WMauck Flying Service LLC · Hoxie, KSBuilt 2000 · S/N G1-115N409VAZeroavia Inc · Hollister, CAS/N 8097N40AMAisling Developments LLC DBA · Calhoun, GABuilt 1980 · S/N 427 S.A.N40JJIntercontinental Jet Service Corp · Tulsa, OKBuilt 1978 · S/N 383SAN40KCAir 1st Aviation Companies Inc · Glendale, AZBuilt 1974 · S/N 322N4152XAero Spray Inc · Kingfisher, OKBuilt 1974 · S/N 1928RN419SCZeplane LLC · Miami, FLBuilt 1980 · S/N 441-0149N4206PHeritage Ag LLC · Lakeview, MIBuilt 2001 · S/N G10-166N4208SOmega Air Service LLC · Fredericksburg, OHBuilt 2001 · S/N G10-167N420LWCrazy Horse LLC · Princeton, WVS/N 11455N4217XEarls Spray Service Inc · Breckenridge, MIBuilt 2001 · S/N G10-168N421MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-634N4223XAir Enterprises LLC · Dover, DEBuilt 1974 · S/N 1984RN422CABering Air Inc · Nome, AKBuilt 1982 · S/N 238N4239XMountain Air Spray Co · Craig, COBuilt 1974 · S/N 2012RN423DB2945l LLC · Terrell, TXS/N 1543 S.A.N423KAKmr Aviation Services Inc · Lynchburg, VABuilt 1993 · S/N 41023N424MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-639N425DFUsda Forest Service Fepp · Mcclellan, CABuilt 1999 · S/N 152825N425DTSun Fast Inc · Mansfield, TXBuilt 1978 · S/N 11519N425MACbg LLC · Wilsonville, ORBuilt 1986 · S/N AC-640N426DFUsda Forest Service Fepp · Mcclellan, CABuilt 1999 · S/N 152824N426MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-645N428MAUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N AC-646N42AFWild Hare Enterprises LLC · Valparaiso, INBuilt 1980 · S/N 787 S.A.N42AXTheia Aviation LLC · Philadelphia, PABuilt 1996 · S/N 41084N430MAGas/Wilson Inc · Traverse City, MIS/N AC-710BN430RRAce In The Sky LLC · San Antonio, TXBuilt 1974 · S/N AT030N434CAHorizon Aire LLC · Colorado Springs, COBuilt 1981 · S/N 286N439DFUsda Forest Service Fepp · Mcclellan, CABuilt 2002 · S/N 149854N439RARyan Air Inc · Anchorage, AKBuilt 1982 · S/N 287N43GTDon Avion LLC · Cedar Park, TXBuilt 1978 · S/N 441-0043N440ATT & M Aircraft LLC · Monticello, ILS/N G10-104N441ABank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 441-0094N441ABPistol Aviation LLC · Anaconda, MTBuilt 1981 · S/N 441-0284N441AQM & M Aircraft LLC · Mankato, MNBuilt 1981 · S/N 4410203N441BBMountain Sand Investment LLC · Wilmington, DEBuilt 1981 · S/N 441-0217N441BKBek Consulting LLC · Dickinson, NDBuilt 1981 · S/N 441-0215N441CCNoem Troy · Grand Junction, COBuilt 1977 · S/N 441-0008N441CJNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 1979 · S/N 441-0117N441CTAberdeen Flying Service · Aberdeen, SDBuilt 1978 · S/N 441-0048N441DFUsda Forest Service Fepp · Mcclellan, CABuilt 2003 · S/N 152808N441DNSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1983 · S/N 441-0325
Back to AD 86-08-06 R1