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.

N7101GBowhawk LLC · Ocala, FLBuilt 1969 · S/N 17258801N7101SCuellar Lauren · Eagle River, AKBuilt 1967 · S/N 15067801N71028Hawkins Joann L · Cupertino, CABuilt 1968 · S/N 18259462N7102GBarbosa Manuel · Apple Valley, MNBuilt 1969 · S/N 17258802N7102QJuckett Jimmy L · Springhill, LABuilt 1972 · S/N 17260402N71033Guthmiller David L · Lake Havasu City, AZBuilt 1968 · S/N 18259465N7103GMountain Flyers Inc · Hendersonville, NCBuilt 1969 · S/N 17258803N7103SHammerstrand John L · Alpine, CABuilt 1967 · S/N 15067803N71040Benegar Al · Visalia, CAS/N 18259469N71041Velez-Colon Luis X · Cibolo, TXBuilt 1968 · S/N 18259470N71045Bandstra Larry J · Heath Springs, SCBuilt 1968 · S/N 18259471N71047Lakehouse Aviation LLC · Peoria, ILBuilt 1968 · S/N 18259472N7104GAir Carriage LLC · Chico, CABuilt 1969 · S/N 17258804N7104SHelm Richard A · Buckeye, AZS/N 15067804N71050Shutt Noel M · Atascadero, CABuilt 1968 · S/N 18259473N71065Setty Matthew M · Reno, NVBuilt 1968 · S/N 18259479N71069Johnson Wayne L · Spokane, WABuilt 1968 · S/N 18259481N71070Taylor Mark R · Washington, UTBuilt 1968 · S/N 18259482N71074Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 18259484N71076Vrem Kelly L · Washington, UTBuilt 1968 · S/N 18259485N71077Duch Jose M · Miami, FLBuilt 1968 · S/N 18259486N7107FPoe John B Jr · Port Orange, FLBuilt 1966 · S/N 15063707N7107GSkyward Aviation LLC · Westborough, MABuilt 1973 · S/N 15074612N71084Mccarty Kennith E · Eagle River, AKBuilt 1968 · S/N 18259490N7108GLakes Area Aviation LLC · Little Falls, MNS/N 17258808N7108QAnderson Michael · Hillsboro, NDBuilt 1972 · S/N 17260408N7108SChapman Gary M · Sagle, IDBuilt 1967 · S/N 15067808N71099Michie Robert B · Austin, TXS/N 18259495N7109QLawless Bruce A · Lago Vista, TXBuilt 1972 · S/N 17260409N710FGKimbrell Jeffrey L · Greenville, SCBuilt 1970 · S/N 177RG0016N71107Jrf Enterprises LLC · Salem, ORS/N 18259497N7110QLawson Virgil · Sylvar Grove, KSS/N 17260410N71114Aeropaws Aviation LLC · Front Royal, VABuilt 1968 · S/N 18259499N71118Taf Aerial Services LLC · Beeville, TXS/N 18259501N71121Karmy Jeffrey R · Medford, ORBuilt 1968 · S/N 18259502N71123Debusk Eric M · Columbus, INBuilt 1968 · S/N 18259503N71124N71124 LLC · Waunakee, WIBuilt 1968 · S/N 18259504N71126Overturf Andrew · Franklin, WIBuilt 1968 · S/N 18259505N7112FHurst Richard H · Lometa, TXBuilt 1966 · S/N 15063712N7112GHooper Walter E III · Spring City, TNBuilt 1969 · S/N 17258812N7112SBridges Robert S · Friendswood, TXBuilt 1967 · S/N 15067812N71132Neale Bruce G · Joppa, ALBuilt 1968 · S/N 18259507N711333 F Aviation LLC · Norwood, LABuilt 1968 · S/N 18259508N71136Jones Harper L II · Pendleton, ORBuilt 1968 · S/N 18259509N7113QMiles Michael G · Hillsborough, NCBuilt 1972 · S/N 17260413N71149Skydive Harbor Springs Inc · Charlevoix, MIBuilt 1968 · S/N 18259511N7114FWernecke Thomas C · Southfield, MIBuilt 1966 · S/N 15063714N7114QSass Kenneth · Charlotte, NCBuilt 1972 · S/N 17260414N7115QMaggart Kenneth R · Lutz, FLBuilt 1972 · S/N 17260415N71164Core Jerry M · Bishop, CABuilt 1968 · S/N 18259516
Back to AD 72-03-03 R3