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.

N612SFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N 21061651N612WPRobert A Johnson Construction Lc · High Springs, FLBuilt 1977 · S/N 21062356N6130RHarris Phillip S · Greenwood Village, COS/N T210-0030N6131AWigen Mary E · Porthill, IDBuilt 1979 · S/N 21063508N6131RAir LLC · Salem, ORS/N T210-0031N6139BFelker Gary L · Odessa, TXBuilt 1973 · S/N 210-59909N6151RPath Barney H DBA · Claremont, CABuilt 1965 · S/N T210-0051N6151YBulloch Troy P · Cedar City, UTS/N 21064269N6152BMohave County Board Of Supervisors · Kingman, AZBuilt 1978 · S/N 21062724N6153BCenturion Southeast Management LLC · Raleigh, NCBuilt 1978 · S/N 21062696N6155YAl & Zal Corp · Wilmington, DEBuilt 1981 · S/N 21064271N6158RMahany John C · Yucca Valley, CABuilt 1965 · S/N T210-0058N6161NOn Eagles Wings LLC · Los Gatos, CABuilt 1978 · S/N 21062932N6162RSmjd LLC · Penrose, COBuilt 1965 · S/N T210-0062N6167CSnyder Larry G · Holland, NYBuilt 1979 · S/N 21063818N6168NRegistered aircraftBuilt 1978 · S/N 21062939N6170NGarmin210 LLC · Willard, MOBuilt 1978 · S/N 21062941N6170RBrown Michael R · Huntsville, ALBuilt 1965 · S/N T210-0070N6173RBeyer Livestock Auction LLC · Clovis, NMBuilt 1965 · S/N T210-0073N6174BN6174b LLC · Nokomis, FLBuilt 1978 · S/N 21062698N6175RElinoff Neal D · Telluride, COBuilt 1965 · S/N T210-0075N6176RJulius Kaleb · Mesa, COBuilt 1965 · S/N T210-0076N6180BNewton Raymond C Jr · Heath, TXBuilt 1978 · S/N 21062699N6180NMargiotta Russell A Trustee · Woodside, CABuilt 1978 · S/N 21062951N6183NLewis A Everett Jr · Chico, CAFirst renewal noticeBuilt 1978 · S/N 21062954N6184CRegistered aircraftBuilt 1979 · S/N 21063824N6185BGust William J DBA · Monument, COBuilt 1978 · S/N 21062701N6188RPeterson Bruce L · Brighton, COBuilt 1966 · S/N T210-0088N6188YLexington Enterprises Group Inc · San Jose, CABuilt 1981 · S/N 21064287N618WWood Jim · Seminole, TXBuilt 1966 · S/N P206-0218N6192NDolezal Todd R · San Luis Obispo, CABuilt 1978 · S/N 21062963N6192RAmbrosini Helicopters Inc · Fresno, CABuilt 1966 · S/N T210-0092N6192UKings Nw LLC · Lakewood, WABuilt 1979 · S/N U20605377N6195BBoyd Edward Ayres · Coronado, CABuilt 1978 · S/N 21062705N6196NMccarthy Sean P · Siloam Springs, ARBuilt 1978 · S/N 21062967N6199RSchutte Ernest C W · Abita Springs, LAS/N T210-0099N61DWZandri Stefano A · Ridgefield, CTS/N U20604257N6202BGamache Daniel S · Pleasanton, CABuilt 1978 · S/N 21062706N6209C8 Waters LLC · Goodyear, AZBuilt 1979 · S/N 21063830N6211BFleming Patrick J Trustee · Palm Desert, CABuilt 1978 · S/N 21062708N6214VRegistered aircraftBuilt 1968 · S/N U206-1189N6218YLucky Star Auto Sales Inc · Grangeville, IDBuilt 1981 · S/N 21064299N621AKelsey John · Casa Grande, AZBuilt 1980 · S/N 21064069N6223BSpirek Aaron M · Henderson, NVBuilt 1978 · S/N 21062712N6227YWest Brook Group Inc · Pleasant Hill, IABuilt 1981 · S/N 21064301N6229CClause James W Trustee · La Quinta, CABuilt 1979 · S/N 21063838N6233ZMission Aviation Fellowship · Nampa, IDBuilt 1981 · S/N U20606195N6237YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1981 · S/N 21064303N6239YBlue Horizon Aviation LLC · New Concord, OHBuilt 1981 · S/N 21064304N6240BVan Treese Farms Inc · Monte Vista, COBuilt 1978 · S/N 21062718
Back to AD 71-09-07 R1