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.

N8871GHukill Warren J · Oakland, CABuilt 1966 · S/N 15062971N8871UWichmann William C · Owasso, OKBuilt 1965 · S/N 17252787N8872GN8872g Holdings LLC · Nashville, TNBuilt 1966 · S/N 15062972N8872SAeronautical Technical Service Inc · Collierville, TNS/N 15062172N8873GHarris David J · Aguila, AZBuilt 1966 · S/N 15062973N8873UOlafsen George F · Greeneville, TNBuilt 1965 · S/N 17252789N8874GEluwawalage Damayanthie · Reading, PABuilt 1966 · S/N 15062974N88778Hubbard Austin L · Somerton, AZS/N R172-0128N88779Drexler Daniel L · Harrison, TNS/N R1720132N8877USmith Stephen A · Aloha, ORBuilt 1965 · S/N 17252794N887PBZankiz Jose Carlos · Naples, FLBuilt 1968 · S/N U206-1062N8882GSchauer Tad J · Lake Park, MNS/N 15062982N8882SHudson Willis · Hendersonville, NCBuilt 1965 · S/N 15062182N8883GPalacios David J · Yucca Valley, CABuilt 1966 · S/N 15062983N8884SMechin Jean-Michel S · Gardiner, NYBuilt 1965 · S/N 15062184N8885GGurley George R · Caledonia, MSBuilt 1966 · S/N 15062985N8888URomano Michael A · Fresno, CABuilt 1965 · S/N 17252807N8889UJennings Chadwick B · Reno, NVBuilt 1965 · S/N 17252808N888HHanley Michael · Paw Paw, MIBuilt 1966 · S/N 17254395N888TBBlock Scott · Chandler, AZFirst renewal noticeBuilt 1969 · S/N 17257895N888VMDaniels Michael R · Mc Donald, PABuilt 1973 · S/N 17702021N8890SPower Gale W · Girdwood, AKBuilt 1965 · S/N 15062190N8891GShort James B · Crown Point, INBuilt 1966 · S/N 15062991N8891SDahlen James T · Chester, MTS/N 15062191N8891UMcdonald Brince R · Lonoke, ARS/N 17252810N8892GMcnamee Paul J · Roseville, MNS/N 15062992N8893GTurner Timothy D · Bonneau, SCBuilt 1966 · S/N 15062993N8894SArmstrong Richard R · Port Crane, NYBuilt 1965 · S/N 15062194N8895SSyverson Kylie E · Prescott, WIBuilt 1966 · S/N 15062195N8896SWombles Earnest · Knoxville, TNBuilt 1965 · S/N 15062196N8897GShore Gerry · Inez, TXBuilt 1966 · S/N 15062997N8897STutak Peter B · Indianapolis, INFirst renewal noticeS/N 15062197N8899UYoon Kerry D · Franklin, TNBuilt 1965 · S/N 17252820N889ESDalissandro Michael Douglas · Hampton, NHBuilt 1970 · S/N 18260448N88BLBrewer Jim L · Loco, OKS/N 206-0118N88GMField Drew H · Dallas, TXBuilt 1972 · S/N 150-73318N88HSShields Edwin G · York, SCBuilt 1968 · S/N 15069271N88KMTsukii Toshikazu · Tucson, AZBuilt 1977 · S/N 177RG1181N88KNRegistration Pending · Santa Rosa, CARegistration pendingBuilt 1966 · S/N 15065181N88KWDonnell James C · Crowville, LABuilt 1966 · S/N 17254367N88NGBakke Dale W · Yankton, SDBuilt 1977 · S/N 177RG1223N88PKGray Farms Inc · Albany, ORBuilt 1971 · S/N 18260772N88RKJkg LLC · Idaho Falls, IDBuilt 1966 · S/N 18256967N88SYYamashita Bruce · Honolulu, HIBuilt 1969 · S/N 17258613N8906SHoskins Brent E · Caldwell, IDBuilt 1965 · S/N 15062206N8907GInfinity Aviation · Pine Island, MNBuilt 1970 · S/N 18260447N890PGCp Air LLC · Indianapolis, INBuilt 1965 · S/N 17253864N8911SPriglmeier Mark L · Deerwood, MNBuilt 1965 · S/N 15062211N8914SCarroll Louis · Perris, CABuilt 1965 · S/N 15062214N8915GFerdon Richard P Trustee · Fort Mohave, AZBuilt 1970 · S/N 18260455
Back to AD 72-03-03 R3