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.

N5289JHansen Larry G · Alliance, NES/N 22-654N5289ZHenson Robert A · Mcloud, OKS/N 22-8985N5290ZColeman Kyle M · Sisters, ORBuilt 1961 · S/N 22-8986N5291ZBay Area Recreational Flyers LLC · Midland, MIBuilt 1961 · S/N 22-8989N52920Ward David K · Enumclaw, WAS/N 5-1427N5292HHartmann Lucas A · Barrington, ILBuilt 1949 · S/N 16-96N5292ZHayes David A · Steward, ILBuilt 1961 · S/N 22-8992N5293HPierce Stephan · Graham, TXBuilt 1949 · S/N 16-97N5294HWingo John W Jr · Washington, DCBuilt 1949 · S/N 16-98N5294ZMorpeth Dorinda · Fortson, GABuilt 1961 · S/N 22-8994N5295ZFawcett Debra K · Baraboo, WIBuilt 1961 · S/N 22-8995N5297YBlotsky Jim Darin · Fargo, NDBuilt 1963 · S/N 18-8022N5299ZWilliams Robert M · Red Hook, NYBuilt 1961 · S/N 22-8786N52TSFox Whiskey Inc · Wilmington, DEBuilt 1946 · S/N 12-1454N52YCMx4 Investments LLC · Kilgore, TXS/N 18-1038N5300HStanton David R · Washougal, WABuilt 1949 · S/N 16-111N5300ZThissell David W · Plymouth, MABuilt 1961 · S/N 22-9002N5302ZLee Ronald Earl Jr · Stokesdale, NCBuilt 1961 · S/N 22-9005N5304HMyakka Head Aviation LLC DBA · Bradenton, FLBuilt 1949 · S/N 16-108N5305HMarlatt Daniel L · Susanville, CAFirst renewal noticeS/N 16-109N5306HWroe Daniel C · Denton, MDBuilt 1949 · S/N 16-110N5309HZeis Patrick J · Albany, MNBuilt 1949 · S/N 16-114N5309ZNorth Central Aircraft Sales · Tioga, NDS/N 22-9012N530AKDay Bill · Conroe, TXBuilt 1956 · S/N 18-4385N5310ZStoller Russell L · Algoma, WIBuilt 1961 · S/N 22-9013N5311ZWhitley Wes A · Dumas, TXBuilt 1961 · S/N 22-9014N5313HRizzo Joseph A · Akron, NYBuilt 1949 · S/N 16-118N5313ZMartinez Milton E · Fort Lauderdale, FLS/N 22-9017N5315ZGates Steven F · Rockford, ILS/N 22-9019N5316HGade Dale A · Antioch, ILBuilt 1949 · S/N 16-121N5316ZMarshall Jesse A · Moab, UTBuilt 1961 · S/N 229020N5317ZBauman Michael P · Toronto, OHS/N 22-9021N5318HZefting Brett M · Bellingham, WABuilt 1949 · S/N 16-123N5318WSouthern Cub & Aircraft Restoration LLC · Pensacola, FLS/N 18-2868N5320GStroup David J · Alliance, OHBuilt 1953 · S/N 18-2326N5320HMiller Lorin D · Colo, IAS/N 16-125N5320ZLand Cecil J · Goshen, KYBuilt 1961 · S/N 22-9024N5321HNurge Richard J · Gilroy, CAS/N 16-126N5321ZAyers Mark T · Whitney, TXBuilt 1961 · S/N 22-9025N5322YKeil Carl · Granbury, TXBuilt 1963 · S/N 18-8048N5322ZHall Rodney R · Portsmouth, VABuilt 1961 · S/N 22-9026N5325HAdams William Carter · Macon, GAS/N 16-130N5326HVan Zant Timothy L · Nenana, AKBuilt 1949 · S/N 16-131N5327HNass Michael F · Clinton, IABuilt 1949 · S/N 16-132N5329ZCline Wade J · Reno, NVBuilt 1962 · S/N 22-9034N5331ZDaye Jeffrey E · Salisbury, NCBuilt 1962 · S/N 22-9038N5332ZGulley Mark E · Guntersville, ALBuilt 1961 · S/N 22-9041N5333HMcchristian Jerome M · Granbury, TXS/N 16-139N5333ZRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1961 · S/N 22-9042N5334ZUeeck Robert D · Minnetonka, MNS/N 22-9044
Back to AD 99-01-05 R1