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.

N5757GWill Cutter G · San Angelo, TXBuilt 1969 · S/N 15071257N5757JAdams Gary A · Alva, OKBuilt 1971 · S/N 21059457N5759RP & R Aviation LLC · Edenton, NCS/N 17253428N575AAHanson Dirk Allen · Moorhead, MNS/N 205-0322N5760GVan De Walle Matthew W · San Antonio, TXBuilt 1969 · S/N 15071260N5763JLemons Brooks D · Visalia, CABuilt 1971 · S/N 21059463N5765GQuiring Jason L · Terrell, NCS/N 15071265N5767JValiair Limited Co Trustee · Casper, WYBuilt 1971 · S/N 21059467N5767RSelf Averill L · Campbell, TXBuilt 1965 · S/N 17253436N5768GBilton Nicholas J · Bozeman, MTBuilt 1969 · S/N 15071268N5768RAllenray Corp · Otsego, MIBuilt 1965 · S/N 17253437N5769GHarper William M Jr · Foley, ALBuilt 1969 · S/N 15071269N5769RLatimer Francis E · Washingtonville, NYBuilt 1965 · S/N 17253438N5770GVoller Jim A · Strasburg, NDS/N 15071270N5770RFurge David T · Brookton, MEBuilt 1965 · S/N 17253439N5771RWilson Bach Myrl · Piedmont, SCBuilt 1965 · S/N 17253440N5772GBean Dale R · Moreno Valley, CABuilt 1969 · S/N 15071272N5773REnev Ivan E · Wood Dale, ILS/N 17253442N5774GHuffman Jacob M III · Burleson, TXBuilt 1969 · S/N 15071274N5774RBallard Thomas L · Seguin, TXBuilt 1965 · S/N 17253443N5776GWilliams Timothy · Byron, GABuilt 1969 · S/N 15071276N5776RKatri Thomas L · Conroe, TXBuilt 1965 · S/N 17253445N5777GZawtocki Ronald · Little Falls, NYBuilt 1969 · S/N 15071277N5777RSumner Gary W · Knoxville, TNBuilt 1965 · S/N 17253446N5779GChapman Jeremy R · Niagara Falls, NYBuilt 1969 · S/N 15071279N5779JBeavers Air LLC · Fort Walton Beach, FLBuilt 1971 · S/N 21059479N577CDSeger Properties Ltd · Fort Loramie, OHBuilt 1969 · S/N P20600609N5780GAlvarez Faust M · Helena, MTBuilt 1969 · S/N 15071280N5781GWilliams Lynwood A · Clayton, NCBuilt 1969 · S/N 15071281N5781RFeauto Aviation Inc · Saint Cloud, FLS/N 17253450N5782RSchuck Daniel W · Newark, CABuilt 1965 · S/N 17253451N5783JSelting Mark D · Kadoka, SDBuilt 1971 · S/N 21059483N5783RPritting John R · Reno, NVS/N 17253452N5785GBrown Colin M · Williamstown, NJBuilt 1969 · S/N 15071285N5785RKablau Frank · Elroy, WIBuilt 1965 · S/N 17253454N5786RBrown Jeremiah S · Ada, OHS/N 17253455N5789RShipley Lucas S · Jefferson, IABuilt 1965 · S/N 17253458N578MAByte Networking LLC · Juneau, AKFirst renewal noticeBuilt 1967 · S/N 15068091N5790RMiller Cindy C · San Ramon, CAS/N 17253459N5792RCollins Mark W · Seymour, TNBuilt 1965 · S/N 17253461N5793RRogers Jesse E · La Belle, MOBuilt 1965 · S/N 17253462N5794RMacfarland Donald C · North Tonawanda, NYBuilt 1965 · S/N 17253463N5795GRhodes Tom B · Dallas, TXBuilt 1969 · S/N 15071295N5796JRegistered aircraftBuilt 1971 · S/N 21059496N5797RRiggs Laura A · Middleburg, FLBuilt 1965 · S/N 17253466N5798RRatcliff Bruce A · Plain City, OHBuilt 1965 · S/N 17253467N5799GBafa LLC · Lewes, DEBuilt 1969 · S/N 15071299N5799JBritt Demolition And Recycling Inc · Hanceville, ALBuilt 1971 · S/N 21059499N579MAJones Andrew W · Turner, MTBuilt 1967 · S/N 15068081N57EAEwing Andrew M · Santa Rosa Beach, FLBuilt 1977 · S/N 177RG1169
Back to AD 72-03-03 R3