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.

N8633JHise Mark J · Nolensville, TNBuilt 1967 · S/N 15066533N8633SUhler John A · Rimrock, AZBuilt 1965 · S/N 15061933N8634GRegistration Pending · Princeton, MARegistration pendingBuilt 1966 · S/N 15062734N8634JDestination 55 LLC · Cave Springs, ARBuilt 1967 · S/N 15066534N8634SHersom Jeffrey T · Helena, MTBuilt 1965 · S/N 15061934N8635GSmith Andrew W · Willow, AKBuilt 1965 · S/N 15062735N8635SWood Timothy M · Jefferson, MES/N 15061935N8635ZLipper Stephen W · Griffin, GAFirst renewal noticeBuilt 1967 · S/N P206-0435N8636UMls Holdings · Newbury Park, CABuilt 1965 · S/N 17252538N8637GReichenbach Louis · Northville, MIBuilt 1966 · S/N 15062737N8638SLyon Ronald C · Berlin, VTBuilt 1965 · S/N 15061938N8638ULittle Kenneth C · Driggs, IDBuilt 1965 · S/N 17252540N8638ZEichman David A · Topeka, KSBuilt 1967 · S/N P206-0438N8639GRegistered aircraftBuilt 1966 · S/N 15062739N8640GRoss Peter W · Lufkin, TXBuilt 1965 · S/N 15062740N8640USunnyside Aviation Pllc · Theodosia, MOBuilt 1965 · S/N 17252542N8641SSimmons Anthony C Jr · Allendale, SCBuilt 1965 · S/N 15061941N8641UJohnson Jay A · Lisbon, IABuilt 1965 · S/N 17252543N8643ZVitatoe Industries Inc · Chillicothe, OHBuilt 1967 · S/N P206-0443N8644GMelin Jeff C · Kenmare, NDBuilt 1965 · S/N 15062744N8644SRiggan Charles H · Oxford, NCBuilt 1965 · S/N 15061944N8644UFung Tak C · Ridge, NYBuilt 1965 · S/N 17252546N8644ZMasters Mission · Nenana, AKBuilt 1967 · S/N P206-0444N8646SFoster Brian E · Bartley, NEBuilt 1965 · S/N 15061946N8648GAugust Aero LLC · Kalispell, MTS/N 15066728N8648SSnodgrass Gavin I · Belle, MOS/N 15061948N8649GMullins Steve F · Belews Creek, NCBuilt 1965 · S/N 15062749N8649SGuffey Edward B · Bessemer City, NCBuilt 1965 · S/N 15061949N864TGTouch N Go Aeroworks LLC · Greenville, SCS/N 15068527N8650SGrant Clinton A Trustee · Portage Des Sioux, MOS/N 15061950N8650ZBarry Russell L · Fort Mohave, AZBuilt 1967 · S/N P206-0450N8652SKindel Michael W · Bismarck, NDS/N 15061952N8653GArmstrong John K · Lovington, NMS/N 15062753N8653UCurtis Heather · Fairbanks, AKBuilt 1965 · S/N 17252555N8654UThompson George C · Rogersville, ALBuilt 1965 · S/N 17252556N8656JMeyer Eric Trustee · Moscow, IDBuilt 1967 · S/N 15066556N8657GClayton Patrick D · Hazen, ARS/N 15062757N8657JCompany Air LLC · Bermuda Dunes, CABuilt 1967 · S/N 15066557N8657URidley Timothy A · Uniontown, PABuilt 1965 · S/N 17252559N8658GWestrum Sean Ross · Norwalk, IAS/N 15062758N8658SBird Jared N · Mission, TXBuilt 1965 · S/N 15061958N8659GCoker Jason John · Caribou, MEBuilt 1966 · S/N 15062759N8659JThomas Chase D · White Oak, TXBuilt 1967 · S/N 15066559N8659SRegistration Pending · Davenport, FLRegistration pendingBuilt 1965 · S/N 15061959N865PHPhe Inc · Roseville, CABuilt 1968 · S/N 18259353N8660SDepaula Saulo C T · Princeton, MAS/N 15061960N8660USage Point Ventures LLC · New Harmony, UTS/N 17252562N8661JSaa Enrique A · Lubbock, TXBuilt 1967 · S/N 15066561N8661UBaird Adam D · Salisbury, NCBuilt 1965 · S/N 17252564N8662SRegistration Pending · Lynchburg, VARegistration pendingBuilt 1965 · S/N 15061962
Back to AD 72-03-03 R3