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.

N9371SRiley Loy D · Charlton, MABuilt 1975 · S/N MC-364N9373SCentral Vermont Flying Club Inc · Williston, VTBuilt 1975 · S/N MC-367N944VCoastal 944v LLC · Wilmington, NCBuilt 1975 · S/N M-1662N9700LJet Aviation LLC · Commerce Township, MIBuilt 1971 · S/N MB-506N9705LDavis James A · Rockledge, FLS/N M-1324N9705QSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N MC-61N9706LMoore Matthew W · Wichita, KSBuilt 1971 · S/N MC-95N9707LGriffith Jonathan E · Newark, NJBuilt 1971 · S/N MC-96N9709QRobles Andres M · Plantation, FLBuilt 1970 · S/N MB-494N9710QBluesky A24r LLC · Nashville, TNBuilt 1970 · S/N MC-66N9713YEsteban Rioufol Peralta · Houston, TXBuilt 1976 · S/N MC-396N9714LWebaire LLC · Slidell, LABuilt 1971 · S/N MB-510N9716LOettmeier Bert W Jr Trustee · Leawood, KSBuilt 1971 · S/N MC-98N9717LLane Timothy J · Ruffin, SCBuilt 1971 · S/N M-1352N9718LStucky Verne L · Royal Oaks, CABuilt 1971 · S/N MB-511N9718QRedfield Nathan S · Canton, MSBuilt 1971 · S/N MC-73N9724LBarlam Theodore P · Poway, CABuilt 1972 · S/N MC-101N9724QRegistered aircraftBuilt 1970 · S/N M-1306N9725LLeading Edge Aviation LLC · Manchester, MOS/N MB-515N9727LWiseman Holdings Group LLC · Clermont, FLBuilt 1971 · S/N MB-521N9729LStephen Christina J · Shreveport, LAS/N M-1356N9730LSundowner N9730l LLC · Calhoun, GABuilt 1971 · S/N M-1357N9730QWheat Land Aviation LLC · Andover, KSBuilt 1971 · S/N MC-82N9731LMaine Instrument Flight · Augusta, MEBuilt 1971 · S/N M-1358N9736QGregory Charlie E · Blairsville, GABuilt 1971 · S/N MC-88N9737LSzish Michael · Mountain Top, PABuilt 1972 · S/N MB-524N9737QSierra Tn Aviation LLC · Vonore, TNBuilt 1971 · S/N MC-89N9742QMese Jacob L · Savannah, GABuilt 1971 · S/N M-1313N9743LSundowner Rental Options LLC · Lawrenceville, GABuilt 1971 · S/N M-1371N9744QLong Richard · Sebastopol, CABuilt 1970 · S/N M-1314N9746QJones Rea V · Maple, NCBuilt 1971 · S/N MC-93N9748QSchwanke Timothy Michael · Enid, OKBuilt 1971 · S/N MB-522N9749QKyle Edwards LLC · Seneca, SCBuilt 1971 · S/N M-1363N9752LHickox Richard E · Las Cruces, NMBuilt 1971 · S/N MC-102N9755LClendenen William M · Spencer, TNBuilt 1975 · S/N MC-104N9757LGasper Joseph · New Port Richey, FLBuilt 1972 · S/N M-1378N9765LMartone Aviation LLC · Ocala, FLBuilt 1972 · S/N M-1383N9771LLarson Steven E · Columbus, NEBuilt 1972 · S/N M-1402N9775LLassiter Jason T DBA · Ephrata, PABuilt 1972 · S/N M-1391N9777LEarl W Morrow Cpa Pe · Williamson, GAFirst renewal noticeBuilt 1972 · S/N M-1392N9780LPatterson John M · Elkton, FLBuilt 1972 · S/N MC-113N9782LConnolly David · Austin, TXBuilt 1972 · S/N M-1393N9783LBeck Joseph P III · Pollock, LABuilt 1972 · S/N M-1394N9788LKluge Andrew J · Colorado Springs, COBuilt 1972 · S/N MC-116N9789LGraham Michael · Fayetteville, GABuilt 1973 · S/N MC-115N98339Carlson Jeremy · Yucaipa, CABuilt 1968 · S/N MA297N999EMOombu LLC · Round Rock, TXBuilt 1964 · S/N M-552N999NWBoss Gary W · Bronston, KYBuilt 1969 · S/N M-1243
Back to AD 73-20-07 R2