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.

N3435LYuknis Birch · Wasilla, AKS/N U206-0735N3435UJackson Terry W · Lewisburg, TNBuilt 1963 · S/N 18254835N3436FChinik James G · Jacksonville Beach, FLBuilt 1967 · S/N 17700604N3437FYankee Air LLC · Valdosta, GAS/N 18257437N3437RSmith Darrin M · Torrance, CABuilt 1968 · S/N 18258737N3437TRoberts John M · Mansfield, MOBuilt 1968 · S/N 17700737N3438RDauenhauer Colby · Springtown, TXBuilt 1967 · S/N 18258738N3438SAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 17701784N3438UGrau Gary Wayne Jr · Yelm, WABuilt 1963 · S/N 18254838N3439SProtsman Bryan D · Anchorage, AKBuilt 1964 · S/N 18255839N3439UFlycatcher Aviation LLC · Purcell, OKBuilt 1963 · S/N 18254839N34405Jj&R Aero LLC · Winchester, INBuilt 1972 · S/N 17701787N34407Registered aircraftS/N 17701788N3440JNoguess Michele R · Deming, NMBuilt 1967 · S/N 15066140N3440SLynch Chris A · Sedro Woolley, WABuilt 1964 · S/N 18255840N3440UPlane Joy LLC · Payson, AZBuilt 1963 · S/N 18254840N34411Jlh Aviation LLC · La Grange, TXBuilt 1972 · S/N 17701790N34413Mms Flight LLC · Shawnee, KSBuilt 1972 · S/N 17701791N3441FLawrence Kam M · Big Bear City, CABuilt 1966 · S/N 18257441N3441LBarlow Dwight D · Monte Vista, COBuilt 1966 · S/N U206-0741N3441RQualtieri John E · Fallon, NVS/N 18258741N3441SSun Technology LLC · Cheyenne, WYBuilt 1964 · S/N 18255841N3441UDemeyer Scott M · Olympia, WABuilt 1963 · S/N 18254841N34420Berman John L · Corvallis, ORS/N 17701794N34426Cardinal 426 LLC · Jacksonville, FLBuilt 1976 · S/N 177RG0996N34427Cessna 177b Cardinal LLC · Prescott, AZBuilt 1972 · S/N 17701797N3442SRail Birds · Clearfield, UTBuilt 1964 · S/N 18255842N34430Travland Christopher L · Austin, TXBuilt 1972 · S/N 17701798N34432Wallace James K · Rio Rancho, NMBuilt 1972 · S/N 17701799N34433Sowlemann Inc · Rockton, ILBuilt 1972 · S/N 17701800N3443RBertrand John E · Trion, GABuilt 1967 · S/N 18258743N3443SWilliams Forest Chem LLC · Columbus, GABuilt 1964 · S/N 18255843N3443UHall George K · Cathedral City, CABuilt 1963 · S/N 18254843N34442Valenti Alan · Bend, ORBuilt 1972 · S/N 17701805N34443Schwitters Jerry · Clara City, MNS/N 17701806N34444Lil Red Cardinal LLC · Phoenix, AZBuilt 1972 · S/N 17701807N34445East Carolina Aviation LLC · Camden, NCBuilt 1972 · S/N 17701808N34448Schleicher Conan A · Salem, ORBuilt 1972 · S/N 17701809N3444FAtwood David E Trustee · Nampa, IDBuilt 1966 · S/N 18257444N3444LDierick Greg E · Yakutat, AKS/N U206-0744N3444SBraha Thomas I · Mansfield, PABuilt 1964 · S/N 18255844N3444THunter David Frederick · Peachtree City, GABuilt 1968 · S/N 17700744N3444ULepton Films LLC · Tarzana, CABuilt 1963 · S/N 18254844N34453Porcaro James · Latham, NYS/N 17701814N3445FAltus Aircraft LLC · Taylor, TXBuilt 1966 · S/N 18257445N3445LYama Air LLC · Granite Bay, CABuilt 1966 · S/N U206-0745N3445SBigfoot Aviation LLC · Shelton, WAS/N 18255845N3445TNelson Stephen A · Milaca, MNBuilt 1968 · S/N 17700745N34464Morgan Michael B · Stanwood, WAFirst renewal noticeBuilt 1972 · S/N 17701821N34465Brodbeck William J · Kyle, TXBuilt 1972 · S/N 17701822
Back to AD 72-03-03 R3