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.

N6949RElyan Aviation Inc · Palm Springs, CABuilt 1968 · S/N T210-0349N694MMBrown Ryan W · Nampa, IDBuilt 1969 · S/N 18259874N694QPhillips Todd · New Albany, MSBuilt 1963 · S/N 18254585N6950FRgv Flight Academy LLC · Bayview, TXBuilt 1966 · S/N 15063550N6951GHernandez Alfonso · Garland, TXBuilt 1970 · S/N 15072451N6952FSkalsky Nathan · Tigard, ORBuilt 1966 · S/N 15063552N6952SMyers Karen J · Bemidji, MNBuilt 1967 · S/N 15067652N6953GVidal Miguel · Novi, MIS/N 15072453N6954FRegistration Pending · Sumner, WARegistration pendingBuilt 1966 · S/N 15063554N6954SPierson Jared · Coeur D Alene, IDBuilt 1967 · S/N 15067654N6955GExecutive Aircraft International Inc · Bolivar, TNS/N 15072455N6955SHhd Aviation LLC · Hamilton, OHBuilt 1967 · S/N 15067655N6955VNeu Timothy F · Orlando, FLBuilt 1965 · S/N 18256630N6956GR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 15072456N6957FRussell Clyde R Jr DBA · Montrose, ARS/N 15063557N6958GScoskie Keith E · Van, TXBuilt 1970 · S/N 15072458N6958SPeterson Leonard J · Cleveland, TNBuilt 1967 · S/N 15067658N6960FFirst Waypoint LLC · Mckinney, TXS/N 15063560N6962FSiegrist Gary D · Belvidere, ILS/N 15063562N6962GGill Robert S · Anchorage, AKBuilt 1970 · S/N 15072462N6965FJefferies Vincent B · Rock Springs, WYBuilt 1966 · S/N 15063565N6965SSawyer Donald · Johnson, VTS/N 15067665N6966GHotsenpiller Larry E · Sedalia, MOBuilt 1970 · S/N 15072466N6966SStout Larry E · Winamac, INBuilt 1967 · S/N 15067666N6967GHuddleston Edward I · Oaktown, INS/N 15072467N6968STrue Robert S · Prosper, TXS/N 15067668N6969FBrannan William C · Temecula, CAS/N 15063569N6969YTorres Charles O · Riverside, CABuilt 1966 · S/N T210-0150N696CBWhitmire Aviation LLC · Saint Augustine, FLS/N 177RG0333N696MMShimoda Aviation LLC · Hawthorne, FLBuilt 1968 · S/N 18259202N696NSParkhill Clifton A Jr Trustee · Oxnard, CABuilt 1968 · S/N 15068871N696PRDeliberty Michael J · Townsend, DEBuilt 1964 · S/N 205-0546N6970GOstrem John C · Stillwater, MNBuilt 1970 · S/N 15072470N6971FSutton Marshall T · Erick, OKBuilt 1966 · S/N 15063571N6971GParks Rodney A · Vero Beach, FLBuilt 1970 · S/N 15072471N6971SHirsch T W III · Farmers Branch, TXS/N 15067671N6972FHirsch T W III · Farmers Branch, TXBuilt 1966 · S/N 15063572N6975G61hv LLC · Shady Shores, TXBuilt 1970 · S/N 15072475N6976FCalder Mark A · Midlothian, TXBuilt 1966 · S/N 15063576N6976SMancine Timothy J · Turner, MEBuilt 1967 · S/N 15067676N6977FRice Dennis L · Crawfordsville, INBuilt 1966 · S/N 15063577N6978GSaia Mark · Oak Harbor, WAS/N 15072478N6979GWestall Ken L · Santa Maria, CABuilt 1970 · S/N 15072479N6980FEnvii Aviation LLC · Monroe, WAS/N 15063580N6980GSamudio Lazaro III · Wildomar, CABuilt 1970 · S/N 15072480N6981SSalerno Gina · Cape Coral, FLBuilt 1967 · S/N 15067681N6982GBedford Cutter G · Bremerton, WAS/N 15072482N6983GGoemmel Steven J · Airway Heights, WABuilt 1971 · S/N 15072483N6984GCoffel Alexander · Meridian, IDS/N 15072484N6985GBustamante Wilton F · Whitsett, NCBuilt 1971 · S/N 15072485
Back to AD 72-03-03 R3