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.

N5689HChristie Ian A H · Limon, COS/N 16-301N5689ZNichols Troy G · Clinton, ARS/N 22-9522N568MCow Bell LLC · Sterling, AKBuilt 1946 · S/N 12-952N5690HBackus-Flint Judith A · Blanchard, MIBuilt 1949 · S/N 16-302N5692HHarma Michael J · Ironwood, MIBuilt 1949 · S/N 16-303N5693HDorsay Edward R · Memphis, TNBuilt 1949 · S/N 16-304N5693ZRustin Cody W · Reynolds, GABuilt 1962 · S/N 22-9527N5696HVaughan William R IV · Benton, MSBuilt 1949 · S/N 16-307N5697ZLink James L · Raleigh, NCS/N 22-9532N5699HHalmans John D · Baker, MTS/N 16-310N569WHGp Cub Air LLC · Sioux Rapids, IABuilt 1965 · S/N 18-8271N56DWReed John S · Wasilla, AKS/N 18-7709159N56LGLake Skippers LLC · Park Rapids, MNBuilt 1976 · S/N 18-7609051N5702HMorrissey Philip A · Templeton, MABuilt 1949 · S/N 16-313N5702ZVanhouten Christian J · Tunkhannock, PABuilt 1962 · S/N 22-9540N5703HLauda Thomas J · Des Moines, IABuilt 1949 · S/N 16-314N5704HMcbride Robert W Jr · Cedar Park, TXBuilt 1949 · S/N 16-315N5704ZSmalbergher Dorin · Soldiers Grove, WIBuilt 1963 · S/N 22-9542N5705DBirdwell Brett M · Lewistown, MTBuilt 1956 · S/N 22-4401N5705HHangar 13 LLC · Winchester, VAS/N 16-316N5706DReese Lonnie E · Talking Rock, GAS/N 22-4402N5706HWhitlock Paul H · Kent, WAS/N 16-317N5707HMooney Timothy · Hedgesville, WVBuilt 1949 · S/N 16-318N5708HGodec David E · Waunakee, WIBuilt 1949 · S/N 16-319N5708ZSantee Steven J · Ellendale, MNBuilt 1962 · S/N 22-9547N5709HSmith Zac A · Mill Valley, CAS/N 16-320N5709ZBettilyon Walter S · Shady Shores, TXBuilt 1963 · S/N 22-9548N5710ZSpangler David G · New Richmond, WIBuilt 1962 · S/N 22-9549N5711DEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4407N5712DLo Jeffrey G · San Jose, CABuilt 1956 · S/N 22-4408N5712ZVollmerhausen Otto J · Bethpage, NYBuilt 1963 · S/N 22-9551N5714DAnte George Sherman Jr · Eagle River, AKBuilt 1956 · S/N 22-4410N5714HThomsen Michael · Pleasanton, CAS/N 16-326N5715DScootair LLC · Alburgh, VTS/N 22-4411N5715HReuhl Kenneth R · Piscataway, NJBuilt 1949 · S/N 16-327N5715ZProper Theron · Arlington, AZBuilt 1963 · S/N 22-9554N5716DNeumayer Barry A · Redlands, CABuilt 1956 · S/N 22-4412N5716HLeaders Flying Service LLC · Clear Lake, MNBuilt 1949 · S/N 16-328N5716ZBlue Ridge Soaring Society · New Castle, VAFirst renewal noticeBuilt 1963 · S/N 18-8018N5717DClaxon David W · Gifford, ILS/N 22-4415N5717ZJohnston Charles W C Jr · Newfield, NJBuilt 1963 · S/N 22-9556N5718DBurk Albert A Jr · Parkville, MDBuilt 1956 · S/N 22-4416N5719HPetersen Danny · Caddo, OKBuilt 1949 · S/N 16-331N5720ZIrvine Hollis E Jr · Greenwich, NJBuilt 1963 · S/N 22-9559N5723HValiair Lc Trustee · Casper, WYBuilt 1949 · S/N 16-334N5724HPhillips Thomas D · San Antonio, TXBuilt 1949 · S/N 16-336N5724ZKpa LLC · Kalamazoo, MIS/N 22-9563N5725HPeterson Gordon L · De Pere, WIBuilt 1949 · S/N 16-337N5725ZHolt Gary E · Sandusky, OHBuilt 1963 · S/N 22-9564N5728HBell Jeff J · Merritt Island, FLFirst renewal noticeS/N 16-340
Back to AD 99-01-05 R1