OpenAirDocs.org
AD 73-20-07 R2

Registered aircraft · 1,348

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:73-20-07-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-20-07-R2')
  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.

N4747JKavie Andrew J · Blaine, MNBuilt 1967 · S/N M-1019N4753JTiki Aerospace LLC · Saint Petersburg, FLBuilt 1967 · S/N MB-197N4754JDevendorf Donald A Jr · Prescott, AZBuilt 1967 · S/N MB-201N4756JEhling Joseph P · Snohomish, WABuilt 1967 · S/N MB-203N4758JFardell Christopher J · Gilbert, AZBuilt 1967 · S/N MA-186N4759JPersons Jonathan B · Eagan, MNBuilt 1967 · S/N MA-187N4760JSoety Kelly M · Corry, PABuilt 1967 · S/N M-1021N4765JHall Jarrod L · Eufaula, OKBuilt 1967 · S/N MB-204N4771JAsx Flight Services LLC · Ashland, WIBuilt 1967 · S/N MB-207N4774JAlbin John B · Milan, MIBuilt 1967 · S/N MA-192N4776JKimbrough Paul E · Millcreek, UTBuilt 1967 · S/N MB-221N4777JHowell Michael A · Parsons, KSBuilt 1967 · S/N MB-224N4780JItzchak Arzt · Sarasota, FLBuilt 1967 · S/N MB-228N4781JWyatt Steven Joseph · Caddo Mills, TXBuilt 1967 · S/N MB-231N4784JSale Reported · Crystal, MNSale reportedBuilt 1967 · S/N MB-220N4789JChenault Mitchell Ray · Renton, WABuilt 1967 · S/N MA-209N4793JSheco Inc · Aloha, ORBuilt 1967 · S/N MA-199N4797JMalnar George A · Tickfaw, LAS/N M-1029N4799JCampbell Cliff H · Coleman, TXBuilt 1967 · S/N M-1031N491PDAir Ventures Awaits LLC · Middletown, DEBuilt 1974 · S/N M-1574N4LVInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N MC-86N4TC14tz LLC · Geneva, FLBuilt 1966 · S/N MA-9N5012MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-882N501AHOlah Gregory J · High Point, NCBuilt 1966 · S/N MB-80N5032MLet There Be Flight LLC · Portage, MIBuilt 1978 · S/N MB-896N5040MHulme Aviation LLC · Gilbert, AZBuilt 1978 · S/N MB-895N5074MFaddis Ray K · Kingwood, TXBuilt 1978 · S/N M-2051N5074TPate Michael G · Pontotoc, MSS/N MA-322N5076TDriffill Leroy R · Antonito, COS/N MA-324N5077TBerg Sanford B · Lakeville, MNBuilt 1968 · S/N MA-325N5088TCox Stephen T · Fairborn, OHBuilt 1968 · S/N MB-343N508MARms Beach Sierra LLC · Brownsville, TXBuilt 1975 · S/N MC-318N5090TWoodcox Edmund A · West Monroe, NYBuilt 1968 · S/N MB-346N5092MZavalney Steven Michael · Canyon, TXBuilt 1978 · S/N MB-891N5092TZigo Daniel N · Madill, OKBuilt 1968 · S/N MB-347N5093TTaylor Allen S · Oak Harbor, WABuilt 1968 · S/N MB-378N5094TKrass Roman · West Hills, CAS/N M-1137N5095TColter Duane E · Plainfield, INBuilt 1968 · S/N M-1138N5099MBufo David · Los Osos, CABuilt 1978 · S/N M-2028N50GDTranguch John M · Beaver Meadows, PABuilt 1966 · S/N MA-128N50TMRegistration Pending · Williamson, WVRegistration pendingBuilt 1972 · S/N MB-552N5101MCarlson Noah · Seattle, WAS/N M-2033N5101RVan Steenis William W · Boulder City, NVS/N MB-788N5102MRegistration Pending · West Melbourne, FLRegistration pendingBuilt 1978 · S/N M-2032N5105RSale Reported · Colville, WASale reportedBuilt 1974 · S/N MB-639N5106RBenson Robert W · Wichita Falls, TXS/N MB-640N5107MBahus Jason · La Porte, INBuilt 1978 · S/N M-2027N5111RAlpine Aviation LLC · Oasis, IDBuilt 1974 · S/N MB-645N5113RHamaker Nevada C · Bothell, WABuilt 1974 · S/N MB-647N5114RHayden Steven E · Westminster, COBuilt 1974 · S/N MB-648
Back to AD 73-20-07 R2