OpenAirDocs.org
AD 72-14-08 R1

Registered aircraft · 1,578

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:72-14-08-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:72-14-08-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.

N63DETri-Air LLC · Cedartown, GABuilt 1972 · S/N 310Q0675N63GTBrown Jamie Alan · Oak Island, NCS/N 35802N64310Aldrich Curtiss R · Big Oak Flat, CABuilt 1964 · S/N 310I0134N647TWWeigle Gerald V Jr Trustee · Cincinnati, OHBuilt 1973 · S/N 310Q0815N650RHill Tool LLC · Missoula, MTBuilt 1956 · S/N 35299N651RMackey Aviation LLC · Talking Rock, GABuilt 1960 · S/N 39261N652KWHauser Zachary D · Camp Verde, AZBuilt 1969 · S/N 310P0077N6554XFly Like A Boss Aviation LLC · Minden, NVBuilt 1967 · S/N 310L0179N655RScott Timothy L · Princeton, KSS/N 35066N65AEMorris Charles J · Rutherford, TNBuilt 1975 · S/N 421B0953N6610BP R Air Corp · San Mateo, CABuilt 1958 · S/N 35710N6625BRegistration Pending · Stephenville, TXRegistration pendingS/N 35725N6627BVmc Aviation · Yorba Linda, CABuilt 1958 · S/N 35727N662RKlotz Douglas · Incline Village, NVBuilt 1960 · S/N 39102N6633BNeel Aviation LLC · Lakeland, FLBuilt 1958 · S/N 35733N6637BNewbold Vernon D · Wheatland, WYS/N 35737N6644BN6644b LLC · Cresson, TXBuilt 1958 · S/N 35744N664RRobertello Gerald J · Centreville, VABuilt 1960 · S/N 39082N664RJGeneva Lakes Aviation LLC · Lake Geneva, WIBuilt 1975 · S/N 402B0854N6650BBrewer Eric Vincent · Alva, OKS/N 35750N66552Janak Jeffrey · Corpus Christi, TXBuilt 1963 · S/N 320B0003N6659BNelson Scott J · Bridgewater, MIS/N 35759N665RNelson Todd J · Bluffdale, UTBuilt 1958 · S/N 35755N6663BRegistration Pending · La Puente, CARegistration pendingS/N 35763N6665BRex Timothy Davis · Cape Coral, FLBuilt 1958 · S/N 35765N666LVPetecraft Aviation Services Inc · Plains, GABuilt 1958 · S/N 35748N6670BMorris Thomas B · Imlay City, MIBuilt 1958 · S/N 35770N6673BBushido Hospitality Services LLC · North Las Vegas, NVBuilt 1958 · S/N 35773N6675QLoyal Aviation LLC · Loyal, WIBuilt 1973 · S/N 421B0442N6683BOrf Mike · Austin, TXBuilt 1958 · S/N 35783N6685BSale Reported · Orange City, FLSale reportedBuilt 1958 · S/N 35785N6686BRjb Ventures Corp · Wilmington, DEBuilt 1958 · S/N 35786N6690BWalker Hyral B Jr · Wills Point, TXBuilt 1958 · S/N 35790N6698BElliott Frank F · Mojave, CAFirst renewal noticeBuilt 1959 · S/N 35798N66CWSpannhake John H · Washington, CTBuilt 1973 · S/N 310Q0844N66DHKingsbury Raymond S · Farmington, MNS/N 320E0041N66EPSpillett James Kreg · Sandy, UTBuilt 1973 · S/N 421B0520N66XXSale Reported · Denton, TXSale reportedBuilt 1964 · S/N 320C0033N6701XPlewa Gary M · Hays, NCBuilt 1960 · S/N 310-0001N6702TReeve Howard E · Minot, NDBuilt 1959 · S/N 39002N6706TMetz Robert W · Logan, UTFirst renewal noticeBuilt 1959 · S/N 39006N6708TCkg Aviation Services LLC · Argyle, TXBuilt 1959 · S/N 39008N6709XNeches Air Inc · Silsbee, TXBuilt 1960 · S/N 310-0009N6713XSkowbo Rock G · Winchester, VABuilt 1960 · S/N 3100013N6714TDewald Michael A · Garden Grove, CABuilt 1959 · S/N 39014N6716XEberly Steven · Euless, TXS/N 310-0016N6720XCoburn Randy J · Saint George, UTBuilt 1960 · S/N 310-0020N6724XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1960 · S/N 310-0024N6727XVan Haitsma Kelley · Fort Worth, TXS/N 310-0027N6728TPatkotak Hugh G Sr · Anchorage, AKBuilt 1959 · S/N 39028
Back to AD 72-14-08 R1