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.

N2478XCrooked Lake Aero LLC · Hammondsport, NYBuilt 1965 · S/N 18256378N2479LMoore Joseph A · Kingwood, WVBuilt 1966 · S/N 17255679N2479QPriest David E · Caldwell, IDBuilt 1966 · S/N 18257679N2479XKruse Interests LLC · League City, TXS/N 18256379N247APNorth Joseph · Cocoa, FLBuilt 1970 · S/N 17259066N247DLCentral Florida Flight LLC · Ocoee, FLBuilt 1966 · S/N 17254201N2480LStephens Ryan J · Dallas, PABuilt 1966 · S/N 17255680N2481LGhaemmaghami Ommid · Mckinney, TXBuilt 1966 · S/N 17255681N2481REngh Robert G · Laurel, MTBuilt 1964 · S/N 18255581N2482LTrubowicz Maciej Piotr · Cornelius, NCBuilt 1966 · S/N 17255682N2482QFox John E · Boonville, CABuilt 1966 · S/N 18257682N2483QMarch Kenrick D · Kingwood, TXBuilt 1966 · S/N 18257683N2483RSkydive Twin Cities LLC · Baldwin, WIS/N 18255583N2484JTundra Aviation Inc · Casselton, NDBuilt 1966 · S/N 15065584N2484LLuv2fly LLC · San Antonio, TXS/N 17255684N2485JPercival Sheila · Watson, ILS/N 15065585N2485QPayne Scott M · Twin Bridges, MTBuilt 1966 · S/N 18257685N2486RCain James W · Big Rapids, MIBuilt 1964 · S/N 18255586N2486XGreat Escape Aviation LLC · Marquette, MIBuilt 1965 · S/N 18256386N2487RCummings Sean · Lombard, ILBuilt 1964 · S/N 18255587N2488JMcdonald Nicholas W · Phoenix, AZBuilt 1966 · S/N 15065588N2488RCorprew Gerard A · Callao, VABuilt 1964 · S/N 18255588N2488XCentral Oil Co LLC · Mcminnville, TNBuilt 1965 · S/N 18256388N2489JVan Velson Richard Lee · Brule, NEBuilt 1966 · S/N 15065589N2489LCalifornia Aviation Services Inc · Riverside, CABuilt 1966 · S/N 17255689N2489XVanderweel Martha · Wolcott, NYBuilt 1965 · S/N 18256389N248ZLightsey Aviation LLC · Jacksonville, FLBuilt 1967 · S/N 17256247N2490JSchmitt Rudy · Brookshire, TXBuilt 1966 · S/N 15065590N2490LWimberly Thomas F III · Bend, ORBuilt 1966 · S/N 17255690N2490RBirdie Air LLC · Wichita, KSBuilt 1964 · S/N 18255590N2490XFoley David A Trustee · Afton, WYBuilt 1965 · S/N 18256390N2491LMcgivern James · San Pedro, CABuilt 1966 · S/N 17255691N2491QLong Daniel · Stevenson, ALBuilt 1966 · S/N 18257691N2491RDaly John M · Fort Worth, TXBuilt 1964 · S/N 18255591N2491XBaalman Murray J · Grinnell, KSBuilt 1965 · S/N 18256391N2492JGerke Russell L · Kalispell, MTBuilt 1966 · S/N 15065592N24936Scopellite Sebastian · Phoenix, AZS/N 15074859N2493JBrunson Anthony W · Evans, GABuilt 1966 · S/N 15065593N2493QTarrant Enterprises Inc · Eagle, COBuilt 1966 · S/N 18257693N2493XKoenig William T · Sauk Centre, MNBuilt 1965 · S/N 18256393N2494QMcculloch Kyle · Bixby, OKBuilt 1966 · S/N 18257694N2495RSale Reported · Saint Augustine, FLSale reported, canceledBuilt 1964 · S/N 18255595N2496LSequeira Michael J · Troy, MOBuilt 1966 · S/N 17255696N2497XVoeltzel Rick K · Rio Rico, AZBuilt 1965 · S/N 18256397N2498LJohn Kit M · Shoshone, IDBuilt 1966 · S/N 17255698N2498RJohnson Christopher A · Pampa, TXBuilt 1964 · S/N 18255598N2498XVotava Paul A · Mcintosh, MNBuilt 1965 · S/N 18256398N249MCTharp Angela K · Wentzville, MOBuilt 1965 · S/N 15061789N24JCEllis Robert W · Gilbert, AZBuilt 1966 · S/N 18257607N24REMelendez Jesus · North Miami, FLBuilt 1964 · S/N 18255274
Back to AD 72-03-03 R3