OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-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:99-01-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.

N8491YRollman Levi S · Wasilla, AKBuilt 1970 · S/N 18-8880N8494DKincaid Jonathan A · Frankfort, MEBuilt 1957 · S/N 22-5721N8498DBig Boy Business LLC · Oklahoma City, OKBuilt 1957 · S/N 22-5725N8499DHolton Randall B · Folley Beach, SCBuilt 1957 · S/N 22-5726N849AScharf Mark T · Rosamond, CAS/N 22-151N8500DScootair LLC · Alburgh, VTBuilt 1957 · S/N 22-5727N8500QEilinger Richard L · Hertford, NCBuilt 1953 · S/N 22-1213N8501DStrausser Brian J · Lower Burrell, PABuilt 1957 · S/N 22-5728N8501LSnider Scott E DBA · Turner, MTBuilt 1969 · S/N 25-4915N8502DConrad Dylan · Randolph, WIBuilt 1957 · S/N 22-5729N8503CScites Robert W · Toney, ALBuilt 1953 · S/N 22-1215N8504LTexas Soaring Association · Midlothian, TXBuilt 1969 · S/N 25-4919N8505DRegistration Pending · Wilmington, DERegistration pendingBuilt 1957 · S/N 22-5732N8507DFischer Duane A · New Baden, ILBuilt 1957 · S/N 22-5734N8508DHuhndorf Joshua L · Port Ludlow, WABuilt 1957 · S/N 22-5735N8509DVeal Petra I · Sterling, AKBuilt 1957 · S/N 22-5736N8510DShipley Steven D · Masterson, TXBuilt 1957 · S/N 22-5737N8510LStewarts Aircraft Service Inc · Waynesville, OHBuilt 1969 · S/N 25-4925N8511CWingsesprit · Columbus, NDBuilt 1953 · S/N 22-1219N8513DRowland Nathan A · Lascassas, TNBuilt 1957 · S/N 22-5740N8514DBecker Gloria J Personal Representative · Gladwin, MIBuilt 1957 · S/N 22-5741N8514LSugarbush Soaring Assn Inc · Warren, VTBuilt 1969 · S/N 25-4931N8516DBass Edward L · San Angelo, TXBuilt 1957 · S/N 22-5743N8517CFrance Gary L · West Salem, OHS/N 22-1228N8518CBoesl Shawn W · Aberdeen, SDBuilt 1953 · S/N 20-993N8518DWood Michael · Port Saint Lucie, FLBuilt 1957 · S/N 22-5745N8519LChicago Glider Club · Minooka, ILS/N 25-4937N8519YAerial Sign North Inc · Lakewood, NJBuilt 1970 · S/N 18-8885N8520CRitzman Todd F · Pewaukee, WIBuilt 1953 · S/N 20-995N8521YVan Devere Joseph C · Akron, OHBuilt 1970 · S/N 18-8886N8522CParylak Sean P · Colchester, CTBuilt 1953 · S/N 22-1230N8522DAdams Daryl S · Monticello, FLBuilt 1957 · S/N 22-5750N8523PTubbs Jeffrey E · Kasilof, AKBuilt 1965 · S/N 18-8298N8524DBig Bend Community College Foundation · Moses Lake, WABuilt 1957 · S/N 22-5752N8524YGasmire David C · Fredericksburg, TXS/N 18-8888N8526KBaratta Richard J · Tower, MNBuilt 1956 · S/N 18-4953N8526ZRyther John W · Austin, MNBuilt 1952 · S/N 20-900N8527CRegistered aircraftBuilt 1953 · S/N 22-1237N8530DCurcio Steve J · Oak Creek, WIBuilt 1957 · S/N 22-5758N8534CSalter Christopher D · Elberta, ALBuilt 1953 · S/N 22-1239N8536DAnderson Kel G · Alta, IABuilt 1957 · S/N 22-5768N8538DMarble Jere D · Dayton, NVBuilt 1957 · S/N 22-5769N8538ZBeechit LLC · Prescott, AZS/N 18-907N8539DEdens Ferlin C · Boone, COBuilt 1957 · S/N 22-5770N8540LMid Mo Ag Air LLC · Boonville, MOBuilt 1969 · S/N 25-4961N8540SChalmers Ashley · Manalapan, NJRegistration ineffective or invalidS/N 18-8540N8543DHuntwork Dayna · Boise, IDBuilt 1957 · S/N 22-5774N8544CNixon H M · Wayne, NJBuilt 1953 · S/N 22-1256N8544DThames James W · Florence, ALBuilt 1957 · S/N 22-5775N8544LMid Continent Aircraft Corp · Hayti, MOBuilt 1971 · S/N 25-5420
Back to AD 99-01-05 R1