OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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.

N857JWWarren Joseph A · Milford, DEBuilt 1963 · S/N 2435N857SSjs Aviation Co · Casper, WYBuilt 1981 · S/N 28-8190224N8580DKedrowski James L · Wasilla, AKBuilt 1958 · S/N 18-6238N8581DDutch Air LLC · Kalispell, MTBuilt 1957 · S/N 18-6239N8581VObx Airplanes LLC · Manteo, NCBuilt 1975 · S/N 805-75N8582JMarchione Laverne R · Diamondville, WYBuilt 1967 · S/N 15066482N8583VMorten John E DBA · Larimore, NDBuilt 1975 · S/N 145-75N8583YGray Michael W · Cheyenne, WYBuilt 1968 · S/N 30-1736N8585DMadsen Travis E · New Underwood, SDBuilt 1957 · S/N 18-6244N8587BDorsey Tony A · Anchorage, AKBuilt 1958 · S/N 36287N8587DSouthard Bryan O · Moneta, VABuilt 1957 · S/N 22-5766N8587VCaprock Soaring Association · Littlefield, TXBuilt 1974 · S/N 146-75N8588BSavage James B · Gibsonia, PABuilt 1975 · S/N 28-7525332N8588ELongaker Aviation LLC · Salem, VABuilt 1991 · S/N AG5B-10011N858KMAbsten Aviation LLC · Ashville, OHBuilt 1998 · S/N 21896N858RLLeto Richard G · Parker, COBuilt 2021 · S/N 828N858SFlying Tigers Flight School Ltd · Houston, TXBuilt 1978 · S/N AA5A0636N858SBBusch James David · Tempe, AZBuilt 2001 · S/N 20030N858SMLoomer Donald W · Williston, NDBuilt 1982 · S/N 28-8290079N858TVwf Enterprises LLC · Coppell, TXBuilt 2002 · S/N 81285N8590YNorthern Aviation LLC · Palmer, AKBuilt 1968 · S/N 30-1641N8591DConservative Three LLC · Taft, CABuilt 1958 · S/N 18-6251N8592NSluder George L · Willard, NCBuilt 1971 · S/N 28-7125434N8592VWest Michigan Aviation Academy · Grand Rapids, MIS/N 149-75N8593DTravis Charles E · Fairbanks, AKBuilt 1958 · S/N 18-6256N8594Campbell Jaret R · Watertown, SDBuilt 1973 · S/N 459-73N8594CNagia Omar Mohamed · Richmond, CAS/N 28-7625125N8594EMehlbauer Robert B · Owensboro, KYBuilt 1959 · S/N 7FC-367N8594NKosciusko Skipper N · West Cornwall, CTBuilt 1971 · S/N 28-7105144N8594VCosta James J · Tulare, CABuilt 1974 · S/N 799-75N8597DRwr Air Inc · Tol, AKBuilt 1957 · S/N 18-6248N8597VSitta Donald C · Farmington, NMBuilt 1975 · S/N 150-75N8598DBurkhart Verlus L · Fairmont, MNBuilt 1957 · S/N 22-5795N8599NScott Lauren M · Lighthouse Point, FLBuilt 1971 · S/N 28-7105146N8599VObx Airplanes LLC · Manteo, NCS/N 151-75N859MHHarrington Mark · West Milford, NJBuilt 2002 · S/N 24371N859TRaven Aviation LLC · Lexington, KYBuilt 1972 · S/N 28-7225288N85ALLee Donald Robert · Talkeetna, AKBuilt 2024 · S/N 1818150N85BKBkv Aero Squadron LLC · New Port Richey, FLBuilt 1974 · S/N 28-7425284N85BRPalmer Travis S · Maupin, ORBuilt 1987 · S/N 1392N85DGGarrison Stephen L · Johnson City, TNS/N 215N85FTSpain Ryan D · Shelbyville, ILBuilt 1991 · S/N SIMPSON 1N85HMArmey Andrew D · Fresno, CABuilt 1985 · S/N 1363N85HYGades Allen L Trustee · Montevideo, MNBuilt 2002 · S/N 2185N85JFFleeman Joseph R · Lawrenceburg, TNBuilt 1982 · S/N 2882N85JWWhittington Robert W · Blackwell, OKBuilt 1968 · S/N 17257686N85KWN85kw LLC · Avon, INBuilt 1987 · S/N 1618N85LSScholten Calvin B · Lakeland, TNFirst renewal noticeBuilt 2011 · S/N CS-1N85MANorthcutt Allan C · Broomfield, COFirst renewal noticeS/N 8059CN85MDPair Chris X · Fletcher, NCBuilt 2003 · S/N 25642
Back to AD 79-10-03 R2