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.

N5656GLet There Be Flight LLC · Portage, MIBuilt 1969 · S/N 15071156N5657RFord Darryl · Caldwell, IDBuilt 1965 · S/N 17253287N5658REilers Scott D · Amissville, VABuilt 1965 · S/N 17253289N5659GLacy Melodi J · Swanton, VTBuilt 1969 · S/N 15071159N565CMBackcountry Aviation LLC · North Salt Lake, UTBuilt 1968 · S/N U2061044N565UEsposito John A · Rye, NHBuilt 1963 · S/N 206-0065N5660GLawrence Corey R · Bourbon, MOBuilt 1969 · S/N 15071160N5660RSpirit Hills Ranch LLC · Belgrade, MTBuilt 1965 · S/N 17253292N5665RLimmer Rita G · Redding, CABuilt 1965 · S/N 17253299N5666RSport Flying USA Inc · Ronkonkoma, NYBuilt 1965 · S/N 17253300N5667RBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1965 · S/N 17253302N5669RBeasley Marty J · Statesboro, GABuilt 1965 · S/N 17253304N566GSPomeroy Cattle Ranch LLC · Kalispell, MTS/N 15071446N566JWRoss Stephen D · Greenfield, OHBuilt 1962 · S/N 18254448N5670R&R Aircraft LLC · Chugiak, AKBuilt 1966 · S/N 18256905N5672GHarrold Adam T · New Waterford, OHBuilt 1969 · S/N 15071172N5674RSpellman Mark · Novi, MIBuilt 1965 · S/N 17253312N5675GGray Mark J · Muncie, INBuilt 1969 · S/N 15071175N5675RN5675r Corp · Rochester, NYBuilt 1965 · S/N 17253313N5676GSchmidt Gary L · Afton, MNS/N 15071176N5677GFredenburg Justin N · Edgeley, NDS/N 15071177N5678NRedwood Area Flyers LLC · Springfield, MNBuilt 1966 · S/N 0292N5679RSandy River Flying Club · Wilton, MES/N 17253319N567BBBeers Suzanne M · Colorado Springs, COBuilt 1973 · S/N 17701880N567DBGardner Law Firm Pllc · Shawnee, OKBuilt 1965 · S/N 21058689N567GSFlying R LLC · Spokane Valley, WABuilt 1971 · S/N 15072751N567JBHarper Alli B · Joaquin, TXBuilt 1970 · S/N 18260297N567XCovert Tim · Portland, ORBuilt 1962 · S/N 18254115N5680PHaro Roger E · Eden Prairie, MNBuilt 1967 · S/N 15064867N5680RBraun Joshua H · Springfield, MOBuilt 1965 · S/N 17253320N5683GCollege Of Missionary Aviation Inc · Keystone Heights, FLS/N 15071183N5683RLewis George H · Brookline, NHBuilt 1965 · S/N 17253324N5684RGorton Horace B · Overland Park, KSBuilt 1965 · S/N 17253326N5686RLogan Kevin · Amarillo, TXS/N 17253329N5687GChilders Roderick G · Red Banks, MSBuilt 1969 · S/N 15071187N5687REsch Randall L · Stanton, MIBuilt 1965 · S/N 17253330N5688GFriends Of Jesus · Poughkeepsie, ARFirst renewal noticeBuilt 1969 · S/N 15071188N5690RMcveigh Ian Thomas · Mansfield, TXBuilt 1965 · S/N 17253334N5691RBase 2 Final Fleet LLC · Mckinney, TXBuilt 1965 · S/N 17253336N5693GScott Jerry · Wingate, TXBuilt 1969 · S/N 15071193N5694GN528r LLC · Auburn, ALBuilt 1969 · S/N 15071194N5696GLowry David N · Fairport, NYBuilt 1969 · S/N 15071196N5696RMagnolia Flight Aviation LLC · Pontotoc, MSBuilt 1965 · S/N 17253343N5698GKessler Frank J Jr · Gallatin, TNS/N 15071198N5699RNoriega Vanessa · Miami, FLS/N 17253349N569APotopowitz William III · Niantic, CTS/N 15070351N569GSTwin Cities Flight Training Inc · Blaine, MNBuilt 1971 · S/N 15072763N56ACLatham Randall W · Georgetown, OHBuilt 1964 · S/N 17252416N56DCAero Services Lc · Woods Cross, UTBuilt 1967 · S/N T210-0280N5700RSpindler Dale A · Auburn, WABuilt 1965 · S/N 17253350
Back to AD 72-03-03 R3