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.

N50431Board Susan W · Moundsville, WVBuilt 1968 · S/N 15069298N50432Mountain Air Flying Club Inc · Clarksburg, WVBuilt 1968 · S/N 15069299N50434Summerville Daniel · Millersville, MDBuilt 1968 · S/N 15069301N50438Roche Thomas A · Bardstown, KYBuilt 1968 · S/N 15069303N50457Odyssey Entertainment Inc · Crystal, MNBuilt 1977 · S/N 177RG1133N50465Howard Wayne A · Loon Lake, WABuilt 1968 · S/N 15069322N50467Hastings Stephen J · Palmer, AKBuilt 1968 · S/N 15069324N50471Honsperger Karl J Trustee · Fremont, OHBuilt 1968 · S/N 15069327N50473Cobrinik Adam · Whites Creek, TNBuilt 1968 · S/N 15069329N50474Mother Lode Flying Club · San Andreas, CABuilt 1968 · S/N 15069330N50475Mc Ironworks Welding And Fabrication Inc · Chico, CABuilt 1968 · S/N 15069331N50488Fratti Robert B · Nampa, IDBuilt 1968 · S/N 15069340N50497Meurer Carl J · Little Rock, ARBuilt 1968 · S/N 15069347N504QChelatna Lake Lodge LLC · Anchorage, AKS/N U2061293N50502Behnke Randall · Manitowoc, WIS/N 15069351N50503Kelly Keith Austin · Oklahoma City, OKBuilt 1968 · S/N 15069352N50530Kelly John M · Gastonia, NCBuilt 1968 · S/N 15069376N50531Davies Patrick R · Trussville, ALBuilt 1968 · S/N 15069377N50532Cartagena Alfonso · Winter Springs, FLBuilt 1968 · S/N 15069378N50535Harrell Lewis H · Pontotoc, MSS/N 15069380N50538Dunes Aircraft Corporation Inc · Howell, MIS/N 15069382N50541W Air LLC · Wheeling, ILBuilt 1968 · S/N 15069384N50544Kidd Ronnie E · Ramseur, NCS/N 15069386N50550Registered aircraftS/N 15069391N50551Barreto Daniel · Enterprise, ALBuilt 1968 · S/N 15069392N50555Whalen John · West Ossipee, NHBuilt 1968 · S/N 15069396N50574Pope Gregory S · Jacksonville, ILBuilt 1968 · S/N 15069405N50577Diaz Ernesto · Oxnard, CABuilt 1968 · S/N 15069408N50578Mccann Michael H · Springfield, ORBuilt 1968 · S/N 15069409N50580Freeman Jeffrey E · Iron Mountain, MIBuilt 1968 · S/N 15069411N50581Pritchett Otis R · Avery, TXS/N 15069412N50583Registration Pending · Bentonville, ARRegistration pendingBuilt 1968 · S/N 15069414N5058USkyler Aviation Inc · San Diego, CABuilt 1963 · S/N 206-0058N50596Phillips John H · Vernal, UTBuilt 1968 · S/N 15069423N505FNovotny Paul A · Elk River, MNBuilt 1964 · S/N 17251911N505JRParker Matthew · Cloudcroft, NMS/N 18253919N50606Siderwicz Christopher J · Marstons Mills, MABuilt 1968 · S/N 15069429N50610Henry Mark Alan · Dickinson, TXS/N 15069431N50614Walker William G Jr · Scottsdale, AZBuilt 1968 · S/N 15069434N50617Adventist World Aviation · Wilson, NCS/N 15069436N50618Clark Christopher W · Fallon, NVBuilt 1968 · S/N 15069437N50621Slade Michael · Lakeville, MABuilt 1968 · S/N 15069439N50624Davis Clint A · Fairland, INBuilt 1968 · S/N 15069442N50628Padgett Justin S · Fruithurst, ALBuilt 1968 · S/N 15069445N50629Boshart Stanley J · Albany, ORBuilt 1968 · S/N 15069446N5062UEnglish Ryan E · Henderson, NVBuilt 1964 · S/N 206-0062N50633Sherwood Ronald R · Kathleen, GABuilt 1968 · S/N 15069449N50641Jstram Lc · Sheridan, WYBuilt 1968 · S/N 15069454N50652Omlid Robert L · Watford City, NDBuilt 1968 · S/N 15069461N50663Zimna Grazyna · KrasocinS/N 15069467
Back to AD 72-03-03 R3