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.

N9281UOtters Heinrich · Fredericksburg, TXBuilt 1976 · S/N 15078231N92825Phillips Joshua D · Sylvania, GABuilt 1946 · S/N 1621N92827Dexter Fred H · Live Oak, FLS/N 1623N9282AWest Sheryl M · Champlin, MNBuilt 1949 · S/N 19043N9282USchur David · Lavernia, TXBuilt 1976 · S/N 15078232N92830Deroos John T · Mammoth Spring, ARBuilt 1946 · S/N 1626N92833Rauch Karl W · Fredericksburg, VAS/N 1629N9284BBeckley Larry · Scottsburg, INBuilt 1958 · S/N 55084N9286ASimon Theodore E · Richmond, MIBuilt 1949 · S/N 19048N9286BHall Leslie E · Lubbock, TXS/N 55086N9289BWoodstock Aircraft Services Inc · White Lake, NYBuilt 1958 · S/N 55089N928HPeterson Michael A · White Salmon, WABuilt 1964 · S/N 17251734N92901Learn Build Fly Inc · Wausau, WIS/N 1632N92902Palmenteri Louis J · Rhome, TXBuilt 1946 · S/N 1633N92904Ledbetter Tim A · Tahlequah, OKBuilt 1946 · S/N 1635N92905Air East Aviation Inc · New Castle, DES/N 1636N92906Hornick Joel Richard · Corry, PABuilt 1946 · S/N 1637N92907Scarola Michael · Danbury, CTBuilt 1946 · S/N 1638N9290BFitts Roger W · Independence, ORBuilt 1958 · S/N 55090N92911Pioneer Flight Museum · Kingsbury, TXBuilt 1946 · S/N 1643N92914Johnson Gregory A · Greenbush, VABuilt 1946 · S/N 1646N92915Brown Courd E · Warr Acres, OKS/N 1647N92916Farmer Larry A Trustee · Salina, KSBuilt 1946 · S/N 1648N92918Farrell Donald A · Owasso, OKBuilt 1946 · S/N 1650N9291AEvans James · Tuolumne, CABuilt 1949 · S/N 19052N9291BVan Meerveld Dwight E · Poplar Grove, ILBuilt 1958 · S/N 55091N92920Dexter Fred H · Live Oak, FLBuilt 1946 · S/N 1855N92921Dixon Tom N · Lodi, CAS/N 1653N92923Heise Erick B · Dexter, NYBuilt 1946 · S/N 1655N92924Dreyer Elwain C · Cardington, OHFirst renewal noticeS/N 1656N92926Morris Thomas B · Imlay City, MIBuilt 1946 · S/N 1658N92927Farmer Larry A Trustee · Salina, KSBuilt 1946 · S/N 1659N92930Cornelius Jerry M · Addison, ALBuilt 1946 · S/N 1662N92932Michael S Bailey · Sarasota, FLBuilt 1946 · S/N 1664N92940Kettunen Alan C · Ashtabula, OHBuilt 1946 · S/N 1672N92941Linkous James P · Ancho, NMBuilt 1946 · S/N 1673N92953Sherman Randy S · Potsdam, NYBuilt 1946 · S/N 1686N92954Brosseau Jon A · Pebble Beach, CABuilt 1946 · S/N 1687N92960Hilgendorf Ross E · Welcome, MNBuilt 1946 · S/N 1693N92962Yoder James J · Canby, ORS/N 1695N92968Mallow David N · Rio, WVBuilt 1946 · S/N 1701N9296BColby Robert D · Bigfork, MTBuilt 1958 · S/N 55096N92971Tostenrud Steven · Billings, MTBuilt 1946 · S/N 1704N9297UNorthwest Wings LLC · Hillsboro, ORBuilt 1976 · S/N 15078247N92982Gould William R · Eagle River, AKBuilt 1946 · S/N 1716N92988Fraser William G · Berkley, MABuilt 1946 · S/N 1722N9298AHenderson Larry V · Highland Village, TXBuilt 1949 · S/N 19059N92997Barger Albert L · Windsor, WIBuilt 1946 · S/N 1731N92999Skyranger LLC · Marshall, MNBuilt 1946 · S/N 1733N929FMParker Johnny W · Murray, KYBuilt 1957 · S/N 7FC-5
Back to AD 94-05-05 R1