OpenAirDocs.org
AD 71-09-07 R1

Registered aircraft · 1,686

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:71-09-07-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:71-09-07-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.

N6535YRichardson Jane S · San Angelo, TXS/N 21064424N6538NHaynie Ray G · Auburn, WABuilt 1978 · S/N 21063094N6542CLeonard Summers · Pleasanton, CABuilt 1980 · S/N 21063913N6544YSchwarzenberg Johannes · Helena, MTBuilt 1981 · S/N 21064429N6546NMitchell Matthew J · Penn Yan, NYBuilt 1978 · S/N 21063102N6547CJrp Management LLC · Williams, AZBuilt 1980 · S/N 21063915N6553YCenturion Aero LLC · Coos Bay, ORBuilt 1981 · S/N 21064434N6557BFangio Mark · Mckinney, TXBuilt 1978 · S/N 21062786N6562YKp Builders Inc · Pittsburgh, PABuilt 1981 · S/N 21064440N6567YMoeller Gerhard Walter · Goshen, OHBuilt 1981 · S/N 21064442N6568XBarnes Inc · Lewiston, IDBuilt 1980 · S/N U20605950N656MCMcintosh Justin W · Joshua, TXBuilt 1978 · S/N 21063111N6572YMoss G B · Bakersfield, CABuilt 1981 · S/N 21064444N6582XMclean Bruce R · Napa, CABuilt 1980 · S/N U20605958N6584NHartmann Wayne E · Hill City, SDBuilt 1978 · S/N 21063112N6588XPc Rental LLC · Ely, MNBuilt 1980 · S/N U20605962N6591NRickey James R · Hanford, CAFirst renewal noticeBuilt 1978 · S/N 21063114N65NOlterman Robin L · John Day, ORBuilt 1971 · S/N U20601729N6602CSnip Robert C · Telluride, COBuilt 1980 · S/N 21063926N6606YBlackwell Benjamin D · Scottsdale, AZBuilt 1981 · S/N 21064457N6614YBoots LLC · Clay Center, KSS/N 21064460N6617CN6617c Inc · Calumet City, ILBuilt 1980 · S/N 21063933N6621AJc Investors Group LLC · Coral Springs, FLBuilt 1979 · S/N 21063559N6622CMidnight Flight LLC · Wells, TXBuilt 1980 · S/N 21063936N6622YSierrakilo LLC Trustee · Lewes, DES/N 21064464N6638NIsr Aviation LLC · Wilmington, DEBuilt 1978 · S/N 21063129N6653BWilson Gale E · Lewiston, IDS/N 21062806N6661NSmith Joel L · Cedar Park, TXBuilt 1978 · S/N 21063137N6667NSmith William F · Hindsville, ARBuilt 1978 · S/N 21063141N6677BHess Chad · Boise, IDBuilt 1978 · S/N 21062816N6677RTre Aviation Corp · Wilmington, DES/N 21059654N6680BBush Douglas B · Santa Rosa Beach, FLBuilt 1978 · S/N 21062818N6686NClarity Aviation LLC · Anchorage, AKBuilt 1978 · S/N 21063146N6688NLedson Steven Noble · Sonoma, CAS/N 21063148N6694NGear Down LLC · Dalhart, TXBuilt 1978 · S/N 21063150N66CEM&S Real Estate Management Inc · Granbury, TXS/N 21061391N66DFClark Samuel D Trustee · Wilson, WYBuilt 1977 · S/N 210-621-41N66GAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 20700657N66MLBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 21062598N6703RSteinle Lee M · Jourdanton, TXBuilt 1966 · S/N T210-0103N6706RSzopa Ireneusz W · East Troy, WIBuilt 1965 · S/N T210-0106N6707RParker David Scott Trustee · Albuquerque, NMBuilt 1965 · S/N T210-0107N6712RAero Applications Inc · Burley, IDBuilt 1966 · S/N T210-0112N6715RRose Mary R · Portland, ORBuilt 1966 · S/N T210-0115N6720RJacobsen Ian M · Lincoln City, ORBuilt 1966 · S/N T210-0120N6722BJca Aviation LLC · Safford, AZS/N 21062826N6724RDavis Lease LLC · Fort Collins, COBuilt 1966 · S/N T210-0124N6727RChase Holden · Boulder, COS/N T210-0127N6729RDfo Dynamic Aviation LLC · Glendale, AZBuilt 1966 · S/N T210-0129N6732ROregonian Flying Club · Wilmington, DEBuilt 1966 · S/N T210-0132
Back to AD 71-09-07 R1