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.

N926AWeishaar Wallace O · Livingston, TXBuilt 1951 · S/N 22-229N92700Brady Charles I · Soldotna, AKFirst renewal noticeS/N 12-133N9270DDowns Dennis D · Sterling, AKS/N 18-6569N92713Laughter John Eric · Brookhaven, GABuilt 1946 · S/N 12-148N92719Mood Glen M · Ward Cove, AKBuilt 1946 · S/N 12-155N9271DGrasser Edward K · Palmer, AKBuilt 1958 · S/N 18-6572N92727Routh David A · New Richland, MNS/N 12-163N9272DMummy Mountain Med LLC · Paradise Valley, AZBuilt 1958 · S/N 18-6573N92731Plane@Work LLC · Blaine, MNBuilt 1946 · S/N 12-167N92732Hagman Jeffrey W · St Bonifacius, MNBuilt 1946 · S/N 12-168N92733Airborne Extreme LLC · Wasilla, AKBuilt 1946 · S/N 12-170N92736Larkin Marion J · Salome, AZBuilt 1946 · S/N 12-173N9273PNormark Nancy B · Weirsdale, FLBuilt 1972 · S/N 18-8994N92740Sandstrom David E · Anchorage, AKS/N 12-177N92742Graber Paul E · Brooksville, MSBuilt 1946 · S/N 12-180N92748Mullins Esten R · El Paso, TXS/N 12-186N9274DBlatter Leland L · Hamilton, MTBuilt 1958 · S/N 18-6577N92751Allred Gina D Administrator · Centre, ALBuilt 1946 · S/N 12-191N92752Posey Timothy L · Shirley, ARBuilt 1946 · S/N 12-193N92754Kenney Alexander P · Fayetteville, ARBuilt 1946 · S/N 12-195N92763Bump Jennifer P · King Salmon, AKBuilt 1946 · S/N 12-207N92769Aero Bear Aviation LLC · Atlanta, GABuilt 1946 · S/N 12-214N9276DGilstrap Mathew W · Cotopaxi, COBuilt 1958 · S/N 18-6579N92772Skyward Aviation Enterprises LLC · Raleigh, NCBuilt 1946 · S/N 12-218N92774Anderson Paul D · Anchorage, AKBuilt 1946 · S/N 12-220N92775Rector Calvin C · Karlstad, MNBuilt 1946 · S/N 12-221N9277TCrouse Dewayne O · Eagle River, AKBuilt 1946 · S/N 12-157N92781Aircraft Marketing & Leasing LLC · Fairbanks, AKBuilt 1946 · S/N 12-227N92790Smith Aviation LLC · Springer, OKBuilt 1946 · S/N 12-236N92792Arton Brad D · Prairieville, LABuilt 1946 · S/N 12-238N92793Mikkelsen Caleb M · Wasilla, AKBuilt 1946 · S/N 12-239N92794Sanoski Gregory · Talkeetna, AKBuilt 1946 · S/N 12-240N9279DAcw Aviation LLC · Hines, ORS/N 18-6582N927JSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 18-7609143N927TGStacy David D · Chugiak, AKBuilt 1946 · S/N 12-182N9285YUeeck Brett A · Anchorage, AKBuilt 1971 · S/N 18-8919N9286DCaldwell Bob · Columbus, MSBuilt 1958 · S/N 18-6592N928TGNorthward Bound LLC · Anchorage, AKS/N 9937CCN9292ZAbrams Perry · Palmer, AKS/N 186971N9295DStanford Jay H · Anchorage, AKS/N 18-6602N929CEMeyer Jonathan · Douglas, WYS/N 18-5001N929DWGreen Bryan D · Brenham, TXBuilt 1958 · S/N 18-6604N929SCSoloveda LLC · Cut Bank, MTBuilt 1979 · S/N 18-7909002N92SWKilponen Jeffrey G · Cedarville, MIBuilt 1974 · S/N 18-7409030N93001Despain Ken O · Marysville, WABuilt 1952 · S/N 22-722N9301DGrammer Brendan L · Canby, ORS/N 22-6312N9304DKenneson Robert P DBA · Eureka, KSS/N 22-6315N9305ZRegistration Pending · Keizer, ORRegistration pendingBuilt 1956 · S/N 12-2484N9311DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1958 · S/N 22-6322N9312DMcdonald Steve W · Lino Lakes, MNBuilt 1958 · S/N 22-6323
Back to AD 99-01-05 R1