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.

N76550Cebelak William G · Kent City, MIBuilt 1946 · S/N 10986N76555Vancil Jon D · Collierville, TNBuilt 1946 · S/N 10991N76558Parr William R Jr · Mason, TXBuilt 1946 · S/N 10994N7655TMorrell Nathaniel A · Pelham, GABuilt 1960 · S/N 47255N7655USitta Donald C · Farmington, NMBuilt 1976 · S/N 15077781N7655XMedical Surgical Clinic LLC · Fort Scott, KSBuilt 1960 · S/N 17248155N76565Peterson Dean · Gothenburg, NEBuilt 1946 · S/N 11001N76567Reavis Paul B · Gatesville, TXBuilt 1946 · S/N 11003N7656MSparrowhawk Aviation · Manvel, TXFirst renewal noticeBuilt 1959 · S/N 55956N7656XMiranda Maria J · Santa Maria, CABuilt 1960 · S/N 17248156N76573Conrad Nicholas A · Midlothian, TXBuilt 1946 · S/N 11009N76575Ibrahim George F · Redwood City, CAS/N 11011N76578Macdonald Thomas L · Laveen, AZBuilt 1946 · S/N 11014N7657GDodd Brian G · Mount Vernon, SDBuilt 1973 · S/N 15074711N7657TGuarno Adam C · Milton, FLBuilt 1960 · S/N 47257N7657XGordon Christopher R · Moose Pass, AKBuilt 1960 · S/N 17248157N76581Lee Marc T · Farmers Branch, TXS/N 11021N76585Anderson Thomas M · Fairbanks, AKS/N 11025N7658URegistration Pending · Oregon City, ORRegistration pendingBuilt 1976 · S/N 15077784N76591Dessertier · San Diego, CABuilt 1946 · S/N 11031N76596Jerome Jeffrey A · Conneaut Lake, PABuilt 1946 · S/N 11036N7659TKano Yoshio W · Barrington, ILBuilt 1960 · S/N 47259N765LDBoisvert Robert R · Gardner, MABuilt 2011 · S/N 16200130N76600Benda Carl III · Colorado Springs, COBuilt 1946 · S/N 11040N76603Dunn Ward A · Columbia, SCBuilt 1946 · S/N 11043N76608Widewings LLC · Alexandria, VABuilt 1946 · S/N 11048N7660XAdams John S · Roselle, ILBuilt 1960 · S/N 17248160N76611Peach Daniel J · Rockvale, TNBuilt 1946 · S/N 11051N76613Hunter Joseph · Myrtle Beach, SCBuilt 1946 · S/N 11053N76616Farnham Jesse J · Middlebury, CTBuilt 1946 · S/N 11056N76617Martz Gary Rodney · Frederick, MDS/N 11057N76619Pitman Marvin L · Harrah, OKBuilt 1946 · S/N 11059N7661MPaul Gregory A · Overland Park, KSBuilt 1959 · S/N 55961N7661USweitzer Cameron D · Warrensburg, MOBuilt 1976 · S/N 15077787N76621Couch John · Sunman, INBuilt 1946 · S/N 11061N76624Missionair Inc · Danbury, CTS/N 11064N76625Brunner Thomas W · Manitowoc, WIFirst renewal noticeBuilt 1946 · S/N 11065N76628Elhandt Bryan A · Missoula, MTBuilt 1946 · S/N 11068N76629Liggett L Michael · El Dorado, KSBuilt 1946 · S/N 11069N7662TTriana David · Goose Creek, SCBuilt 1960 · S/N 47262N7662UMcintyre James C · Bethlehem, PABuilt 1976 · S/N 15077788N76630Mosley Jessie W · Heber Springs, ARBuilt 1946 · S/N 11070N76632Satanta Flying Service Inc · Satanta, KSBuilt 1946 · S/N 11072N76633Burkey Richard A · Wagener, SCBuilt 1946 · S/N 11073N76634Blunk Roger C · Wheatland, IABuilt 1946 · S/N 11074N76635Plane Air LLC · Paducah, KYBuilt 1946 · S/N 11075N7663MRashid Shahn S · Clear, AKBuilt 1959 · S/N 55963N7663TTc Flight LLC · Lincoln, NES/N 47263N76644Call One Inc · Clarinda, IABuilt 1946 · S/N 11084N76645Mcleod Chad H · Sumter, SCBuilt 1946 · S/N 11085
Back to AD 94-05-05 R1