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.

N91626Tmstar Services LLC · Lewes, DEBuilt 1969 · S/N 18259850N9163GHayssen Arthur H · Sebastopol, CABuilt 1971 · S/N 18260703N9164GZirjacks Winston L Jr · Gold River, CABuilt 1971 · S/N 18260704N91651Cain Edward A · Pembroke, MABuilt 1969 · S/N 18259856N91657Webster Max S · Dalton, PAS/N 18259858N91661James One Seventeen LLC · Fairview, OKBuilt 1969 · S/N 18259861N91667Dennis Robert · Rosamond, CAS/N 18259863N91670Sierrahotellima LLC · Farmingdale, MEBuilt 1969 · S/N 18259864N91672Baldridge Steven J · Edmonds, WAS/N 18259865N9167CNew Garden Township · Landenberg, PABuilt 1972 · S/N 15074232N9167GKgrd Aviators LLC · Greenwood, SCBuilt 1971 · S/N 18260707N91680Kay Scott Aviation Insurance Inc · Reno, NVBuilt 1969 · S/N 18259869N9168GClark Byron · Olympia, WABuilt 1971 · S/N 18260708N91690Walker Curtis N · Phoenix, AZBuilt 1969 · S/N 18259872N91691Stumm Robert W · Cadott, WIBuilt 1969 · S/N 18259873N91699Caughlan Cody P · Santa Cruz, CABuilt 1969 · S/N 18259875N9169GDodson International Parts Inc · Rantoul, KSBuilt 1971 · S/N 18260709N916ACYr-Aircraft Leasing LLC · Bethel, AKBuilt 1979 · S/N 20700061N916CLDolphin Sales Inc · Wilkes Barre, PABuilt 1975 · S/N 17702273N916MHHelmerich Jonathan D Jr · Tulsa, OKBuilt 1969 · S/N 17258177N916PYBragg Kris M · Embden, MEBuilt 1968 · S/N 17257159N91705Gerbick Dean · Lena, ILBuilt 1969 · S/N 18259878N91718Miklos Russ · Youngstown, OHBuilt 1969 · S/N 18259882N91721Scott Dennis E · Wake Forest, NCBuilt 1969 · S/N 18259883N91722Ken-Oh Transportation LLC · Porter, INBuilt 1969 · S/N 18259884N91726Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1969 · S/N 18259886N91730Meints Larry W · Altahoma, CABuilt 1969 · S/N 18259887N91748Ad Venture Sales LLC · Wilmington, DEBuilt 1969 · S/N 18259890N91749Skydive Northstar LLC · Mankato, MNBuilt 1969 · S/N 18259891N9174GSmith Daniel · Whittier, NCBuilt 1971 · S/N 18260714N91753Pope Lucas B · Hayden, IDBuilt 1969 · S/N 18259894N91759Parker Michael F · Leesburg, VAS/N 18259895N91767Mcclary Guy E Jr · Darlington, SCBuilt 1969 · S/N 18259899N91771Whitt Horace M · Edgewood, NMBuilt 1969 · S/N 18259900N91775Kcsi Aerial Patrol Inc · Bakersfield, CAS/N 18259902N91789Bell Barbara A · Gilbert, AZBuilt 1969 · S/N 18259907N91790Hill Benjamin L · Hollywood, FLBuilt 1969 · S/N 18259908N91791Cessna N91791 Inc · Saginaw, MIS/N 18259909N91795Avco Patrol LLC · Lyndon, KSBuilt 1969 · S/N 18259912N91799Turner Ryan J · Pittsburg, TXBuilt 1969 · S/N 18259915N917GJHawdon Neil John · Federal Way, WAS/N 17702703N917HSJpm Aircraft Leasing LLC · Wilmington, DEBuilt 1962 · S/N 18253933N917WETaylor William H II · Albuquerque, NMBuilt 1968 · S/N 17256920N917ZXD & S Flyers LLC · Portage, MIS/N 17253276N91802Jones Bernard H Jr · Pendleton, SCBuilt 1969 · S/N 18259916N91803Legacy 1 Aviation LLC · Canton, OHBuilt 1969 · S/N 18259917N91804Dreau Air LLC · Flandreau, SDBuilt 1969 · S/N 18259918N91816Garrett Douglas D · Granbury, TXBuilt 1969 · S/N 18259921N9182GPetersen Danny S · Caddo, OKBuilt 1971 · S/N 18260722N91831Sides Matthew E · Lonoke, ARBuilt 1969 · S/N 18259926
Back to AD 72-03-03 R3