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.

N59146Universal Charter Service Inc · Auburn, CABuilt 1974 · S/N U20602624N5914BStrong Brian DBA · Southport, NCBuilt 1956 · S/N 33914N5914JFreedom One Inc · San Jose, CABuilt 1975 · S/N 18263575N5914RWaldrop Charles Trustee · Oklahoma City, OKBuilt 1965 · S/N 17253583N59150Jp Aero Holdings Inc · Carson City, NVBuilt 1959 · S/N 17265N5915AMyers Glen L · Grassy Butte, NDBuilt 1956 · S/N 28515N5915BTaylor Scott G · Draper, UTBuilt 1956 · S/N 33915N5915FJeffries Phillip L · Belington, WVBuilt 1967 · S/N 21058915N59164Marine Electrical & Refrigeration Of Kodiak LLC · Kodiak, AKBuilt 1974 · S/N U20602626N5916EBetz Albert N Jr · Lewiston, IDBuilt 1959 · S/N 17416N5916FTlc Flying Inc · Colfax, WABuilt 1967 · S/N 21058916N5916JUnited States Air Force - Owner · Eglin Afb, FLBuilt 1980 · S/N 17273845N59173Vogelgesang Randy · Gardnerville, NVBuilt 1973 · S/N 21060141N59175Brown Charles A · Boise, IDBuilt 1959 · S/N 55932N5917BHauser Nathan S · Newark, DEBuilt 1956 · S/N 33917N5917EConnor Liam Maxwell · South Range, WIBuilt 1959 · S/N 17417N5917RParcell Evelyn Cassandra · Norfolk, VAS/N 17253586N59180Kennedy Jared W · Cordova, AKBuilt 1980 · S/N 50582N59181Meader Luke C · Marfa, TXBuilt 1959 · S/N 52085N59182Abbott James H · Gallatin, TNBuilt 1958 · S/N 51578N5918JStansfield Carl B · Springdale, UTS/N A1500218N5918T2400 Rickenbacker LLC · Auburn, CABuilt 1964 · S/N 15060618N5919AFederico Gilbert · Litchfield Park, AZBuilt 1956 · S/N 28519N5919BBell Ian E · Rapid City, SDBuilt 1956 · S/N 33919N5919EBeaty David L · Mesa, AZBuilt 1959 · S/N 17419N5919JFiles Richard W · Yuma, AZBuilt 1970 · S/N A1500219N591CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282176N591NCPotto Aviation Inc · Wilmington, DEBuilt 1981 · S/N 18053193N5920A20 Awesome LLC · Albuquerque, NMBuilt 1956 · S/N 28520N5920RAmerican Eagle Aviation LLC · Flushing, MIBuilt 1965 · S/N 17253589N5920TLowe David M · Sacramento, KYBuilt 1964 · S/N 15060620N59210Safe Pilots Group LLC · Nyack, NYBuilt 1973 · S/N 21060161N5922AArmiger Scott L · Holly Springs, NCBuilt 1956 · S/N 28522N5922BLitton John C · Quartz Hill, CABuilt 1956 · S/N 33922N5922EAerial Scouting Solutions LLC · Sioux Center, IABuilt 1978 · S/N 17271963N5922JMerlin Iron Works LLC · Westwood, KSBuilt 1975 · S/N 18263577N5922THamilton David A · Piedmont, OHS/N 15060622N59237Boland Matthew S · Anchorage, AKBuilt 1974 · S/N U20602637N5923ARowlett Glen R · Brookshire, TXBuilt 1956 · S/N 28523N5923BWilson Phillip K · Waukesha, WIBuilt 1956 · S/N 33923N59240Banegas Jose Carlos Zankiz · Flint, TXBuilt 1974 · S/N 21060174N5924BZarinnia Anthony · Chelsea, MIBuilt 1956 · S/N 33924N5924ENowlin Edwin H III · Oakboro, NCBuilt 1959 · S/N 17424N5924GParsons Roderick L · Ripley, WVBuilt 1969 · S/N 15071424N59258Energy Roofing Technology Se LLC · Lake City, FLS/N 21060180N5925TGrizzle Kenneth A · Jerseyville, ILBuilt 1964 · S/N 15060625N5926ERegistration Pending · Marble Falls, TXRegistration pendingBuilt 1959 · S/N 17426N5926GMirandan5926g LLC · Napanoch, NYBuilt 1969 · S/N 15071426N5926JVintage Aviation LLC · Billings, MTBuilt 1975 · S/N 18263581N5926TPalyash Neil J · Wichita, KSBuilt 1964 · S/N 15060626
Back to AD 79-10-14 R1