OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,028

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.

N8275MValiair Limited Company Trustee · Casper, WYBuilt 1970 · S/N 21059275N8276LFly Time Aviation LLC · San Tan Valley, AZBuilt 1967 · S/N 17256476N8277LSillers Kim O · Sault Sainte Marie, MIBuilt 1967 · S/N 17256477N8277UEdgewood Farms LLC · Groveland, NYBuilt 1964 · S/N 17252177N8278FIvey Joseph M · Poland, OHS/N 15064378N8278UMattison Alan B · Petaluma, CABuilt 1964 · S/N 17252178N8279ZVines Forrest Mackenzie · Bonney Lake, WABuilt 1963 · S/N 205-0279N827DFBrown Edward M · Cabot, ARBuilt 1970 · S/N 15071994N8281GWidtfeldt John R · Auburn, PABuilt 1971 · S/N 177RG0181N8281LSliwinski Kellyn E · Anchorage, AKBuilt 1967 · S/N 17256481N8281UHersch Richard E · Arlington, WAS/N 17252181N8283LChapin Devon S · Oxford, CTS/N 17256483N8283UThede Dondi I · Marshall, WIBuilt 1964 · S/N 17252183N8283ZClear Prop LLC · Bogalusa, LAS/N 205-0283N8284LMaxwell Barton W Jr · Crawfordsville, INBuilt 1967 · S/N 17256484N8285FBearss Gordon M · Lawrence, KSBuilt 1966 · S/N 15064385N8285UDel Martin Lp · Spring, TXBuilt 1964 · S/N 17252185N8285ZVaughn Hollis L · Virden, NMBuilt 1963 · S/N 205-0285N8286LKyle John M · Wheeling, WVBuilt 1967 · S/N 17256486N8287LShirk Matthew · Auburn, INBuilt 1967 · S/N 17256487N8287MProfessional Metal Services Inc · Albion, NEBuilt 1970 · S/N 21059287N8287ZMillion John B · Westminster, MDBuilt 1963 · S/N 205-0287N8288MAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1970 · S/N 21059288N8288SWatters Reid W · Tilleda, WIBuilt 1965 · S/N 15061888N8289FDe Cristo Andre G · Flushing, NYBuilt 1966 · S/N 15064389N8289GDutcher Kenneth J · Kingsland, TXS/N 177RG0189N8289LFaust Stanley J · Nashua, NHBuilt 1967 · S/N 17256489N8289UPrice William B · Lamar, SCBuilt 1964 · S/N 17252189N828JTAtems Elisabeth · Northfield, VTBuilt 1976 · S/N 177RG0945N8290LPretty Plane LLC · Nixa, MOBuilt 1967 · S/N 17256490N8290SNewsome Jeff · Blackwell, OKBuilt 1965 · S/N 15061890N8291GBullock Brooks M II · Cartersville, GABuilt 1971 · S/N 177RG0191N8291LUsglap LLC · Fort Morgan, COBuilt 1967 · S/N 17256491N8291SSipes Jacob L · Sunbury, OHBuilt 1965 · S/N 15061891N8291UBarnett William M · Rolla, MOBuilt 1964 · S/N 17252191N8292LBrown Troy M · Austin, TXBuilt 1967 · S/N 17256492N8292SStephens Ralph W · Reno, NVBuilt 1964 · S/N 18255792N8292URettkowski Brady A · Hermiston, ORBuilt 1964 · S/N 17252192N8292ZBenedick Yachal O · Wilsey, KSBuilt 1963 · S/N 205-0292N8293ZAv8r Aviation LLC · Yakima, WABuilt 1963 · S/N 205-0293N8294FWalters Craig S · Lake City, FLS/N 15064394N8294SLogtime Flight LLC · Lancaster, TXBuilt 1965 · S/N 15061894N8295UCrawfish Co LLC · Starkville, MSBuilt 1964 · S/N 17252195N8297SBergmann Joshua A · Menomonie, WIBuilt 1965 · S/N 15061897N8297UMcburney Richard O · Hudson, NCBuilt 1964 · S/N 17252197N8297ZMartinez Gabriel M · Santa Fe, NMBuilt 1963 · S/N 205-0297N8298FAustin Leslie M · Greenville, INBuilt 1966 · S/N 15064398N8299SMcauliffe John P · Livonia, MIBuilt 1965 · S/N 15061899N829BGGipson Robert E · Port Byron, ILBuilt 1968 · S/N 17700667N829PJMidwestern Twang Communications LLC · Evanston, ILBuilt 1970 · S/N 17701534
Back to AD 72-03-03 R3