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.

N7332ZHaggland James R · Fairbanks, AKBuilt 1966 · S/N 18-8401N7333KGreen Francis E · Frankfort, NYBuilt 1950 · S/N 20-240N7333ZSoaring Society Of Dayton Inc · Waynesville, OHBuilt 1965 · S/N 25-3281N7335KPeterman Karen S · Holiday, FLBuilt 1950 · S/N 20-243N7336DJohnson Dale M · Seminole, TXBuilt 1957 · S/N 22-5125N7336ZBruegger Traylin T · Lance Creek, WYBuilt 1965 · S/N 25-3285N7337LKiehl Flying Service LLC · Winnett, MTBuilt 1975 · S/N 18-7509047N7339KMendez Jessica A · Jacksonville, FLBuilt 1950 · S/N 20-247N734United States Department Of Agriculture · Cedar City, UTBuilt 1956 · S/N 18-5258N7341DDunn Steven J · Youngsville, PAFirst renewal noticeBuilt 1957 · S/N 22-5130N7342LPalmer Ronald E Trustee · Bristol, NHBuilt 1975 · S/N 18-7509048N7343DRautio Mitchell M · Bemidji, MNS/N 22-5132N7343LAir Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18-7509049N7345ZQuicksilver Air Inc · Fairbanks, AKBuilt 1965 · S/N 18-8307N7347DOwens Tyle M · Kenai, AKBuilt 1957 · S/N 22-5138N7348LMcmahan Harley B · Gakona, AKBuilt 1975 · S/N 18-7509050N7348ZPittsburgh Soaring Association · Pittsburgh, PABuilt 1965 · S/N 25-3299N7349KWimberly Fred N · Callao, VABuilt 1950 · S/N 20-256N7350KSmith Randy Kayle · Vancouver, WABuilt 1950 · S/N 20-258N7350ZScott Ts Ag Flyin Inc · Colquitt, GABuilt 1965 · S/N 25-3302N7351KFordham Gary B · Goldsboro, NCBuilt 1950 · S/N 20-259N7353KIvey Thomas S · Gladewater, TXS/N 20-261N7354DKerven Enterprizes Inc · Butler, PABuilt 1957 · S/N 22-5150N7355DSlavens Trent S · Whitehall, MIS/N 22-5151N7357DColton F D · Canby, ORBuilt 1957 · S/N 22-5155N7358DBagley S G · Suwanee, GABuilt 1957 · S/N 22-5156N7358ZKingsley Kiman J · Miller, MOBuilt 1965 · S/N 25-3311N7360DMettler Daniel G · Menno, SDBuilt 1957 · S/N 18-5720N7365DHastings Heidi Rachelle · Wasilla, AKBuilt 1957 · S/N 18-5728N7365KKnutsen Wayne R · Tioga, NDBuilt 1950 · S/N 20-274N7366ZAerial Banners North Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3320N7367DHoelscher Rodney N · San Angelo, TXS/N 18-5730N7367KSpivey Harold E · Thomaston, GABuilt 1950 · S/N 20-276N7367ZAerial Banners North Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3321N7368KLahn James A · Bemidji, MNS/N 20-277N7369KRidings Dustin Eugene · Oconto, WIBuilt 1950 · S/N 20-278N7370KWhitney Aviation LLC · Watertown, SDBuilt 1950 · S/N 20-279N7370ZOmaha Soaring Club Inc · Omaha, NEBuilt 1965 · S/N 25-3325N7371DLohse Teal K · Cordova, AKBuilt 1957 · S/N 18-5736N7371KWagner Stanley M · Terra Ceia, FLBuilt 1950 · S/N 20-280N7372ZLong Island Soaring Assn · Yaphank, NYBuilt 1965 · S/N 25-3328N7373DKramer William L · Big Lake, AKBuilt 1952 · S/N 18-5738N7373ZRed Willow Aviation & Spraying Inc · Mccook, NEBuilt 1965 · S/N 25-3329N7374ZQuality Aviation Inc · Marana, AZBuilt 1965 · S/N 25-3330N7375DWright Joesph W · Eagle River, AKBuilt 1957 · S/N 18-5740N7376DZimmer Chris P · Upham, NDBuilt 1957 · S/N 18-5741N7378KBeen Flyin LLC · Colchester, CTBuilt 1950 · S/N 20-287N7380DKirby Robert H · Hallsville, TXBuilt 1957 · S/N 18-5745N7382DSchneider Aerial Inc · Rugby, NDBuilt 1957 · S/N 18-5747N7384DSteinbrecher Kevin · North Pole, AKS/N 18-5749
Back to AD 99-01-05 R1