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.

N461CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280853N461CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12506N461DYYoung Duff L · Avoca, TXBuilt 1961 · S/N 17248326N461GCEngebretson Eric T · Medford, ORS/N 25563N461RMRr&D Lp · Fayetteville, NCBuilt 1968 · S/N 17257043N461SPL & W Leasing LLC · Smyrna, TNBuilt 2000 · S/N 172S8360N461TJSharmouj Raymound · Christiansted, VIFirst renewal noticeBuilt 1970 · S/N 17259114N46200Larsen Delaine E · Wakarusa, INBuilt 1968 · S/N 17257102N46201Lakes Area Aviation LLC · Little Falls, MNBuilt 1968 · S/N 17257103N46203Avian Leasing LLC · Bremerton, WABuilt 1968 · S/N 17257105N46204Ms Tango LLC · Phoenix, AZS/N 17257106N46205Jeanes Michael W · Newbury Park, CABuilt 1968 · S/N 17257107N4620BRucando Matthew P · Eagle River, AKBuilt 1955 · S/N 31518N4620CWatkins Robert G · Palm City, FLBuilt 1953 · S/N 25564N4620NTownsend David S · Granbury, TXBuilt 1965 · S/N 18256422N4620XWilliams David R · Havre, MTS/N 15064670N4620YCenturion Travel LLC · Fort Worth, TXBuilt 1980 · S/N 21063960N46210Cloud Dancer Aviation Inc · Deland, FLBuilt 1968 · S/N 17257111N46211Carver Clarence K Trustee · Lutz, FLS/N 17257112N46214Greaves Ricky W · Arlington, TXBuilt 1968 · S/N 17257114N46219Diehl Samuel A · Hamptonville, NCBuilt 1968 · S/N 17257116N4621CHilliard J Scott · Girdwood, AKBuilt 1953 · S/N 25628N4621DW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 17272316N4621LOstrowski Frederick J · Otsego, MNBuilt 1966 · S/N 17254616N4621QFitzgerald Barry Eugene · Springfield, ILBuilt 1971 · S/N 21059521N4621XWidby David A · Anchorage, AKBuilt 1966 · S/N 15064671N46221Collins Kellie Lynn · Muskegon, MIBuilt 1968 · S/N 17257117N46226Tye Darren · Tulia, TXBuilt 1968 · S/N 17257120N46227Lindsay Lori K · Kenai, AKBuilt 1968 · S/N 17257121N4622AMyers Matthew D · Moody, TXBuilt 1956 · S/N 32220N4622LChp Group LLC · Semmes, ALBuilt 1966 · S/N 17254617N4622NVmi Flight Co LLC · Roanoke, VABuilt 1979 · S/N 18267281N4622QBas Part Sales LLC · Greeley, COS/N 21059522N46230Owen Collins · Toccoa, GABuilt 1968 · S/N 17257123N46231Hibdon Repair LLC · Grundy Center, IABuilt 1968 · S/N 17257124N4623AHickle William H · Inyokern, CABuilt 1956 · S/N 32221N4623CTaylor Hugh C · Madera, CABuilt 1953 · S/N 25567N4623FHatfield William G · Nunica, MIBuilt 1966 · S/N P206-0223N46245Fedor Allen L · Holdingford, MNBuilt 1968 · S/N 17257132N46246Pidgeon J Everett III · Millington, TNBuilt 1968 · S/N 17257133N4624LSfc LLC · Minden, NES/N 17254619N4624QBowen Kennith M II Trustee · Winters, CABuilt 1971 · S/N 21059524N4624URuby Marine Inc · Nenana, AKBuilt 1963 · S/N 18051324N4624VFisher Gregory S · Franklin, WIS/N 172RG0342N46250Lange William A Jr · Interlaken, NYBuilt 1968 · S/N 17257135N46251Kiley Lawson P · Gamaliel, ARBuilt 1968 · S/N 17257136N46254Schmidt Keven W · Madison, WIBuilt 1968 · S/N 17257139N46255Simpson Chad J · Dresser, WIBuilt 1968 · S/N 17257140N46256Hartford Air LLC · Gahanna, OHBuilt 1968 · S/N 17257141N4625CSublette Gary L · Westlake, TXBuilt 1953 · S/N 25569
Back to AD 79-10-14 R1