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.

N8699GFayette Aviation Inc · Lemont Furnace, PABuilt 1966 · S/N 15062799N8699ZEdaero LLC · Bangor, MEBuilt 1968 · S/N P206-0499N869JRRiver City Flying Club · Glen Allen, VABuilt 1968 · S/N 18259441N86DBMchugh John J · Camano Island, WABuilt 1970 · S/N 17259123N86WAWyatt David M · Kennewick, WAS/N 15070812N8701SRoth David A · Milford, NEBuilt 1965 · S/N 15062001N8702GHaney James H · Brooksville, FLBuilt 1966 · S/N 15062802N8703UNea Construction LLC · Jonesboro, ARBuilt 1965 · S/N 17252607N8703ZLynch Cody Ryan · Galveston, TXBuilt 1968 · S/N P206-0503N8704ZHunt David H · Ortonville, MIBuilt 1968 · S/N P206-0504N8705GHammond Douglas C · Des Moines, IABuilt 1966 · S/N 15062805N8706SN8706s LLC · Lake Orion, MIBuilt 1965 · S/N 15062006N8706ZElliott Michael L · Raeford, NCBuilt 1968 · S/N P206-0506N8708SHall Tyler D · Citrus Heights, CAS/N 15062008N8708UDewey William H Trustee · Eugene, ORBuilt 1965 · S/N 17252612N8709UWilkinson James Richard · Carlsbad, NMBuilt 1965 · S/N 17252613N8710SKressin Ray H · Waunakee, WIBuilt 1965 · S/N 15062010N8710UDmac Aircraft LLC · Savannah, GABuilt 1965 · S/N 17252614N8711GBonno Douglas L · Iron River, MIBuilt 1966 · S/N 15062811N8711ZNeff John Sr · Lumberton, TXBuilt 1968 · S/N P206-0511N8712SMarys Airport Acres LLC · Neenah, WIBuilt 1965 · S/N 15062012N8715SAllen Thomas Page · Comer, GABuilt 1965 · S/N 15062015N8715ZMarconi Joseph · Hamilton, OHBuilt 1968 · S/N P206-0515N8716SBores Scott J · Huron, OHS/N 15062016N8716UWings Of Hope · Chesterfield, MOBuilt 1965 · S/N 17252620N8718UPuckett Matthew Scott · Argyle, TXBuilt 1965 · S/N 17252622N8719GRosso Anthony J · Wallace, NCS/N 15062819N8719ZFedane Rohit · Green Bay, WIBuilt 1968 · S/N P206-0519N8721SPruden Larry J · Louise, MSBuilt 1965 · S/N 15062021N8722UBrown Stephen L · Charlotte, MIBuilt 1965 · S/N 172-52626N8723GEastham Gregory L · Columbia, KYBuilt 1966 · S/N 15062823N8723SCondor Aviation LLC · South Saint Paul, MNBuilt 1965 · S/N 15062023N8723UTraining Services Inc T/A · Virginia Beach, VABuilt 1965 · S/N 17252627N8725SKolis Joseph E II · Springfield, ILBuilt 1965 · S/N 15062025N8725UArklamiss Aviation LLC · Ruston, LABuilt 1965 · S/N 17252629N8725ZRomine George · Tucson, AZBuilt 1968 · S/N P206-0525N8726GJacks Benjamin Scott · Chanute, KSBuilt 1966 · S/N 15062826N8726UHowell Harley L · Colville, WAS/N 17252630N8727GJstream Lc · Sheridan, WYBuilt 1966 · S/N 15062827N8727SMejia Jose Patricio · Meridian, IDBuilt 1965 · S/N 15062027N8727ZRobertson Reuben · Johnson City, TNBuilt 1968 · S/N P206-0527N8729UEpmeier Bruce E · Newburgh, INBuilt 1965 · S/N 17252633N8730SDederer Laura · Valencia, PAS/N 15062030N8730ZKalderen Bjorn O · South Orange, NJBuilt 1978 · S/N 177RG1338N8731GCard James D · Mc Cool, MSBuilt 1966 · S/N 15062831N8731SLawrenz Richard A · Mcpherson, KSS/N 15062031N8732GPerkins Robert A · New Richmond, WIBuilt 1966 · S/N 15062832N8732UHumke John D · Eufaula, OKS/N 17252636N8732ZZiprik Russell L · Ball Ground, GABuilt 1968 · S/N P206-0532N8733ZTerway William · Wilsonville, ORBuilt 1968 · S/N P206-0533
Back to AD 72-03-03 R3