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.

N5513DManross Marquardt Ltd Partnership · Mesa, AZBuilt 1957 · S/N D-5070N5515DRichards Paul M · Chicago, ILBuilt 1957 · S/N D-5073N5517DTillman Fred L · Lakeland, FLBuilt 1957 · S/N D-5044N5519ABiersack Alexander J · BerlinBuilt 1989 · S/N CE-1337N5519UBurlington Veterinary Systems LLC · Burlington, KSBuilt 1990 · S/N E-2519N551BW602 Xx LLC · Springdale, ARBuilt 1990 · S/N CE-1431N551DBKirby Ramsey Aviation Group LLC · Almont, COBuilt 1998 · S/N E-3158N551GJanes Christopher D · Columbia, KYBuilt 1968 · S/N D-8772N551JACalderon Gustave P · Carlsbad, CABuilt 1978 · S/N E 1424N551JSEm Concepts LLC · Cape Coral, FLBuilt 1978 · S/N TC-2199N551TN551t LLC · Hesston, KSBuilt 1977 · S/N D-10013N5522DBrewer Thomas A · Anderson, INBuilt 1957 · S/N D-5057N5522FSchlaffer Sandor · Daytona Beach, FLBuilt 1957 · S/N D-5019N5522TBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1978 · S/N TK-79N5524VRamsey Jarrod Ross · Chicago, ILBuilt 1989 · S/N E-2505N5525DOlsen Gary E · Albuquerque, NMBuilt 1957 · S/N D-5061N5527DCarns Ronald · Killeen, TXBuilt 1957 · S/N D-5063N5528VTrusler William L · Magnolia, TXBuilt 1990 · S/N CE-1426N5529DKanieski Maximilian M · New Canaan, CTBuilt 1989 · S/N CE-1403N552BWinkelbauer Kim G · Sun City, AZBuilt 1967 · S/N D-8524N552BBFrench Don Robles · Glendale, AZBuilt 1970 · S/N TE-800N552CLWattles Gurdon S · Stuart, FLBuilt 1986 · S/N E2336N552CMCm552 LLC · Katy, TXBuilt 2000 · S/N E-3337N552WTMaierhoffer Henry F Jr · Sylvania, GABuilt 1967 · S/N TE-486N552ZSTuolumne Ridge LLC · Modesto, CABuilt 1983 · S/N EA-343N5530XFaulhaber Orlin W · North Platte, NEBuilt 1989 · S/N E-2504N5531DBas Part Sales LLC · Greeley, COS/N E840N5532DSchaffert Warren E · Trenton, NES/N D-5082N5533DKilo Aviation LLC · East Peoria, ILBuilt 1957 · S/N D-5083N5533KVan Nostran Michael T · Lake Havasu City, AZBuilt 1968 · S/N D-8905N5534RHanson David J · Charlotte, NCBuilt 1990 · S/N E-2576N5535WGpd LLC · Saint Louis, MOBuilt 1990 · S/N E2540N55367Mammoth Toys Inc · Santa Ana, CABuilt 1990 · S/N E2537N5536DLett Laura D · Dallas, TXBuilt 1957 · S/N D-5086N5536LAdvance Air LLC · Wichita, KSBuilt 1990 · S/N EA-502N5537VWheelzup LLC · San Carlos, CABuilt 1990 · S/N EA-506N5537XKelly Douglas E · Lake Ozark, MOBuilt 1990 · S/N E-2531N5538XBeartooth Air LLC · Cody, WYBuilt 1989 · S/N CE-1373N553BJ M Thomas & Assoc Inc · Panama City Beach, FLBuilt 1948 · S/N D-1571N553WP6sm Aviation LLC · Savannah, GABuilt 1974 · S/N TC-1757N5545DPartlow Lee · Granbury, TXBuilt 1957 · S/N D-5091N5546Forster Sebastian Alexander · Elberta, ALBuilt 1979 · S/N EA-53N5546DKennedy Kevin L · Moscow, IDFirst renewal noticeBuilt 1957 · S/N D-5130N5546FCe-1382 LLC · Point Clear, ALBuilt 1989 · S/N CE-1382N5548DKirkpatrick Robert · Placerville, CABuilt 1957 · S/N D-5111N5549DRobert T Parker Jr · Bigfork, MTS/N D-5109N554BDaniel James W · Somis, CABuilt 1948 · S/N D-1572N554CLLacy Clay · Groveland, CABuilt 1966 · S/N TE-99N554DDale Wes · Gainesville, GABuilt 1962 · S/N TD-507N554DDMhr Holdings LLC · Indian Hills, COBuilt 1973 · S/N TE-943
Back to AD 99-05-13 R1 WD