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.

N8122RAviation Buddy Corp · Incline Village, NVBuilt 1974 · S/N TC-1732N8126NHyder/Zemke LLC · Albuquerque, NMBuilt 1991 · S/N CE-1607N8127RKanok Enterprises LLC · Derby, KSBuilt 1974 · S/N TC-1735N8128NCloudstreet Investments LLC · San Antonio, TXBuilt 1991 · S/N CE-1596N812BGGallo Robert L · Palm Beach Garden, FLS/N E-2960N812ELLambard Luke G · Bossier City, LABuilt 1975 · S/N E-774N812RHeinen Michael J · Mooresville, NCBuilt 1959 · S/N D-5945N812WPMerrell Clayton Lee · Amarillo, TXBuilt 1975 · S/N E-669N8130RGaines Robert G · Howell, MIBuilt 1991 · S/N EA-518N8131HCataldo Michael · Hingham, MAS/N E-2755N8131NArgus Lester M · Margate City, NJBuilt 1991 · S/N CE-1584N8132NBeechit LLC · Prescott, AZBuilt 1991 · S/N CE-1585N8133RAero Tex LLC · Jacksonville, FLBuilt 1974 · S/N CE-543N8133VN8133v LLC · Greenville, NCBuilt 1991 · S/N CE-1569N8134RFolsom Airplane Co LLC · Longwood, FLBuilt 1974 · S/N CE-524N8135NAlbion Air Enterprises LLC · Albion, NEBuilt 1991 · S/N E-2642N8135RKeyt Richard C · Granbury, TXBuilt 1974 · S/N D-9696N8136ERunyon Rodney D · Portland, TNBuilt 1991 · S/N E-2614N8136RDreamstead Recreational Vehicles LLC · Kalispell, MTBuilt 1974 · S/N E-612N8137PFlying Daze · Batavia, OHBuilt 1991 · S/N E-2653N8137RWestdale Aviation LLC · Shreveport, LABuilt 1974 · S/N D-9660N8138RDavenport Clifford M · Bonita, CABuilt 1974 · S/N E-587N8139RStiller David L · Sedona, AZBuilt 1974 · S/N CE-522N813CHBlech Andreas J · Grants Pass, ORBuilt 1973 · S/N D-9536N813MMRc Air Ventures LLC · New York, NYBuilt 2000 · S/N E-3342N813PJBank Of Utah Trustee · Salt Lake City, UTS/N E-3485N8140NViolette James · Glendale, AZBuilt 1992 · S/N CE-1713N8141YTrifunac Alexander D Trustee · Boulder, COBuilt 1991 · S/N CE-1592N8142NSmith Dennis A Trustee · Salem, ORBuilt 1993 · S/N E-2768N8142WByrne Real Estate Group LLC · Charlotte, NCBuilt 1993 · S/N CE-1729N8143JFly Girl Aviation LLC · Little Rock, ARBuilt 1991 · S/N CE-1595N8145RWatch Ya Head Aviation I LLC · Zionsville, INBuilt 1974 · S/N TC-1743N814DBNorth Rock LLC · Wilmington, DEBuilt 1973 · S/N TC-1560N814JCSports Medicine Consulting LLC · Midlothian, VABuilt 1966 · S/N TE-55N814JEEasca LLC · Little Rock, ARBuilt 1956 · S/N DH-106N814JGKrahulik Jon L · Fredericksburg, TXBuilt 1991 · S/N E-2622N814LAAkamo Abiodun T · Line Lexington, PABuilt 1994 · S/N E-2849N814TDWesley Roy W · Carmichael, CABuilt 1977 · S/N E-1085N8152CBonanza52c LLC · Eastsound, WABuilt 1993 · S/N E-2773N8152RElbow Key LLC · Blue Bell, PABuilt 1993 · S/N E-2778N8153GValenzuela Aviation LLC · Little Rock, ARBuilt 1990 · S/N E-2583N8154QShine Hugh D · Temple, TXBuilt 1990 · S/N E-2584N8155RLarson James R · Waupaca, WIBuilt 1976 · S/N TC-1948N8158RFullerton Vtail Partners LLC · Mission Viejo, CABuilt 1974 · S/N D-9665N8159RWiencke John K · San Francisco, CABuilt 1974 · S/N CE-527N815BFN815bf LLC · Westlake Village, CABuilt 1974 · S/N TC-1659N815JTL G T LLC · Bronwood, GABuilt 1976 · S/N CE-688N815KKBristol Aircraft Leasing LLC · Montgomery, ALBuilt 1973 · S/N TC-1521N815LAGarrettgobo LLC · Saint Augustine, FLBuilt 1994 · S/N E-2850N815QSumo Tails Ltd · Wilmington, DEBuilt 1966 · S/N D-8286
Back to AD 99-05-13 R1 WD