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.

N7959TArrow LLC · Pateros, WABuilt 1960 · S/N 56659N7959UShugart Tiffany C · Canfield, OHBuilt 1964 · S/N 17251959N795PSPas Services LLC · Townsend, DEBuilt 2006 · S/N AL-1076N7960BHolte Martin W · Burnsville, MNS/N 29760N7960THayden James R · West Fargo, NDBuilt 1960 · S/N 56660N7961BGmitter Joseph J · Forest Lake, MNBuilt 1957 · S/N 29761N7961TBoardman Thomas M · Greenwich, NYBuilt 1960 · S/N 56661N7961XCarruth Sam · Ripon, CABuilt 1961 · S/N 17248461N7961ZBoho LLC · Lewes, DEBuilt 1963 · S/N 15060061N7962BHall Jason J · Moses Lake, WABuilt 1957 · S/N 29762N7962ENesta Alex · Winder, GABuilt 1959 · S/N 17762N7962FFlying Colors Airparts Inc · Leesburg, FLBuilt 1966 · S/N 15064062N7963BPerkins C Trent Blaise · Wonder Lake, ILBuilt 1957 · S/N 29763N7963TSawyers Susan J · Tazewell, VABuilt 1960 · S/N 56663N7963UKischnick Brett A · Lapeer, MIBuilt 1964 · S/N 17251963N7963XHairetown LLC · Johnson City, TNBuilt 1961 · S/N 17248463N7964XEdwards Jerry T · Palo Pinto, TXBuilt 1961 · S/N 17248464N7965ELangton Kathy A · Exeter, CAS/N 17765N7965ZElliott Frank F · Mojave, CABuilt 1963 · S/N 15060065N7966BBrashar Kevin · Anchorage, AKS/N 29766N7966UPatterson Robert E Trustee · Petaluma, CABuilt 1964 · S/N 17251966N7967BScholz Alan A · Rosamond, CABuilt 1957 · S/N 29767N7967TMachowicz Mark M · Eastpointe, MIBuilt 1960 · S/N 56667N7967XSchneider David L · Saginaw, MIBuilt 1961 · S/N 17248467N7967ZBreckenridge Steven C · Farmington, ILBuilt 1963 · S/N 15060067N7968BWaltz Patrick T · Delanson, NYBuilt 1957 · S/N 29768N7968FFlyin Cowboys · Manning, NDBuilt 1966 · S/N 15064068N7968TSiegel Donald S · Northampton, MABuilt 1960 · S/N 56668N7969BConnolly Patrick J · Skaneateles, NYBuilt 1957 · S/N 29769N7969XBurnham Bros · Winner, SDBuilt 1961 · S/N 17248469N796WTTaildragger LLC · Blackfoot, IDBuilt 1955 · S/N 26813N797Hoctor Ray B Jr · Webster, TXBuilt 1947 · S/N 13124N7970EMckenna Terence M · Scotts Valley, CABuilt 1959 · S/N 17770N7970FConnor Christopher Donnie · Chicago, ILBuilt 1966 · S/N 15064070N7970UChard Robert L · Byron Center, MIBuilt 1964 · S/N 17251970N7971BKimberling David L · Lincoln City, ORBuilt 1957 · S/N 29771N7971UHallstrom Curtis R · Barnesville, OHBuilt 1976 · S/N 15077873N7972ZResley James B · Sierra Blanca, TXS/N 15060072N79731Nicolle Noel T · Gurley, ALBuilt 1944 · S/N 12027N7973EDunham Matthew J · Duarte, CABuilt 1959 · S/N 17773N7973ULewis Mark A · Ozark, ALBuilt 1964 · S/N 17251973N7974BBraymer Jay K · Boerne, TXBuilt 1957 · S/N 29774N7974EJstream Lc · Sheridan, WYBuilt 1959 · S/N 17774N7974FMerriam Hugh M · San Leandro, CABuilt 1966 · S/N 15064074N7974TByers Theresa L · Freedom, CABuilt 1960 · S/N 56674N7974XKalamazoo Flight Instruction LLC · Kalamazoo, MIBuilt 1961 · S/N 17248474N7975UStrickland Paul A · Goleta, CABuilt 1964 · S/N 17251975N7975XGessinger Gregory S · Nappanee, INBuilt 1961 · S/N 17248475N7975ZLansing Community College · Mason, MIBuilt 1963 · S/N 15060075N7977UWittenburg Brandon L · Vancouver, WAS/N 17251977
Back to AD 94-05-05 R1