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.

N22902Easterling William R · Pikeville, NCBuilt 1968 · S/N 15068603N22903Walther Newell A · Wasilla, AKBuilt 1968 · S/N 15068604N2290YHerren Roger L · Clayton, ILBuilt 1967 · S/N 17700090N22915Sprankle Gerard · Fairbanks, AKS/N 15068613N22919Brozzo Ralph · St Johns, FLBuilt 1968 · S/N 15068614N2291YWyatt Gary D · Sun City West, AZBuilt 1967 · S/N 17700091N22920Jackson Kenneth R · Stephenville, TXS/N 15068615N22921Sakry Robert J · Saint Joseph, MNBuilt 1968 · S/N 15068616N22924Hirkala Ronald R · Weirton, WVBuilt 1968 · S/N 15068618N22926Gossett Rita M · Granbury, TXBuilt 1968 · S/N 15068619N22927Hamilton Gregory J · Avon Lake, OHBuilt 1968 · S/N 15068620N2292YJess Lawrence A · Menomonie, WIBuilt 1967 · S/N 17700092N22935Tift Aviation LLC · Tifton, GABuilt 1968 · S/N 15068627N2294YHeathfield William T · Plymouth, MIFirst renewal noticeS/N 17700094N22956Thyfault Raymond E · Mattawan, MIS/N 15068643N2295JPloyhart Edwin J · Harwood, NDBuilt 1966 · S/N 15065495N2295RDuhl James R · Roseville, MNFirst renewal noticeBuilt 1969 · S/N T210-0445N2295YHutto Azel James III · Lexington, SCBuilt 1967 · S/N 17700095N22963Swift John S · Santa Barbara, CAS/N 15068646N2296RCelias Food Corp · Miami, FLS/N T210-0446N22970Kingdom Air Corps · Sutton, AKBuilt 1968 · S/N 15068651N2297YKomulainen Daryl B · Clarksville, TNBuilt 1967 · S/N 17700097N22980Salt City Aviation LLC · Hutchinson, KSBuilt 1968 · S/N 15068656N22988Runyon James R · Entiat, WABuilt 1968 · S/N 15068664N2298JRoth Mark E · Stevensville, MTBuilt 1966 · S/N 15065498N22990Peterson Curtis L · Smith Center, KSBuilt 1968 · S/N 15068665N22991Dan Munson Consulting Pllc · Seneca, SCBuilt 1968 · S/N 15068666N22998N22998 LLC · Middletown, DES/N 15068670N2299JMclaughlin Edward T · Silverdale, WAS/N 15065499N2299RBaer Monte Wayne · Ronan, MTS/N T210-0449N229CN229c LLC · Holt, MOFirst renewal noticeBuilt 1965 · S/N 18256129N22BZ8k Investments LLC Series Cessna 150 · Perryton, TXBuilt 1968 · S/N 15068198N22DECrawford Edgar A · Locust Grove, GABuilt 1970 · S/N 17259168N22MDewitt Josiah · Renton, WABuilt 1962 · S/N 18253788N22SDGordon Scott K Trustee · Tucson, AZBuilt 1968 · S/N 17700892N23001Henshaw Edward C · Vian, OKBuilt 1968 · S/N 15068672N23009Hopkins Francis · Wilmington, DEBuilt 1968 · S/N 15068675N23012De La Fuente Carlo H · Lompoc, CAS/N 15068676N23015Schalk Rudolph A · Morgan Hill, CABuilt 1968 · S/N 15068678N23017Kopacz Keith P · Saint Thomas, VIS/N 15068680N23018Andrews University · Berrien Springs, MIBuilt 1968 · S/N 15068681N2301XPetritsch Ryan · Warrington, PABuilt 1965 · S/N 18256201N23025John R Roberts Jr · Homestead, FLBuilt 1968 · S/N 15068686N23027Stapleton Jerry L · Jacksonville, FLBuilt 1968 · S/N 15068687N2302RNitz Michael W · Volente, TXBuilt 1964 · S/N 18255402N2302XSedation Vacation Pllc · Dalton, GABuilt 1965 · S/N 18256202N2303RRosborough Todd D · Medford, ORBuilt 1964 · S/N 18255403N23046Thomas Jaclyn L · Carrollton, OHBuilt 1968 · S/N 15068697N2304XAbel Van A · Wichita, KSBuilt 1965 · S/N 18256204N23051Gradle Roger Thomas · Fairhope, ALS/N 15068700
Back to AD 72-03-03 R3