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.

N4222MRoberts Alan Wayne · Emmetsburg, IAS/N 12-3118N42239Adkins Clint R · Corvallis, MTBuilt 1945 · S/N 14489N4223MMccrory John D · Marfa, TXBuilt 1947 · S/N 12-3119N4223ZHartman Brian D · Anchorage, AKBuilt 1966 · S/N 18-8447N4224MGiesbrecht Jace K · Lakin, KSBuilt 1947 · S/N 12-3120N4226HAngel Aviation Inc · Peoria, AZS/N 14-29N4226MMeier Wayne N · Eagan, MNS/N 123122N4227MVogt Thomas Earl · Cedarburg, WIBuilt 1947 · S/N 12-3124N4227ZBavarian Barnstormers Inc · North Fort Myers, FLBuilt 1966 · S/N 18-8452N4228ZEastern Aviation Fuels Inc · New Bern, NCBuilt 1966 · S/N 18-8453N4229HGranger Andrew J · Denver, COBuilt 1948 · S/N 14-32N4229MHartman Gregory G · Eagle River, AKBuilt 1947 · S/N 12-3126N4229ZToney William M II · Gig Harbor, WABuilt 1966 · S/N 18-8454N422KAStewart Scott A · Anchorage, AKBuilt 1975 · S/N 18-7509009N422WFRoberts Wayne T · Spring Lake, MIBuilt 1946 · S/N 12-2520N4230ZBishop Mike · Rifle, COBuilt 1966 · S/N 18-8456N42318Turner Sarah Payson · Hickory Corners, MIBuilt 1945 · S/N 14568N4231MHarloff David F · Lehigh Acres, FLBuilt 1947 · S/N 12-3129N4232MHardy Willard H Jr · Lincolnville, MEBuilt 1947 · S/N 12-3128N4233HDetwiler Jeffrey D · Lancaster, PAS/N 14-36N4233MJordan Lee · Dickinson, TXBuilt 1947 · S/N 12-3177N4233ZThompson Lee B · Anchorage, AKBuilt 1966 · S/N 18-8459N4234ZLueking Clyde F · Holdrege, NEBuilt 1966 · S/N 18-8460N42362Francis Ellis H Jr · South Hill, VABuilt 1952 · S/N 22-799N4236HMakar Michael J · Anchorage, AKBuilt 1948 · S/N 14-39N4236MLehman Robert J · Marissa, ILS/N 12-3132N4236ZMinnehan Joseph T · Joplin, MTBuilt 1966 · S/N 18-8462N4237HHolden Daniel N · Anacortes, WABuilt 1948 · S/N 14-40N4237ZYorgason Ty C · Worland, WYS/N 18-8464N4238MRobinson Eric C · Palmer, AKBuilt 1947 · S/N 12-3134N4239ZLsk Aviation Corp · Wilmington, DEBuilt 1966 · S/N 18-8466N4240HSorensen Michael J · Mayer, MNBuilt 1948 · S/N 14-42N4240ZLoomer Orville C · Buffalo, WYS/N 18-8467N4241HSkinner James A · Anchorage, AKS/N 14-44N4241MNichols Matthew W · Ward Cove, AKS/N 12-3136N4242ZWing Robert E · Fairbanks, AKBuilt 1967 · S/N 18-8597N42433Hall James M · Charlottesville, VABuilt 1941 · S/N 14697N4243ZPettit Robert H · Carnegie, OKBuilt 1966 · S/N 18-8471N4245HLlewellyn John M · Monroe, WAS/N 14-48N4245MThornley Timothy C · Anchorage, AKBuilt 1947 · S/N 12-3138N4246HAndrews Tyler E · Anchorage, AKBuilt 1948 · S/N 14-49N4247ZJanvrin Jerry M · Buffalo, SDBuilt 1966 · S/N 18-8476N4248MJohnson Ethan C · Anselmo, NEBuilt 1947 · S/N 12-3142N4249HGapen Patrice M · Cheyenne, WYBuilt 1952 · S/N 14-52N4249MHassell Dan J · Ketchikan, AKBuilt 1947 · S/N 12-3143N4249ZBlomquist Frank O · Salt Lake City, UTFirst renewal noticeBuilt 1966 · S/N 18-8478N424BYSkyline Soaring Club Inc · Front Royal, VABuilt 1968 · S/N 25-4640N424RDTorin Thomas Roschinger · Anchorage, AKS/N 18-5169N42502Stackhouse Mark A · Orwell, OHBuilt 1978 · S/N 18-7809151N4250HMincher Charles Mf · Dillingham, AKBuilt 1948 · S/N 14-53
Back to AD 99-01-05 R1