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.

N5187RTke Ltd · Thief River Falls, MNBuilt 1974 · S/N 17263404N51883Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274371N51885Angel Aviation Inc · Peoria, AZBuilt 1980 · S/N 17274372N5188LMascari Nicholas M · Mundelein, ILBuilt 2002 · S/N 18281112N5188TCohen Edward R · Loomis, CABuilt 2002 · S/N 18281113N5188USky Stallion LLC · Winter Park, FLBuilt 1964 · S/N 206-0188N51890Hyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 17274375N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302N5189EOpportunity Flying Club Inc · Anchorage, AKBuilt 1959 · S/N 50489N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114N518CACompass Aviation Inc · Shelby, NCBuilt 1979 · S/N 17273049N518CRM & A Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 18280281N518HJArmstrong Consolidated LLC · Anchorage, AKBuilt 1971 · S/N 18501930N518MJPursuit 53 · College Station, TXBuilt 1981 · S/N U20606535N518PUSalim Omar J · Olympia, WABuilt 1983 · S/N 172RG1135N518RAPeterson Maeve M · Sonoma, CABuilt 1960 · S/N 15059082N518SPGreater Flint Pilots Associations Inc · Flushing, MIBuilt 2000 · S/N 172S8379N518VKingsley Kiman J · Miller, MOBuilt 1956 · S/N 32429N519Malaska Jacob L · Orefield, PABuilt 1966 · S/N 15064303N5190DWalden James F · Willcox, AZBuilt 1958 · S/N 51290N5190JAoa Kissimmee Inc · Kissimmee, FLBuilt 2002 · S/N 172S9151N5190RIasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281111N5191ABurdeaux Barry S · Orting, WAS/N 28191N5191FArapahoe Aero Aircraft Sales LLC · Englewood, COBuilt 2002 · S/N 18281115N5191JN5191j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273724N5191RKlein Alan D · Hudson, WIBuilt 1974 · S/N 17263408N5191URobles Marcos F · Oracle, AZBuilt 1964 · S/N 206-0191N5191VTrue Drilling LLC · Casper, WYBuilt 1975 · S/N 21060857N51920Wilkinson Edward H · Aspers, PABuilt 1980 · S/N 17274377N5192AGenitempo Serge · Studio City, CABuilt 1955 · S/N 28192N5192DJstream Lc · Sheridan, WYBuilt 1958 · S/N 51292N5192VStippich James A · Panama City, FLS/N 172RG0464N51930Garrett Jeff S · Waco, TXBuilt 1980 · S/N 17274378N51931Jones Donald T Jr · Barrigada, GUBuilt 1980 · S/N 17274379N5193AGustaf John A · Lowell, MIBuilt 1956 · S/N 28193N5193ER&R Aero Services LLC · Eden Prairie, MNS/N 17271763N5193HClear Skies Avionics Inc · Clearwater, FLBuilt 1975 · S/N 17265368N5193RHaralson Aviation Inc · Elberton, GABuilt 1974 · S/N 17263410N5193UCox Paul G DBA · Bryce, UTBuilt 1964 · S/N 2060193N5194DHumphries Danny · St George, UTBuilt 1958 · S/N 51294N5194E4d Aviation LLC · Gilbert, AZBuilt 1959 · S/N 50494N5194FSanders Flight Training Center Inc · Jasper, ALBuilt 1979 · S/N 17273125N5194KHowe'S Flight Concepts LLC · Visalla, CAFirst renewal noticeBuilt 1980 · S/N 17274005N5194NAndros Aviation LLC · Santa Margarita, CABuilt 2002 · S/N 20608177N5194RFitzke Lee J Trustee · Lakeville, MNBuilt 1974 · S/N 17263411N5194TBrown Helicopter Inc · Pensacola, FLS/N U206-06660N51952Jandd One LLC · Bozeman, MTBuilt 1980 · S/N 17274381N51958Mike'S Aircraft Shop Inc · Corpus Christi, TXBuilt 1980 · S/N 17274383N5195AOlson Brothers · Williams, AZBuilt 1979 · S/N 21063304N5195ESix Ten Ventures LLC · Grand Prairie, TXBuilt 1978 · S/N 17271764
Back to AD 79-10-14 R1