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.

N4251MChapin Dean H · Cambridge, NYBuilt 1947 · S/N 12-3145N4251ZCarroll Wilmer Lee · Kerrville, TXFirst renewal noticeBuilt 1966 · S/N 18-8488N4252HHoutz Allen D · Kenai, AKBuilt 1948 · S/N 14-55N4252MRobinson Eric C · Palmer, AKBuilt 1947 · S/N 12-3146N4252ZJohnson Daniel J · Redding, CAS/N 18-8489N4254ZEllingson Leslie B · Harwood, NDBuilt 1967 · S/N 18-8492N4255ZBlake Michael R · Girdwood, AKS/N 18-8494N4256MKcg Aviation LLC · Angola, NYBuilt 1947 · S/N 12-3150N4257HGilman James C · Butte, MTBuilt 1948 · S/N 14-60N4257MBaus Roman J · Rubicon, WIBuilt 1947 · S/N 12-3151N4257ZSmith April A · Anchorage, AKBuilt 1967 · S/N 18-8497N4259HLambe Steven S · Anchorage, AKBuilt 1948 · S/N 14-62N4259MMurray Thomas R · Urbandale, IAS/N 12-3153N425AHHanson B Jake · Jackson, WYBuilt 1946 · S/N 12-817N4260HDevoe Don F · Anchorage, AKBuilt 1948 · S/N 14-63N4260MHelmstadt Ronald J · Bridgeport, MIBuilt 1947 · S/N 12-3176N4262MHoech Neal L · Everett, WABuilt 1947 · S/N 12-3175N4263HSchneider Michael J · Anchorage, AKBuilt 1948 · S/N 14-67N4263MThompson Frank Link · Gordon, NEBuilt 1947 · S/N 12-3178N4263ZPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 18-8493N42644Wingnut Inc · Wilmington, DEBuilt 1945 · S/N 14935N4264ZAllen Steven L · Thatcher, AZBuilt 1967 · S/N 18-8507N4265HAngel Aviation Inc · Peoria, AZBuilt 1948 · S/N 14-69N4265ZBaklarz Ralph B · Eagle River, AKBuilt 1967 · S/N 18-8508N4266ZVan Ryzin Chris K · Sterling, AKBuilt 1967 · S/N 18-8512N4267MMurphy Aaron S · Girdwood, AKBuilt 1947 · S/N 12-3196N4270HShields Edwin G · York, SCBuilt 1948 · S/N 14-75N4271MBenninger Timothy A · Cobleskill, NYS/N 12-3199N4271ZFelmlee Dusty R · Laurel, MTBuilt 1967 · S/N 18-8517N4272HOwen Toy C · Anchorage, AKBuilt 1948 · S/N 14-76N4272ZLightning Leasing LLC · Anchorage, AKBuilt 1967 · S/N 18-8519N4273SCook Raymond L · Spring Grove, ILS/N 18-7118N4273ZHay Stax West · Eureka, NVBuilt 1967 · S/N 18-8520N4274ZJantzen & Jantzen Farming LLC · Madrid, NEBuilt 1967 · S/N 18-8522N4275MHicks Joseph O · Germanton, NCBuilt 1947 · S/N 12-3203N4276HTailwind Aviation Inc · Wasilla, AKBuilt 1948 · S/N 1480N4277MDykema Richard Kenneth · Soldotna, AKS/N 12-3205N4277ZHart Lewis W · Rexburg, IDS/N 18-8525N42785Cornell Andrew S · Jordan, MNBuilt 1945 · S/N 15099N4278HWrigley David C · Anchorage, AKBuilt 1948 · S/N 14-83N4279HDeal Glen K · Palmer, AKBuilt 1948 · S/N 14-84N4279ZSwiss John T · Anchorage, AKBuilt 1967 · S/N 18-8527N4280MCape May Aerial Advertising LLC · Cape May Ch, NJBuilt 1947 · S/N 12-3208N4280ZKamlowsky Scott A · Anchorage, AKBuilt 1967 · S/N 18-8528N4281HWilliams Wendell B · Anchorage, AKBuilt 1948 · S/N 14-86N4282MGlave William C · Deltaville, VABuilt 1947 · S/N 12-3210N4283HRubbert Jan D · Upham, NDBuilt 1948 · S/N 14-88N4283MDavis Roger · Dover, PABuilt 1947 · S/N 12-3211N4283ZHuseby Kelly E · Hulett, WYBuilt 1967 · S/N 18-8530N4284ZBolin Matthew R · Everett, WABuilt 1967 · S/N 18-8532
Back to AD 99-01-05 R1