OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,027

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.

N4086JBell Robert A Jr · Scotland Neck, NCBuilt 1966 · S/N 15065386N4088JLampasona Brendan T · Citrus Springs, FLBuilt 1966 · S/N 15065388N4093JGarcia Joseph Donald · Okeana, OHS/N 15065393N4094JSquires Janis R · Amherst, OHBuilt 1966 · S/N 15065394N4095JParks Richard C · Salem, MOBuilt 1966 · S/N 15065395N4098JFrench Darrell L · Easton, MDS/N 15065398N409SPTzerefos Lambros P · Mathews, VAS/N 177RG0493N40AESchwartz Michael · Missoula, MTBuilt 1964 · S/N 18255664N40ECHill Richard C · Buckeye, AZS/N 18256692N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309N40RBKmg Aviation Holdings LLC · Hartville, OHBuilt 1976 · S/N 177RG1071N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829N4103A501st Flight Solutions LLC · Kaysville, UTBuilt 1966 · S/N 15063859N4106LHackens Bryan Jay · New Underwood, SDBuilt 1966 · S/N 17254175N4107LRobitaille Charles · Stephenville, TXS/N 17254176N4108LCriss Mark · Eaton Rapids, MIBuilt 1966 · S/N 17254177N4109LMarrian Jason · Westtown, NYBuilt 1966 · S/N 17254178N410EKGandy Donald T · Weatherford, TXBuilt 1976 · S/N 17702536N410MJSnuggs Jason M · Gainesville, TXBuilt 1969 · S/N 18259784N4110LNeu Aviation LLC · Benton, LABuilt 1966 · S/N 17254179N41130Chapa Jana K · Corpus Christi, TXS/N 18255794N4114LLarson Lynn R · Casselton, NDBuilt 1966 · S/N 17254183N4115FHogan Darrel R · Ash Grove, MOBuilt 1972 · S/N 15074003N4115LPierce Michael W · Leitchfield, KYBuilt 1966 · S/N 17254184N4116LHubbard Matt · Phoenix, AZBuilt 1966 · S/N 17254185N4117LPatrick Milan Jr · Shinnston, WVBuilt 1966 · S/N 17254186N4118LUan Venture Partners LLC · Odessa, FLBuilt 1966 · S/N 17254187N4119LSugar Aircraft LLC · Oak Harbor, WAS/N 17254188N411DKSwaz Aviation LLC · Mesa, AZS/N 17260703N411KMRowe Kieth C · Big Bear Lake, CABuilt 1963 · S/N 18255034N411RFFoothill Aircraft Sales & Service Inc · Upland, CAS/N 17252216N411TABenz Christopher · Seattle, WABuilt 1968 · S/N R172-0196N4125LEvans Samuel F · Selma, ALS/N 17254194N4126LBritton Jeff J · Forest Falls, CABuilt 1966 · S/N 17254195N4126PPorebski Peter T · New Port Richey, FLBuilt 1975 · S/N 17702320N4127LHoldt Farms Inc · Elgin, NEBuilt 1966 · S/N 17254196N4129LIrwin Kristin L · Emporia, KSS/N 17254198N412CDOppegard Nicholas D · Eagle River, AKBuilt 1967 · S/N 15067488N412WSArnold Jerry W · Lincoln, NEBuilt 1970 · S/N 17701475N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310N4134LMountain View Aviation Inc · Cedar Bluff, VABuilt 1966 · S/N 17254203N4135LHudson Kimmine · Erie, COBuilt 1966 · S/N 17254204N4136LDickerson Richard L · Fort Worth, TXBuilt 1966 · S/N 17254205N4141LPeder Richard A · Sequim, WABuilt 1966 · S/N 17254210N4142LSegura Michelle Marie · Dallas, TXBuilt 1966 · S/N 17254211N4149LRegistration Pending · Bryan, OHRegistration pendingS/N 17254218N4150LBlankenship Daniel S · Paso Robles, CABuilt 1966 · S/N 17254219N4151LPardun Phillip R · Mason City, IABuilt 1966 · S/N 17254220N4152LLambert Robert · Paoli, INBuilt 1966 · S/N 17254221N4156LZimmer Marc R · Moses Lake, WABuilt 1966 · S/N 17254225
Back to AD 72-03-03 R3