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.

N89399Registration Pending · Goshen, INRegistration pendingBuilt 1946 · S/N 8431N89400Johnson Ned T · Maplewood, MNBuilt 1946 · S/N 8432N89402Miller Mark A · Vickery, OHBuilt 1946 · S/N 8434N89407Peachey Samuel R · Belleville, PABuilt 1946 · S/N 8439N8940BFlamini Matthew D · Thompsons Station, TNBuilt 1958 · S/N 36640N89411Registration Pending · Chandler, AZRegistration pendingBuilt 1946 · S/N 8443N89416Wright Douglas J · Greenwood, INBuilt 1946 · S/N 8448N8941BBig R Of Greeley Inc · Greeley, COBuilt 1958 · S/N 36641N89426Givens Brian D · Rockwood, TNBuilt 1946 · S/N 8458N8942BBishops Sky Cam LLC · Jonesburg, MOBuilt 1958 · S/N 36642N8942RRichards Penny L · Saint Jo, TXBuilt 1959 · S/N 7FC-382N89435Lucas Caleb D · Rock Port, MOBuilt 1946 · S/N 8467N8943BHarris David B III · Parlier, CAS/N 36643N89447Mariette Brian K · Santa Rosa, CABuilt 1946 · S/N 8479N89450Applegate Ronald E · Rosamond, CABuilt 1946 · S/N 8482N89454England Max W · Doniphan, NEFirst renewal noticeS/N 8486N89457Wansack Mark P · West Middlesex, PAFirst renewal noticeS/N 8489N89458Diel Mark A · Walnut Creek, CABuilt 1946 · S/N 8490N89463Honore Enterprise LLC · Allegan, MIBuilt 1946 · S/N 8495N89466Stopa Gregg · Middletown, NYBuilt 1946 · S/N 8498N89467Rea Family Investments LLC · Colorado Springs, COBuilt 1946 · S/N 8499N8946BLumberjack LLC · Flagstaff, AZBuilt 1958 · S/N 36646N8946RWatson Bobby M · Hoxie, ARBuilt 1960 · S/N 7FC-384N89471Gingerich Dylan M · Mountain Home, IDBuilt 1946 · S/N 8503N89473Gray Billy D · Vaughn, MTBuilt 1946 · S/N 8504N89476Lacharite Joseph N · Warren, MABuilt 1946 · S/N 8507N89479Shannahan Erwin E · Sunnyvale, CABuilt 1946 · S/N 8510N8947BKaczmarek Richard G · Sandersville, GAS/N 36647N8947SMatyas Aviation Inc · Sugarloaf, PABuilt 1965 · S/N 15062247N89480Stoddard Levi Van · Rocky Ford, COBuilt 1946 · S/N 8511N89484Gsp Aviation LLC · Wichita, KSBuilt 1946 · S/N 8516N89488Moeder Denis J · Ocala, FLBuilt 1946 · S/N 8520N89493Craig Larry D · Enon Valley, PAS/N 8525N89495Carson Leonard H · Chesapeake, VABuilt 1946 · S/N 8527N89498Ehmann Stephen L · Grand Rapids, MIS/N 8534N89504Hutto Glen A · Orangeburg, SCBuilt 1946 · S/N 8540N8950BPeppers Denise S · Centre, ALBuilt 1958 · S/N 36650N89510K & M Aviation LLC · West Liberty, KYBuilt 1946 · S/N 8546N89511Krenzke Stephen E · Fairbanks, AKBuilt 1946 · S/N 8547N89516Monks Stephen W · Limon, COBuilt 1946 · S/N 8552N8951RGardner John B · Arlington, INBuilt 1960 · S/N 385N89521Spangler Taylor · Andover, KSBuilt 1946 · S/N 8557N89523Gramann Steven G · Hartland, WIBuilt 1946 · S/N 8559N89529Johnson Ryan · Willits, CABuilt 1946 · S/N 8565N8952RBaker Charles L · Swartz Creek, MIFirst renewal noticeBuilt 1960 · S/N 7FC-386N89530Bradshaw David T · Tuscola, TXBuilt 1946 · S/N 8566N89535Clayton Howard N · Hartstown, PABuilt 1946 · S/N 8571N89537Ackerman Garry · Plano, TXBuilt 1946 · S/N 8573N8953TDouglass Jason E · Friday Harbor, WABuilt 1959 · S/N 47158N89544Registered aircraftBuilt 1946 · S/N 8580
Back to AD 94-05-05 R1