OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,028

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-03-03-R3')
    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-03-03-R3')
  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.

N79431Brown Joshua W · Pomona, ILBuilt 1969 · S/N 17258080N79432N7037g Inc · Wilmington, DEBuilt 1969 · S/N 17258081N79434Gilpin Jeffrey · Portland, ORBuilt 1969 · S/N 17258083N79435Pearce Gregory W · Eagle River, AKBuilt 1969 · S/N 17258084N79436Granskog Gary L · Chico, CABuilt 1969 · S/N 17258085N7943FRegistered aircraftBuilt 1966 · S/N 15064043N79440Spatiumtech LLC · Madison, ALBuilt 1969 · S/N 17258089N79442Friedmann David · San Diego, CABuilt 1969 · S/N 17258091N79445Raniolo James · Jackson, WYBuilt 1969 · S/N 17258094N79447Aroostook Aviation LLC · Millinocket, MEBuilt 1969 · S/N 17258096N79448Thomas William B · Converse, LABuilt 1969 · S/N 17258097N7944FBrown R Ed · Vandalia, ILS/N 15064044N7944GBogardus Peter S · Gouverneur, NYBuilt 1970 · S/N 17259644N79450Smith Jeff C · Cincinnati, OHBuilt 1969 · S/N 17258099N79453Zimmer James E · Corning, CABuilt 1969 · S/N 17258101N79454Gavranovic Willie · Wharton, TXBuilt 1969 · S/N 17258102N7945GWinger Matthew · Vail, AZS/N 17259645N79468Whitmire Alan K · Canyon Lake, TXS/N 17258113N7946FPaul Paulson A · Kipnuk, AKBuilt 1966 · S/N 15064046N7946GRegistration Pending · Beach City, TXRegistration pendingBuilt 1970 · S/N 17259646N7946UUpper Aircraft International LLC · Titusville, FLBuilt 1964 · S/N 17251946N79472Frey Michael L III · Waco, TXBuilt 1969 · S/N 17258115N79473Tnw Aviation LLC · Clinton, ARS/N 17258116N79475Registered aircraftBuilt 1969 · S/N 17258118N79477Shipley David L · Yates City, ILBuilt 1969 · S/N 17258120N79478Fusano Lisa A · La Crescenta, CAS/N 17258121N79479Larue Mark C · Leander, TXBuilt 1969 · S/N 17258122N7947GStearman Field Aircraft Repair LLC · Benton, KSBuilt 1970 · S/N 17259647N79482Matacotta Ernest A · Marietta, GABuilt 1969 · S/N 17258123N79488Nevels Steven D · Merritt Island, FLBuilt 1969 · S/N 17258126N79489Maisonet Gonzalez Hector W · Ocala, FLBuilt 1969 · S/N 17258127N79493Bounds Trucking LLC · Faison, NCS/N 17258130N79498Gord James F · Sandwich, ILBuilt 1969 · S/N 17258132N79499Johnson Benjamin M · Monroe, WIBuilt 1969 · S/N 17258133N7949FMaciol Michael W M D · Pelham, NYBuilt 1973 · S/N A1500452N794CTCarolina Custom Farm Equipment LLC · Wilson, NCBuilt 1965 · S/N 17252598N79501Skyhawk Flying Club Inc · Omaha, NEBuilt 1969 · S/N 17258134N79506Allen Michelle E · Sebastopol, CABuilt 1969 · S/N 17258138N7950GRotormate LLC · Royse City, TXBuilt 1970 · S/N 17259650N7950UBowden James E Jr · Eufaula, ALS/N 17251950N79513Kalman Engineering Inc · Pekin, ILBuilt 1969 · S/N 17258142N7951URegistration Pending · New Smyrna Beach, FLRegistration pendingS/N 17251951N79526Evink Bradley D · North Branch, MNBuilt 1969 · S/N 17258151N79529Elliott Tina L · Tucson, AZBuilt 1969 · S/N 17258154N7952FKagey Ryan D · Seabrook, TXBuilt 1966 · S/N 15064052N7952GPlunkett Charles K E · Eagle Point, ORS/N 15074743N7952UTigger II Airways LLC · Towson, MDBuilt 1964 · S/N 17251952N79531Newberry Tyler D · Clovis, CABuilt 1969 · S/N 17258155N79533Eby William J · Sugar Grove, ILBuilt 1969 · S/N 17258156N7953GSnyder Kenneth C · Lonsdale, MNBuilt 1973 · S/N 15074744
Back to AD 72-03-03 R3