AD 94-05-05 R1

Registered aircraft · 26,230

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.

N9890BSchoettmer Thomas C · Greensburg, INBuilt 1958 · S/N 7FC-210N9890JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N A1500699N9891TDunkley Bret Y · Kotzebue, AKS/N 47691N9894BAscension Flyers Inc · Stillwater, MNBuilt 1958 · S/N 7FC-214N9894JKosko Stanley G · Seattle, WABuilt 1976 · S/N A1500703N9896JVande Berg David M · Sioux Center, IABuilt 1976 · S/N A1500705N9897BMccrorie LLC · Helena, MTBuilt 1958 · S/N 7FC-217N9898THumphress John A III · Campbellsville, KYS/N 47698N9899BSonic Inspection Corp · Edmond, OKS/N 7FC-219N989CCPlanes & Things Inc · Collinsville, OKBuilt 2008 · S/N CC11-00063N989WTArmitage Alan J · Midland, MIBuilt 2004 · S/N 001N98BVUSA Air LLC · Ruskin, FLBuilt 1974 · S/N 15075695N98DTStubby Wings LLC · Eden Prairie, MNBuilt 1947 · S/N 13316N98EJGerard Luke T · Johnson, KSS/N 953N98JPWetstein James M · Anchorage, AKBuilt 1960 · S/N 7JC16N98RBJones Mavin D · Monroe, UTBuilt 1980 · S/N 658N98SSSoutheastern Oklahoma State University · Durant, OKBuilt 1977 · S/N 15079353N98VJKistler Harvey S Trustee · Colby, KSBuilt 2009 · S/N CC11-00085N98ZEMichael Edwin Madison Aircraft LLC · Chattanooga, TNBuilt 2011 · S/N AL-1162N99009Fennig Trevor L · Bryant, INBuilt 1946 · S/N 1632N9900CHolt & Grooms Co Ltd · Carson City, NVS/N S-1N9900YGary E Gylten · Northwood, NDBuilt 1961 · S/N 7FC-440N9901CGritt Bradley · Marseilles, ILBuilt 1957 · S/N S-4N99023May John D · Ward, ARS/N 1646N99039Alesso Casey H · Rosamond, CABuilt 1946 · S/N 1662N9903GCourtney Brooks Streetwise Inc · Avondale, AZFirst renewal noticeS/N A1500456N99049Brown Jeffrey S · Jerome, IDBuilt 1946 · S/N 1672N99050Berry Norman R · Knoxville, TNBuilt 1946 · S/N 1673N99055Ag-Aero Services LLC · Spring Hill, FLBuilt 1946 · S/N 1678N9905AHottois Scott A · Whittemore, MIS/N 19265N9906CCharbonnet Nicolas P · New Iberia, LABuilt 1959 · S/N S-9N9906GNielson Donald L · Independence, ORBuilt 1973 · S/N A1500457N99075Estuarial Medical Consultants · South Boston, VABuilt 1946 · S/N 1698N9907AHuff Steven D · Lake Havasu City, AZBuilt 1950 · S/N 19267N99089Moore Michael W · Tacoma, WABuilt 1946 · S/N 1712N9908AKelly Larry E · Currie, NCBuilt 1950 · S/N 19268N9908CBarker Geoffrey B · Plattsburgh, NYBuilt 1959 · S/N S-11N9908GHarrison Jon Wittmeyer · Port Saint Lucie, FLBuilt 1973 · S/N A1500459N99092Mapes Joseph S · Stevens Point, WIBuilt 1946 · S/N 1715N9909CChase Kenneth Charles Jr · Rochester, MNFirst renewal noticeBuilt 1959 · S/N S-12N990BWBeachy Ronald · Kokomo, INBuilt 2001 · S/N 7809-G716BN990CAJundi Adam · North Royalton, OHBuilt 1976 · S/N 15079158N990SUJeffryes Richard B · Creswell, ORFirst renewal noticeBuilt 1989 · S/N 1005N99112Macario T Michael · Townsend, DEBuilt 1946 · S/N 1735N99115Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1738N99116Hallman Eugene A · Kasota, MNBuilt 1946 · S/N 1739N99117Sanders John L · Sikeston, MOS/N 1740N99119Carpenter William Edward · Mason, TNBuilt 1946 · S/N 1742N9911ADaniels Bayce D · Anthony, NMS/N 19271N9911CSilva Brenda M · Snowflake, AZBuilt 1959 · S/N S-15
Back to AD 94-05-05 R1