AD 94-05-05 R1

Registered aircraft · 26,232

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

N7018XMenard Charles H · Grand Blanc, MIBuilt 1961 · S/N 15059118N7019AReynolds Barbara A · Los Fresnos, TXBuilt 1956 · S/N 29119N7019TGerdeman David R · Litchfield, OHBuilt 1959 · S/N 46619N7019XWardwell Walter L · Fallon, NVS/N 15059119N701AKReid Robert A · Big Lake, AKS/N 7-1392N701CGKrick Gary B · Debary, FLBuilt 1998 · S/N 7-3057N701DPVertex Strategies LLC · Marshall, VABuilt 2006 · S/N 601-018SN701FFRegistration Pending · Lakeland, FLRegistration pending, pending cancellationBuilt 2006 · S/N 1663N701LBLima Bravo Aviation LLC · Wilmington, DEBuilt 2010 · S/N AL-1154N701MMErrington Aero LLC · Bellefontaine, OHBuilt 2009 · S/N M-I-2184N701SREffinger Randall J · Watertown, WIBuilt 1992 · S/N 7-1436N701VPMead Donald W · Butte Meadows, CABuilt 1964 · S/N 17251372N70209Garrett Dennis R · Hudson, FLBuilt 1946 · S/N 17185N7020AHale Brian E · Carrollton, MOBuilt 1956 · S/N 29120N7020EWise Rodney J · Brookhaven, MSS/N 56520N70211Rich Richard C · Mc Rae, GABuilt 1946 · S/N 17186N7021EDheedene Nicholas L · San Mateo, CAS/N 56521N7021MCorro Lee A · Holden, MES/N 55321N7021SMountainhawk Leasing LLC · Nampa, IDBuilt 1968 · S/N 15067721N7021TCreamer Johnie M · Rainier, WABuilt 1959 · S/N 46621N7022EReece Steve · Darrington, WABuilt 1960 · S/N 56522N70234Ls Aviators LLC · Wilmington, DEBuilt 1946 · S/N 17210N70238Franks Bryan S · Camarillo, CAFirst renewal noticeBuilt 1946 · S/N 17214N7023GCunningham Kieran G · Newport, RIBuilt 1973 · S/N 15074608N7023KGarrett Craig G · Kentwood, MIBuilt 1989 · S/N 083342N7023TRobertson Rusty · Fresno, CABuilt 1959 · S/N 46623N70241Skyranch Knoxville Youth Inc · Knoxville, TNBuilt 2011 · S/N 16200067N70249Rollins Byron · Daytona Beach, FLBuilt 2011 · S/N 16200068N7024XGresli Mark D · Arlington, WAFirst renewal noticeBuilt 1961 · S/N 15059124N70258Snyder Nicholas · Storm Lake, IABuilt 2011 · S/N 16200072N7025KSpirit Aviation Management Services Inc · Thomson, GABuilt 2011 · S/N 16200069N7025MHelms Everett L · Creighton, MOBuilt 1958 · S/N 55325N70266Dugan Robert J · Boulder City, NVBuilt 1946 · S/N 17247N7026HBas Part Sales LLC · Greeley, COBuilt 2011 · S/N 16200073N7026TInternational City Leasing LLC · El Paso, TXS/N 16200074N70274Two Rays LLC · Charleston, MSBuilt 1941 · S/N 17255N70277Smith David C · Brewster, WABuilt 1946 · S/N 17258N7027FBas Part Sales LLC · Greeley, COBuilt 2011 · S/N 16200078N7027SRed Cessna Aviation LLC · West Valley City, UTS/N 15067727N7027TDeerhaven Trails LLC · Sheridan, WYBuilt 2011 · S/N 16200079N7027WFp Air LLC · Richmond, TXBuilt 2011 · S/N 16200080N7027XWright Michael J Trustee · Santa Ana, CABuilt 1960 · S/N 15059127N70281O'Brien Mark · Anchorage, KYBuilt 1946 · S/N 17262N7028AMazzarese Nicholas · Cedar Hills, UTBuilt 1956 · S/N 29128N7028EHeidebrink Ronald · Loris, SCS/N 56528N7028FCrabb John R · Cincinnati, OHBuilt 2011 · S/N 16200081N7028LGodbold Larry · Tarpon Springs, FLBuilt 2011 · S/N 16200082N7028TFoster Chase · Mountain View, MOS/N 46628N70294Somerville James Phillip · Anchorage, AKBuilt 1946 · S/N 17370N7029ELewis Stephen · Lebanon, ORS/N 56529
Back to AD 94-05-05 R1