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.

N1945XStepps Dana · Humboldt, TNBuilt 1965 · S/N 18256045N19463Aviation Trust Co LLC · Oklahoma City, OKBuilt 1973 · S/N 15074431N19469Registration Pending · Summerland Key, FLRegistration pendingS/N 15074433N1946QMoore Garrie W · Georgetown, TXBuilt 1973 · S/N 177RG0346N19476Havron Dana Houston · Huntsville, ALS/N 15074438N19477Rare Birds LLC · Yukon, OKBuilt 1973 · S/N 15074439N19479Kunkle Bryan S · Mount Morris, NYBuilt 1973 · S/N 15074441N1947QBailey Jr James E · Rittman, OHBuilt 1973 · S/N 177RG0347N19480Blair Mark · Kingman, AZBuilt 1973 · S/N 15074442N19481Majors Flying Club · Greenville, TXBuilt 1973 · S/N 15074443N19486Beavers David Allen · Strasburg, COS/N 15074444N1948BKc Aviation LLC · Conway, ARBuilt 1974 · S/N 177RG0564N1948QHorsley Luther J · Midland, ORS/N 177RG0348N1948XGreenwood Auto LLC · Itta Bena, MSBuilt 1965 · S/N 18256048N194961w1 Aero LLC · Issaquah, WABuilt 1973 · S/N 15074450N194SESamnik Enterprises LLC · Naples, MEBuilt 1972 · S/N 17260386N19501Beardsley Larry N · Leavittsburg, OHBuilt 1976 · S/N 17702574N19506Colvard Tony D · Newland, NCS/N 15074457N19508Andelt David L · Parker, COBuilt 1973 · S/N 15074459N1950QSherwood Jeffrey Curtis · Cranston, RIBuilt 1973 · S/N 177RG0350N19514N&C Enterprises LLC · Vine Grove, KYS/N 15074461N19516Choppin Dale · Sun City, AZBuilt 1973 · S/N 15074462N19519Gulf Niner LLC · Eagan, MNBuilt 1976 · S/N 17702575N1951XSkyline Aircraft Maintenance Inc · Nampa, IDBuilt 1965 · S/N 18256051N19520Ag Avventures LLC · Hartford, WIS/N 15074465N19522Cannan Aviation Inc · Georgetown, TXS/N 15074467N19523Frana Joel A DBA · Fort Myers, FLBuilt 1973 · S/N 15074468N19524Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 15074469N19526Soebagyo Vincent · Hollywood, CABuilt 1973 · S/N 15074471N19531Archer Collins Etheridge · Fairview, TXBuilt 1973 · S/N 15074476N19534Smith Paul C Sr · Winthrop, MES/N 15074479N1954LSmith Cody · Fairbanks, AKBuilt 1966 · S/N U2060751N1954SBarca Sky F · Simi Valley, CABuilt 1974 · S/N 17702197N1954XStull David H · Sausalito, CABuilt 1965 · S/N 18256054N19550Cheap Flight Time LLC · Athens, GAFirst renewal noticeBuilt 1973 · S/N 15074480N19558Moon Jonathan E · Butler, PABuilt 1973 · S/N 15074485N19564Priewe Jeff C · Como, MSBuilt 1973 · S/N 15074489N19568June Richard · Stevenson Ranch, CABuilt 1973 · S/N 15074492N19572Borzoya Aero Group Inc · Slatington, PABuilt 1973 · S/N 15074496N19575Galis Iuri · Oklahoma City, OKBuilt 1976 · S/N 17702577N1957XDrummond Michael S · Burlington, NCBuilt 1965 · S/N 18256057N19582Olson Ben A · Gig Harbor, WABuilt 1973 · S/N 15074505N19587Steward Matthew C A · Broken Arrow, OKBuilt 1973 · S/N 15074509N19588Kenner David · Maddock, NDS/N 15074510N19589Eaton William I Jr · Seabrook, NHBuilt 1973 · S/N 15074511N1958XOrth Matthew B · Marion, KSS/N 18256058N19590Koskan John M · Wood, SDBuilt 1973 · S/N 15074512N19592Aviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1973 · S/N 15074514N19594Jeter Ray E · Spring Hill, FLS/N 15074516N19597Estrada Katrina · Helotes, TXBuilt 1973 · S/N 15074519
Back to AD 72-03-03 R3