OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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.

N9646BN9646b LLC · Wilmington, DEBuilt 1981 · S/N 172RG0942N9646DFerrell Alan B · Arlington, OHBuilt 1959 · S/N 22-6560N9646RB-Dog Aviation LLC · Grand Junction, COS/N TD-345N9646WOgier Gerard Paul · Hampton, NHBuilt 1967 · S/N 28-23105N9647BLakewood Investments LLC · Victorville, CAS/N 172RG0943N9647DSutton Neal · Ashby, NEBuilt 1959 · S/N 22-6561N9647QKaeni Law Group Inc · Santa Ana, CABuilt 1975 · S/N 17265731N9647UWilhite Randall D · Plainville, MABuilt 1975 · S/N AA5A-0013N9647WAirplanes Plus Inc · Marathon, FLBuilt 1967 · S/N 28-23106N9648HSaunders Larry F · Sulphur Springs, ARBuilt 1975 · S/N 17266294N9648MN9648m LLC · Louisville, KYBuilt 1967 · S/N 670225N9648QGreen Bay Flying Club Inc · Krakow, WIBuilt 1975 · S/N 17265732N9648VGrove Kaylene · San Diego, CABuilt 1974 · S/N 17264428N9648WMccullough Dwayne D · Onancock, VABuilt 1967 · S/N 28-23107N96493Smtm Holdings Inc · Wilmington, DES/N 17276080N9649BGoebel Christian E · Luray, VABuilt 1981 · S/N 172RG0945N9649DUlrich Kenneth B Jr · Kingwood, TXBuilt 1959 · S/N 22-6563N9649JRegistration Pending · Springboro, OHRegistration pendingBuilt 1967 · S/N 28-3876N9649VLagorce Victor X · Owasso, OKBuilt 1974 · S/N 17264429N9649WWard Travis E · Tucson, AZBuilt 1967 · S/N 28-23109N964AAFlorida Flight Training Center Inc · Venice, FLBuilt 1978 · S/N 17271084N964HLGraham Huber L · Gulf Breeze, FLBuilt 2001 · S/N 1N964SHI1 Aviation LLC · Wilmington, DEBuilt 2005 · S/N 3941N964TEBedard Robert L · Bolivar, OHBuilt 2005 · S/N 10243N96503Miravete Paul Trustee · Saint George, UTBuilt 1983 · S/N 17276081N9650DKahanek Doug II · Alvarado, TXBuilt 1959 · S/N 22-6564N9650JPalmer Eric · Bowling Green, OHBuilt 1967 · S/N 28-3815N9650QVon Graff Kurt · Pennington, NJBuilt 1975 · S/N 17265734N9650VPittman Michael Sr · Chandler, AZBuilt 1974 · S/N 17264430N9651DKadera David E · Dorchester, IABuilt 1959 · S/N 22-6565N9651PLedda Robert L · Soldotna, AKBuilt 1974 · S/N 18-7409142N9651RSchwartz Alan · Hurleyville, NYBuilt 1960 · S/N TD-348N9651VHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17264431N9652DWilliams Michael P · Shelburne Falls, MAS/N 22-6566N9652UFry Anthony J · Rocky River, OHBuilt 1975 · S/N AA5A-0018N9652VBrown Keno · Athens, TXBuilt 1974 · S/N 17264432N9652WRegistered aircraftS/N 28-23112N9653BSd Office Supplies & Furniture Rentals LLC · Chula Vista, CABuilt 1981 · S/N 172RG0946N9653DHurt Thomas J · Kerrville, TXBuilt 1959 · S/N 22-6569N9653JClear Sky LLC · La Grange Park, ILBuilt 1966 · S/N 28-3818N9653PUhls Keith T · Austin, TXBuilt 1974 · S/N 18-7409144N9653QMikeska Rudy L · Taylor, TXBuilt 1975 · S/N 17265737N9653RColorado Northwestern Community College · Rangely, COBuilt 1960 · S/N TD-343N9653USteffen Todd M · Wind Lake, WIBuilt 1975 · S/N AA5A-0019N9653WWohl Scott D · Clarkston, WABuilt 1967 · S/N 28-23114N9654BDonohue Andrew · Tulsa, OKBuilt 1981 · S/N 172RG0947N9654JMouton Charles J Jr · Gladewater, TXBuilt 1966 · S/N 28-3820N9654QFly Pioneer Valley LLC · Gill, MABuilt 1975 · S/N 17265738N9654URealty Investment Co Ltd · Hilo, HIBuilt 1975 · S/N AA5A-0020N9654VN9654v LLC · Lakeland, FLS/N 17264434
Back to AD 79-10-03 R2