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.

N2227YAdam Lewis W · Chiefland, FLBuilt 1967 · S/N 17700027N22284Fenton Ted P · Rushville, MOS/N 15068191N22285Barlow Richard B · Stockbridge, GABuilt 1968 · S/N 15068192N22297Trissell Flying Service Inc. · Clarksville, TXBuilt 1968 · S/N 15068199N222ATSierra 1 Tech Inc · Blue Jay, CABuilt 1968 · S/N 21059098N222FDKent State University · Stow, OHBuilt 1968 · S/N 15068498N222FFReagan John · Knippa, TXS/N 18253725N222QLindeen Karen D · Anchorage, AKS/N 18257622N222QAKlopotek Jerome P · Orangevale, CABuilt 1969 · S/N 15070543N222TADeschene Michael R · Westminster, CABuilt 1968 · S/N 15069729N222TKMachowicz Mark M · Eastpointe, MIBuilt 1967 · S/N 18257973N222WFBailey Steve · Chehalis, WABuilt 1963 · S/N 205-0220N22304Berry Dewey R · Lexington, SCBuilt 1968 · S/N 15068204N22305Arend James E · Mesa, AZS/N 15068205N22307Martin David O · West Mifflin, PABuilt 1968 · S/N 15068207N2230898x LLC · Caddo Mills, TXBuilt 1968 · S/N 15068208N2230JCragg Gordon E · Georgetown, TXS/N 15065430N22310Tackett Eric · Huntington, INBuilt 1968 · S/N 15068210N22318Reggie Denis A Jr · Marietta, GABuilt 1968 · S/N 15068214N22325Marlee B Thomas · Tolar, TXBuilt 1968 · S/N 15068216N22329Guernsey G R · Belen, NMBuilt 1968 · S/N 15068219N22335Johnson Marissa N · Avon, INBuilt 1968 · S/N 15068222N2233JPalmer Kim W · Lockport, NYBuilt 1966 · S/N 15065433N2234RJones Lennis William III · Rule, TXBuilt 1968 · S/N T210-0384N22351Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 15068229N22354Franks Cory · Idalou, TXS/N 15068232N22355Quinones Steven · Forney, TXBuilt 1968 · S/N 15068233N22360Levy Peter F · Augusta, KSBuilt 1968 · S/N 15068236N22361Youngblood Steve R · Young Harris, GABuilt 1968 · S/N 15068237N2236RSouthern Skies Aviation Inc · Cedar City, UTS/N T210-0386N2237JSudduth Mark E · Lancaster, PABuilt 1966 · S/N 15065437N22385Knutson Wayne R · Thompson, NDBuilt 1968 · S/N 15068248N2238JPearce William · Grants Pass, ORBuilt 1966 · S/N 15065438N2238YFerrara Edmond · La Puente, CABuilt 1967 · S/N 17700038N223LDGaston'S White River Resort Inc · Lakeview, ARBuilt 1965 · S/N U206-0493N223TLZanghi Michael · Katy, TXBuilt 1971 · S/N 18260719N223TRTurner Lee W · Valdosta, GABuilt 1968 · S/N 17257757N22401Knotek Larry A · Reno, NVS/N 15068256N22409Tanner David A · Onalaska, TXBuilt 1968 · S/N 15068262N2240JBreithaupt Tracy L · Alexandria, LAFirst renewal noticeBuilt 1966 · S/N 15065440N22415Viking Wings LLC · Kindred, NDBuilt 1968 · S/N 15068266N2241RHappy Landings Aero LLC · Wilmington, DEBuilt 1968 · S/N T210-0391N22435Pearson Charles C · Covington, LABuilt 1968 · S/N 15068279N22436Pecht Scott A · Reedsville, PABuilt 1968 · S/N 15068280N22439Birginia Aviation LLC · Forest, VAS/N 15068283N2243YReeves Adrianna M · New Carlisle, INBuilt 1967 · S/N 17700043N22448Eddy Lisa M · Benton, KSBuilt 1968 · S/N 15068291N2244YHaberer Mark M · Elbow Lake, MNBuilt 1967 · S/N 17700044N22452Waddy Bertha L · Villa Ridge, ILBuilt 1968 · S/N 15068292N2245JRiver City Aviation LLC · Carmichael, CAS/N 15065445
Back to AD 72-03-03 R3