AD 94-05-05 R1

Registered aircraft · 26,231

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.

N276AJCrumpton Aviation LLC · Tulsa, OKBuilt 2011 · S/N 16200133N27708Wightman Randy A · Owosso, MIBuilt 1940 · S/N 7643N2770CGuzik James V · Lindstrom, MNBuilt 1954 · S/N 26314N2770LAnderson Curtis Merle · Manson, IABuilt 1982 · S/N 1364N2770SBirk Ronald G · Wellington, NVBuilt 1967 · S/N 15066670N2770UStandard Equipment Leasing And Sales LLC · Wilmington, DEBuilt 1963 · S/N 17250370N2771CKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1954 · S/N 26315N2771EBenton James A · Enterprise, ALBuilt 1946 · S/N 7AC-6355N2771LP&N Corp · Marion, IABuilt 1967 · S/N 17255971N2771NMeyer Corben D · Lafayette, INS/N 13029N2771UTobin Eric L · Cambridge, OHBuilt 1963 · S/N 17250371N2772LBell William E Jr · Summerville, SCBuilt 1967 · S/N 17255972N27732Shadwick Clarence R · Tunnel Hill, GAS/N 7670N2773DHattaway Gene · Double Oak, TXBuilt 1952 · S/N 25315N2773JN2773j LLC · Titusville, FLBuilt 1975 · S/N A1500596N2773NMidwest Corporate Air Inc · Bellefonatine, OHBuilt 1947 · S/N 13031N2774DOutbound Aero LLC · Kiowa, COBuilt 1952 · S/N 25316N2774SPeterson Dennis · Cambridge, MNBuilt 1967 · S/N 15066674N2775KSanders Brian L · Tehachapi, CABuilt 1947 · S/N 5502N2775LKing Mons A · Paoli, PABuilt 1967 · S/N 17255975N2775NSavant Rusty W · Kinder, LABuilt 1947 · S/N 13036N2775SRichardson Arthur · Herald, CAS/N 15066675N2775ULuff John W · Odessa, MOBuilt 1963 · S/N 17250375N2776DAtiyeh Aziz Matthew · Aumsville, ORS/N 25318N2776LRd Aire LLC · Opelika, ALBuilt 1967 · S/N 17255976N2776UGarrison Randy · Queen City, TXBuilt 1963 · S/N 17250376N2777CSteiner Richard D · Butler, PABuilt 1956 · S/N 7BCM-119N2777LHataway Gregory L · Kinston, ALBuilt 1967 · S/N 17255977N2778DBaker Julius W · Anchorage, AKBuilt 1952 · S/N 25320N2778NDunshee Anette M · La Luz, NMBuilt 1947 · S/N 13039N2778SStamper Brian L · Tucson, AZBuilt 1967 · S/N 15066678N2778URoberts Kenneth B · Wall Township, NJBuilt 1963 · S/N 17250378N2779DLumley Carol J · Eagle River, WIBuilt 1952 · S/N 25321N2779LResetar Douglas J · Pittsford, NYBuilt 1967 · S/N 17255979N277CKreikemeier Terry L · Garfield, WABuilt 2017 · S/N 1N277KLCoombs Johnnie · Blue Mountain, MSBuilt 1966 · S/N 15064869N277NWindh Randall · Reedley, CAS/N 28440N277RTGonzalez Edwin A · Scott Afb, ILBuilt 1968 · S/N 15070021N277WSKropp Christian Trustee · Azle, TXBuilt 1977 · S/N F15001406N2780CWheeler Russell E · Roxbury, CTBuilt 1954 · S/N 26324N2780DChythlook Joseph L · Dillingham, AKS/N 25322N2780KNielsen Paul O · Wellington, COBuilt 1947 · S/N 5507N2780NSparkys Flying Service LLC · Warner, NHBuilt 1947 · S/N 13041N2780SNapolitano Frank D · Howell, MIBuilt 1967 · S/N 15066680N2781CRoark Collin P · Franktown, COBuilt 1954 · S/N 26325N2781KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1947 · S/N 5508N2781LEllis Grover Dale Jr · Sanford, NCS/N 19266N2781NLacey Scott M · Morris, ILS/N 13042N2781SGadberry Garth · Heath, TXBuilt 1967 · S/N 15066681N2782CGideon William W · Dayton, OHBuilt 1954 · S/N 26326
Back to AD 94-05-05 R1