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.

N5195YUrbana Aircraft LLC · Urbana, MDBuilt 2002 · S/N 172S9089N51960Xin Han Aviation LLC · Atwater, CABuilt 1980 · S/N 17274384N5196AParker Todd S · Kaysville, UTBuilt 1956 · S/N 28196N5196DPugsley Todd F · Albany, ORBuilt 1958 · S/N 51296N5196GOlasz Jonathan S · West Barnstable, MABuilt 2002 · S/N 172S9092N5196PEsbenshade Wilmer R · New Holland, PABuilt 2002 · S/N 18281125N5197ETspy Services Inc · Wilmington, DEBuilt 1978 · S/N 17271765N5197HSullivan Edward A · Remsenburg, NYBuilt 1975 · S/N 17265370N5197JEide Paul · Moses Lake, WAFirst renewal noticeBuilt 1981 · S/N 17275000N5197KN5197k LLC · Cheyenne, WYBuilt 1980 · S/N 17274007N5197RMedia Stew LLC · Carson City, NVS/N 17263414N5197TUw Flying Club Inc · Sun Prairie, WIBuilt 2002 · S/N 172S9131N5198DHaw LLC · Wilmington, DEBuilt 1958 · S/N 51298N5198EGaruda Flight Training LLC · Miami, FLBuilt 1978 · S/N 17271766N5198HBranson William E · Stokesdale, NCFirst renewal noticeBuilt 1975 · S/N 17265371N5198JMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2009 · S/N 18282147N5198QValiair Lc Trustee · Casper, WYBuilt 2010 · S/N 18282210N5198TBlack Dog Aviation LLC · Troy, MIBuilt 2002 · S/N 20608178N5198UFerguson Kenneth R · Tehachapi, CABuilt 1964 · S/N 206-0198N5198VMaddock Jay B · Sugar Grove, ILS/N 21060859N51991Raider Aviation LLC · Lubbock, TXBuilt 1980 · S/N 17274390N51996Skywarrior Flight Training Inc · Pensacola, FLBuilt 1980 · S/N 17274392N5199BFly172s LLC · Peoria, AZBuilt 2002 · S/N 172S9093N5199ESnowden Andrea K · Anchorage, AKBuilt 1959 · S/N 50499N5199JG&M Aircraft Inc · Wheat Ridge, COBuilt 2002 · S/N 172S9097N519AMRegistration Pending · Manheim, PARegistration pendingBuilt 2023 · S/N 18283225N519ERStick & Rudder Club Inc · Waukegan, ILBuilt 2002 · S/N 172S9107N519MPUpdike Jesse J · Kenai, AKS/N 17253042N519MQMgnh Services LLC · Houlton, MEBuilt 1983 · S/N 18504413N519NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10810N51AKSchroth Charles D DBA · Gustavus, AKS/N U20603785N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602N51CHEcho Acquisitions LLC · Dover, DES/N 18280112N51CMCorley W Michael · Mc Minnville, TNBuilt 1972 · S/N 21059628N51CVMarotta Daniel C · Tijeras, NMBuilt 1980 · S/N 18053160N51ESBurton Donald O · Mooresville, NCBuilt 1955 · S/N 31839N51FACoffey Michael A · White Lake, MIBuilt 1962 · S/N 17249754N51HFSan Mateo County Sheriff'S Office · Redwood City, CABuilt 2012 · S/N 20608347N51MSDekervor Marc Phillippe II · La Mesa, CABuilt 1970 · S/N 17259085N51PHAasen Christopher N · Corvallis, ORBuilt 1964 · S/N 18051478N51RMiozzi Thomas E · Jamestown, RIBuilt 1965 · S/N 18051631N51SARedtail Partners LLC · Moab, UTBuilt 1981 · S/N 20700699N51SPDepartment Of Public Safety · Dover, DEBuilt 1980 · S/N 18267563N51UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12088N51WMMacair Aviation LLC · Xenia, OHS/N 337-1140N51WT51 Whiskey Tango LLC · Henrico, VABuilt 1969 · S/N 17258240N51YTRupp Steven S · Cameron Park, CABuilt 1978 · S/N 18266686N520Registered aircraftBuilt 1977 · S/N 177RG1164N52004Jones Steve M · Anchorage, AKBuilt 1974 · S/N 18052437N52009Sale Reported · Palmer, AKSale reportedBuilt 1974 · S/N 18052438
Back to AD 79-10-14 R1