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.

N7129FDavis Clint H · Paola, KSBuilt 1966 · S/N 15063729N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429N712TCTeasdale Gregg N · Genesee, IDBuilt 1967 · S/N 18258086N712VTMiddle Fork Aviation Inc · Challis, IDBuilt 1967 · S/N U206-0932N71300Finch Merry B · Marysville, CABuilt 1969 · S/N 18259568N71305Fisher Vincent E · Burrton, KSBuilt 1969 · S/N 18259570N7130FRicker Gary L · Greeneville, TNS/N 15063730N7130SHansen Christopher H · Durhamville, NYBuilt 1967 · S/N 15067830N71317Abbatiello Vincent Jr · Cape Coral, FLBuilt 1969 · S/N 18259575N7131FSchoch Brayden · Fort Pierce, FLBuilt 1966 · S/N 15063731N71320Wptd Inc · Munster, INBuilt 1969 · S/N 18259577N71321Boyle Christopher R · Truckee, CABuilt 1969 · S/N 18259578N71323Air Legacy LLC · Chanhassen, MNBuilt 1969 · S/N 18259579N71326Lrc Aero LLC · Jacksonville, TXS/N 18259580N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432N71331Baird David W · Kanab, UTBuilt 1969 · S/N 18259582N71333Delaney Michael T · Edmonds, WABuilt 1969 · S/N 18259583N71336Aviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1969 · S/N 18259585N7133FCarrolls Auto And Aircraft Sales LLC · Muncie, INBuilt 1966 · S/N 15063733N7133QPage Aerial Service Inc · Rochelle, ILBuilt 1972 · S/N 17260433N7134FMejean Kenneth R · Brandon, FLBuilt 1966 · S/N 15063734N71354Willis Enterprises · Enterprise, ORBuilt 1969 · S/N 18259589N71355Dal Tex Flyers Inc · Arlington, TXBuilt 1969 · S/N 18259590N71359Sparks Fly LLC · Mount Gilead, OHBuilt 1969 · S/N 18259593N7135FMiller Joseph A · Amissville, VABuilt 1966 · S/N 15063735N7135QHoman Larry E · Sigourney, IABuilt 1972 · S/N 17260435N71369Gosney James R Trustee · Silver City, NMBuilt 1969 · S/N 18259595N7136GFairchild Natalie J · Drummond Island, MIS/N 15074614N7136QPa Lawrence LLC · Anchorage, AKBuilt 1972 · S/N 17260436N7136SGonzalez Alec · Homestead, FLBuilt 1967 · S/N 15067836N7136XArchangel Michael Flyers Inc · Princeville, HIS/N 17702290N71374Farmers Supply Corp · Ontario, ORBuilt 1969 · S/N 18259596N71378Hanson Jared E · Missoula, MTBuilt 1969 · S/N 18259598N71384Neal Donald L · Fresno, CABuilt 1969 · S/N 18259600N71386Single Engine Flyers LLC · Fredericksburg, TXBuilt 1969 · S/N 18259601N7138GWerenko Zandra · Cape Canaveral, FLBuilt 1973 · S/N 15074616N7138SDeaton Craig · West Alexandria, OHBuilt 1967 · S/N 15067838N71397Turner Chris · Kosse, TXBuilt 1969 · S/N 18259606N71398Koch Jon P · Menahga, MNBuilt 1969 · S/N 18259607N7139GSkysg LLC · Eugene, ORBuilt 1969 · S/N 17258839N7139QFernander David · Enterprise, ALBuilt 1972 · S/N 17260439N713MATraining Wheels & Advanced Technologies LLC · La Salle, COBuilt 1966 · S/N U206-0679N713SMJa Williams Investments LLC · Austin, TXBuilt 1969 · S/N 18259920N71400Wubben Robert C · Waupaca, WIBuilt 1969 · S/N 18259609N71405Bowes John Michael · Lake City, FLBuilt 1969 · S/N 18259611N71408Emerald Darin · Springerville, AZBuilt 1969 · S/N 18259612N7140FLogan Gregory A · Chouteau, OKS/N 15063740N7140QMagnuson Jessica M · Olathe, KSBuilt 1972 · S/N 17260440N7141GDyke Paul A · Hartford, SDBuilt 1969 · S/N 17258841
Back to AD 72-03-03 R3