AD 79-10-14 R1

Registered aircraft · 56,582

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-14-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:79-10-14-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.

N8214ARozycki Seth · Little Falls, MNBuilt 1952 · S/N 25066N8214FHoneycutt David · Columbus, MSBuilt 1966 · S/N 15064314N8214GKolman Michael D · Overland Park, KSBuilt 1971 · S/N 177RG0114N8214UN8214u LLC · Sheridan, ARBuilt 1964 · S/N 17252114N8214XStroemsvik Kristian · Strasburg, VABuilt 1961 · S/N 17248714N8215GGersten Iron · Spring Valley, CABuilt 1971 · S/N 177RG0115N8215LUmphrey Reid · Douglasville, GABuilt 1967 · S/N 17256415N8215XLaforest Jerome P · White Lake, MIBuilt 1961 · S/N 17248715N8215ZRg Aviation Inc · Wilmington, DEBuilt 1962 · S/N 205-0215N8216ADates Lauren C · Red Creek, NYBuilt 1952 · S/N 25068N8216BBrezina Chad M · Whitewright, TXBuilt 1957 · S/N 36016N8216GFarrar Edwin L · Mansfield, OHBuilt 1971 · S/N 177RG0116N8216JGuth Martin H · Kasilof, AKFirst renewal noticeBuilt 1976 · S/N 18502864N8216LWoodworth Mark S · Madison, OHBuilt 1967 · S/N 17256416N8216UClinch Jerome J · Lincoln, NEBuilt 1964 · S/N 17252116N8216XRiver Town Aviation LLC · Williamstown, WVS/N 17248716N8217BRoll George N · Freeport, FLBuilt 1957 · S/N 36017N8217GVne Aviation LLC · Dripping Springs, TXBuilt 1974 · S/N 18263352N8217LSteward Kim R · Durand, ILBuilt 1967 · S/N 17256417N8217MBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 18264566N8217XRiggs John · Punta Gorda, FLBuilt 1961 · S/N 17248717N8218FDel Rosario Jose · Hackettstown, NJBuilt 1966 · S/N 15064318N8218LTufts Kyle J · Hampden, MEBuilt 1967 · S/N 17256418N8218USalley Ronald C · Satellite Beach, FLBuilt 1964 · S/N 17252118N8218XEvans James · Millbrae, CAS/N 17248718N8219AElder Joel M · Scott City, KSBuilt 1952 · S/N 25071N8219FKietzer Tyler L · Mankato, MNS/N 15064319N8219GSchaum Jerome B · Machipongo, VABuilt 1971 · S/N 177RG0119N8219MFair Winds Group LLC · Portage, MIBuilt 1969 · S/N 21059219N8219UShaffer Kenneth H · Trout Lake, WABuilt 1964 · S/N 17252119N8219VGreenman Lisa J · Chesterton, INBuilt 1956 · S/N 29884N8219XCouch James T · Choctaw, OKBuilt 1961 · S/N 17248719N821CETedesco Michael Anthony · Monroe, CTBuilt 2023 · S/N 18283221N821CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281261N821DHMilsap Charles M · Owensboro, KYBuilt 2000 · S/N 18280710N821EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12665N821HGGeorgia Aviation Authority · Eastman, GABuilt 1978 · S/N 18266354N821RMC&C Aero LLC · Billings, MTBuilt 1967 · S/N 17256414N821SJc/Rc Ventures LLC · Key West, FLBuilt 2000 · S/N 18280821N821SDGlobal Adventures N821sd LLC · Hollywood, FLBuilt 1985 · S/N 172-76485N821STNorthwestern Michigan College · Traverse City, MIBuilt 2021 · S/N 172S12772N821WTVest Michael S · South Beach, ORBuilt 2024 · S/N 18283279N821WWDouble Whiskey Flyers LLC · Highlands Ranch, COBuilt 2006 · S/N 18281828N8220BTurner Travis Joseph · Chetek, WIS/N 36020N8220LFlywyo LLC · Kalispell, MTBuilt 1967 · S/N 17256420N8220SHammack Lindsey M · Westlake, TXBuilt 1965 · S/N 15061820N8220XGundry James A · Fall Creek, WIBuilt 1961 · S/N 17248720N8221BMayberry Jonathan J · Lake Stevens, WABuilt 1957 · S/N 36021N8221FSale Reported · Eau Claire, MISale reportedBuilt 1966 · S/N 15064321N8221GIshoy Glen · Indiana, PABuilt 1971 · S/N 177RG0121
Back to AD 79-10-14 R1