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.

N4695LRoss Richard R · Mckinney, TXBuilt 1966 · S/N 17254690N4696LKoontz Marina M · Seattle, WABuilt 1966 · S/N 17254691N4696XAval Aviation LLC · Las Vegas, NVBuilt 1966 · S/N 15064746N4697LTverberg Justin T · Omak, WABuilt 1966 · S/N 17254692N4699FStinson Ryan · Eagle, IDBuilt 1966 · S/N P206-0299N46BCHfc Inc · Halma, MNBuilt 1967 · S/N U206-0826N46CAEnglehart James C · Marietta, GABuilt 1969 · S/N 15070135N46JWWerner John D · Pownal, VTBuilt 1969 · S/N 17257942N4700FAssociated Equip Representatives Inc · Yakima, WABuilt 1966 · S/N P206-0300N4700XCerasia Steven S · Amsterdam, NYBuilt 1966 · S/N 15064750N4704XHighsmith Michael D · Chipley, FLBuilt 1966 · S/N 15064754N4706XKey Joseph E · Eltopia, WABuilt 1966 · S/N 15064756N470RVFlyguys Aviation LLC · Bay City, MIBuilt 1968 · S/N 18259314N470XSale Reported · Priest River, IDSale reportedBuilt 1965 · S/N 18256370N4711FCharter Equine Inc · Amarillo, TXBuilt 1966 · S/N P206-0311N4712XBludorn Matthew R · Bryan, TXBuilt 1966 · S/N 15064762N4714XHoffman Zachariah M T · Glendale, AZBuilt 1966 · S/N 15064764N4715FRegistration Pending · Ukiah, CARegistration pendingBuilt 1966 · S/N P206-0315N4715XBlair Ross Iain · Milford, NJBuilt 1966 · S/N 15064765N4718FPbar Inc · Joseph, ORBuilt 1966 · S/N P206-0318N4718XRobb James W · Uhrichsville, OHBuilt 1966 · S/N 15064768N472Custer Charles D · Destin, FLS/N 205-0476N4722FStoskopf Scott W · El Dorado, KSBuilt 1966 · S/N P206-0322N4723FStraightin LLC · Paauilo, HIBuilt 1966 · S/N P206-0323N4724XFlying My Dreams LLC · Miami Gardens, FLS/N 15064774N4725FHigh Peak Air LLC · Vernal, UTBuilt 1966 · S/N P206-0325N4726XDoebler H Andrew · Myrtle Beach, SCBuilt 1966 · S/N 15064776N4727XN4727x LLC · Palmdale, CAS/N 15064777N4729WMichael J Kraynick Pllc · Hailey, IDBuilt 1965 · S/N 21058621N472BWCernek Megan Faith · Elton, LAS/N 18258970N472JSTaylor Kirk B · Houston, TXS/N 17701730N4730XDawson Allen J · Wshngtn Ct Hs, OHS/N 15064780N4734XMclennon Daniel C · Boynton Beach, FLBuilt 1966 · S/N 15064784N4738XHageness Todd A · Rugby, NDS/N 15064788N4739FEberwine David B · Lucas, TXBuilt 1966 · S/N P206-0339N4739XKimberly Jack L · Shippensburg, PABuilt 1966 · S/N 15064789N4740FSkydive Ricks LLC · Petersburg, OHBuilt 1966 · S/N P206-0340N4742XMurphy Chong Yi · Fernandina Beach, FLBuilt 1966 · S/N 15064792N4749XFlaat Stephen C · Bemidji, MNBuilt 1966 · S/N 15064799N474BFDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 18257984N4750FSouth Dakota Skydivers Inc · Sioux Falls, SDBuilt 1966 · S/N P206-0350N4750XSc Aircraft LLC · Copper Canyon, TXS/N 15064800N4753FRobertson Robin L · Murfreesboro, TNBuilt 1966 · S/N P206-0353N4753XUpstate Flying Club Inc · Marcy, NYBuilt 1966 · S/N 15064803N4757FMulcaire Jess E · Camp Verde, AZBuilt 1966 · S/N P206-0357N4757XFountain John D Jr · Lynchburg, SCBuilt 1966 · S/N 15064807N4759XBaginsky D D · Salesville, OHBuilt 1966 · S/N 15064809N475LN475l LLC · Boise, IDS/N 18259396N4762XSpatiumtech LLC · Madison, ALBuilt 1966 · S/N 15064812N4768FZankiz Jose Carlos · Naples, FLS/N P206-0368
Back to AD 72-03-03 R3