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.

N6013DBennett Garrett Douglas · Bonners Ferry, IDBuilt 1956 · S/N 22-4665N6016DWells Roger M · Stratford, TXBuilt 1956 · S/N 22-4669N6016ZPrestenbach Kyle A · Vacherie, LAS/N 25-19N6018DBader Ronald W · Montrose, MIBuilt 1956 · S/N 22-4671N6019DKuper Carl J II · Dalhart, TXBuilt 1956 · S/N 22-4672N6020DDufreche David S · Sanger, TXBuilt 1956 · S/N 22-4673N6021ZAerial Banners Inc · Pembroke Pines, FLS/N 25-25N6023DBusta Daniel N · Los Angeles, CABuilt 1956 · S/N 22-4676N6024DPunt Matthew L · Wasilla, AKBuilt 1956 · S/N 22-4677N6027DSnyder Logan J · Wasilla, AKBuilt 1956 · S/N 22-4680N6029DRonnie L Tremain · Sherwood, ORBuilt 1956 · S/N 22-4682N602AKimberlin Lisa · San Francisco, CABuilt 1951 · S/N 22-5N6030DKnipper Larry R · New Lenox, ILBuilt 1956 · S/N 22-4683N6031DCeruto Jorge · Auburndale, FLS/N 22-4684N6035ZAerial Banners Inc · Pembroke Pines, FLBuilt 1959 · S/N 25-42N6036SHawkins Transportation LLC · Anchorage, AKBuilt 1957 · S/N 18-5684N6037DDale Steven L · Monrovia, CABuilt 1956 · S/N 22-4690N6038DDiscovery Bay Aviation LLC · Port Townsend, WAFirst renewal noticeBuilt 1956 · S/N 22-4691N6039ANflight Technology LLC · Homer, AKBuilt 1979 · S/N 18-8009045N6039DPapp Adina M · Fort Edward, NYBuilt 1956 · S/N 22-4692N6043DDown And Green LLC · Trenton, MIBuilt 1956 · S/N 22-4696N6045DBigby Greg A · Reno, NVBuilt 1956 · S/N 22-4698N6046DSlaughter Don Wayne · Farmville, NCBuilt 1957 · S/N 22-4699N6047ZValley Soaring Club · Middletown, NYBuilt 1959 · S/N 25-54N6048DHightower Samantha Gail · Kenai, AKFirst renewal noticeBuilt 1956 · S/N 22-4701N6049DWalker John A · Kotzebue, AKS/N 22-4702N6049ZLockwood Shawn O · Volborg, MTBuilt 1959 · S/N 25-56N604AMcmurtrey Loy D · Mountain Grove, MOBuilt 1951 · S/N 22-7N6052ZJackson Paul D · Phoenix, AZBuilt 1959 · S/N 25-59N6053ZSlack Brenda · Norfolk, VABuilt 1959 · S/N 25-60N6058DJohnson Aaron J · Lewiston, IDBuilt 1956 · S/N 22-4711N6058ZBlackstone Aircraft LLC · Hartselle, ALBuilt 1960 · S/N 25-18N6060DHughes Truman C · Delta Junction, AKBuilt 1956 · S/N 22-4713N6062ANelson Stephen H · Apple Valley, MNS/N 18-8009046N6062DKeeler Robert C · Scottsdale, AZS/N 22-4715N6064DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1956 · S/N 22-4717N6066DDaily John F · Chugiak, AKBuilt 1957 · S/N 22-4719N6068DThorn Blake A · Coupeville, WAS/N 22-4721N606AAero Services Lc · Woods Cross, UTS/N 22-9N6071DRiffle Thane G · Addy, WABuilt 1956 · S/N 22-4725N60733Rentner Judith E · Bigfork, MTS/N 18-3366N6073DDetrick Louis F · Eighty Four, PABuilt 1956 · S/N 22-4727N6076DPinnow Andrew W · Cheshire, CTBuilt 1956 · S/N 22-4730N6077DPargman Curtis A · Big Lake, MNBuilt 1957 · S/N 22-4731N6078DWagar Dennis Murphy · Marion, MTBuilt 1957 · S/N 22-4732N6079ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-91N6083ABilton Aircraft Management Inc · Umatilla, FLBuilt 1979 · S/N 18-8009048N6084DCsapos Larry G · Ovid, MIBuilt 1957 · S/N 22-4738N6088DSale Reported · Langley, WASale reportedBuilt 1956 · S/N 22-4742N6089DHoyt William C · Trimble, MOBuilt 1956 · S/N 22-4743
Back to AD 99-01-05 R1