OpenAirDocs.org
AD 79-21-01 R1

Registered aircraft · 1,074

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-21-01-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-21-01-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.

N724HKHawkeye Helicopter LLC · Lyndon, KSBuilt 2000 · S/N 0553EN7250EAg Air Inc · Oakdale, CABuilt 1974 · S/N 1529N725MAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 500726DN727BBDle Corp · Lewes, DES/N 735N727JSTrickett Michael W · Washington, DCBuilt 2002 · S/N 5048N727JVCalifornia Helicopter Operations LLC · Santa Rosa, CABuilt 1973 · S/N 230451SN72VVBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N P21000339N734HHHlh Leasing LLC · Wilmington, DEBuilt 1980 · S/N 200677DN735CBChesapeake Bay Helicopters Inc · Chesapeake, VABuilt 1980 · S/N 1100858DN73AJGreenway Avia Inc · Wilmington, DES/N 922N73AMMetroplex Flight Services LLC · Fort Worth, TXS/N 3473N743MHDah Aircraft LLC · Georgetown, SCBuilt 1981 · S/N 811034DN745HAPrivate LLC · Kalispell, MTRegistration ineffective or invalidS/N 7413N74678Southmark Aviation Inc · Hattiesburg, MSBuilt 2001 · S/N 5274N747DMHunter Construction Group Inc · Mooresville, NCBuilt 1981 · S/N 3510N748CBCbhelos LLC · Chesapeake, VABuilt 1988 · S/N 0303EN74AJAerial Control Inc · Brentwood, CABuilt 1979 · S/N 2751N74FKSt Louis Airmotive LLC · Wilmington, DEBuilt 1979 · S/N 6004N75454Realstaff Rocket LLC · Salem, ORS/N 5280N75CWChem Air LLC · Shreveport, LABuilt 1975 · S/N 1762N75YLinville Manor LLC · Reidsville, NCBuilt 1994 · S/N 4304N760AMAir Services Inc · Minneapolis, KSBuilt 1976 · S/N 1060863SN76431Four Creeks Aviation Inc · Visalia, CABuilt 1958 · S/N 992N7650MAnw Investment Group LLC · Denham Springs, LABuilt 1971 · S/N 624N76544Churchill Scott · Jordan, MNBuilt 2001 · S/N 5273N765BWHva Inc · Summersville, WVBuilt 1980 · S/N 200661DN765KVWinco Inc · Aurora, ORBuilt 1984 · S/N 0082EN769KBWhiskey River Aviation LLC · Medford, ORBuilt 1993 · S/N LN056N770FKInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N 2144N771KESchilling Michael K · Kenai, AKBuilt 2004 · S/N 51002CN772DWCcf Ventures Inc · Bangor, MEBuilt 1976 · S/N 007N774CBCbhelos LLC · Chesapeake, VABuilt 1983 · S/N 0016EN775BDAviation Advantage Inc · Tabor City, NCBuilt 1977 · S/N 970197DN775DWCosta James J · Prineville, ORBuilt 1976 · S/N 028N77766Usda Aphis Wildlife Services · Cedar City, UTBuilt 2001 · S/N 5279N779DWRegistered aircraftBuilt 1975 · S/N 016N77DCOmega 377 Pennsylvania LLC · Shavertown, PABuilt 1985 · S/N E-2289N77YVSara Helicopters Inc · Wilmington, DEBuilt 1972 · S/N 520381SN782MHRotor Blade LLC · Pawleys Island, SCBuilt 1980 · S/N 600739DN784FNascar Aviation LLC · Silverado, CABuilt 1978 · S/N 2508N785CBAdvanced Aerial Services Inc · Bristol, VABuilt 1989 · S/N 4051N7860SMagnum Aviation LLC · Goff, KSS/N 6627N78906King County Sheriffs Office · Seattle, WABuilt 2001 · S/N 5277N78AMBell206 LLC · Anchorage, AKBuilt 1989 · S/N 4060N78MEElliott Enterprises Group LLC · Wilmington, DEBuilt 1981 · S/N 3442N78NLH&G Farms Inc · Corcoran, CABuilt 1974 · S/N 1561N79987Usda Aphis Ws · Cedar City, UTBuilt 2001 · S/N 5278N79FSMarchetti LLC · Conner, MTBuilt 1979 · S/N 066AN7MTCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1991 · S/N 12002CN7UMSabe Aviation Inc · Santa Monica, CABuilt 1975 · S/N 850767S
Back to AD 79-21-01 R1