OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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-05-13-R1-WD')
    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-05-13-R1-WD')
  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.

N9324YHart Aviators LLC · Sparks, NVBuilt 1960 · S/N D-6528N9325YSimpkins Larry D · Danville, KYBuilt 1960 · S/N D-6529N9326YHand Timothy P · Osage Beach, MOBuilt 1960 · S/N TD-443N9327YEpley John F · Enid, OKBuilt 1960 · S/N D-6581N9334SFontaine & Associates Inc · Pearl, MSBuilt 1975 · S/N MC-347N9335SKeep Climbing LLC · Las Vegas, NVS/N M-1642N9337SDalton Stephen P · Lewistown, PABuilt 1975 · S/N M-1655N9338SGentilin Glen R · Camino, CABuilt 1975 · S/N M-1643N9338YSingleton Jude G · Spring Branch, TXBuilt 1960 · S/N D-6542N933ARah Aviation Inc · Fort Myers, FLBuilt 1991 · S/N CE1568N933GMMartin Jonathan W · West Grove, PAS/N BA-533N933JL&N Aviation LLC · Wilmington, DEBuilt 1990 · S/N CE1448N933QBates Leonard M · Folsom, CABuilt 1961 · S/N D-6827N933TMPlanet Aviation LLC · Pinehurst, NCS/N CE-1744N933WDGuadagni Carlo · Golden, COBuilt 1963 · S/N D-7206N9340QH O C Investments LLC · Garden City, KSBuilt 1971 · S/N TC-1412N9340SGarbade Richard L · Martinez, GAS/N MC-349N9340YWaters Kenneth A · Pleasant Hill, CABuilt 1960 · S/N D-6545N9341SSantos Eric G · West Oneonta, NYBuilt 1975 · S/N M-1644N9343QMorris Mark · Jasper, GABuilt 1971 · S/N D-9304N9344SScram Branden L · Fairbanks, AKBuilt 1975 · S/N MB-778N9345SEvans Brian W · Laceys Spring, ALBuilt 1975 · S/N MC-355N9345YDana Aviation LLC · Mesa, AZBuilt 1960 · S/N D-6549N9346SWilson Ronald Q · Claremore, OKBuilt 1975 · S/N M-1645N9347YNelson Forrest W · Amherst, NHBuilt 1960 · S/N D-6552N9349YTravel Air Inc · Bayville, NJBuilt 1960 · S/N TD-445N934DZellers Clyde E · Springfield, ILBuilt 1956 · S/N D-4670N934PCBennell Ltd LLC · Naples, FLBuilt 2002 · S/N E-3448N934VFinke Wailes · Charleston, MSBuilt 1975 · S/N D-9739N934ZBAnduze Helicopter LLC · Royal Palm Beach, FLS/N TE-314N9351QBaldwin Joseph · Stow, MABuilt 1971 · S/N CE-351N9351SHauling Ag Inc · Middlebury, INBuilt 1975 · S/N MB-769N9352QVoges Airlines LLC · Millstadt, ILBuilt 1971 · S/N CE-352N9354SLinda Ann Trust LLC · Dover, DES/N M-1654N9355SBestway Pilot Car LLC DBA · Metropolis, ILBuilt 1975 · S/N M-1656N9356SHeman Christopher M · Lees Summit, MOBuilt 1975 · S/N M-1657N9357SWeiser Denis P · Osceola, IABuilt 1975 · S/N MC-354N9358SAnderson Justin T · Franklin, OHBuilt 1975 · S/N M-1658N9358YBruce Mkristo · Mesa, AZBuilt 1960 · S/N D-6559N935JWGross Todd D · Minden, NVBuilt 1982 · S/N E-1945N9360SWitt Dan W · Lancaster, SCS/N M-1659N9360YZapata Joseph B · Deland, FLBuilt 1960 · S/N D-6476N9361Q61q LLC · Brookfield, WIBuilt 1971 · S/N CE-359N9361SAviation Services LLC · Oshkosh, WIBuilt 1975 · S/N M-1660N9363QPearson James Clyde · Lake Junaluska, NCS/N CE-360N9363SDtb Holdings LLC · Cheyenne, WYBuilt 1975 · S/N MC-359N9366YMoss Douglas M Trustee · Reno, NVBuilt 1960 · S/N D-6509N9369SLindauer Curt C III · Belleville, ILBuilt 1975 · S/N MC-363N936ACBiggs Aircraft East LLC · Deland, FLBuilt 1971 · S/N CE-336N936PHataway Clayton Scott · Leesburg, VABuilt 1985 · S/N E-2244
Back to AD 99-05-13 R1 WD