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.

N365HPVasi LLC · Dripping Springs, TXBuilt 1980 · S/N E-1756N365RVTwin Oaks Aviation Inc · Pipersville, PAS/N E-1840N3661QLong Nathan J · Huntsburg, OHS/N MA-251N3663KEvans And Evans Properties Inc · Santa Cruz, CABuilt 1980 · S/N EA-84N3663QOmalley Edward · Boulder, COBuilt 1980 · S/N E-1691N3664GMarshmont Aviation LLC · Greenville, SCS/N TJ-280N3664QDiana Scott J · Wallingford, CTBuilt 1967 · S/N MA-249N3664TJdm Aviation LLC · Marceline, MOBuilt 1980 · S/N E-1692N3664YWindswept Aviation LLC · North Canton, OHBuilt 1980 · S/N E-1693N36664Strauss Steven Trustee · Tempe, AZBuilt 1980 · S/N EA-89N36665Flynn Michael · Weybridge SurreyBuilt 1980 · S/N E-1696N3666ASandow Dean · Scappoose, ORBuilt 1969 · S/N E-190N3666QHighum Peter · Hernando Beach, FLBuilt 1967 · S/N MA-253N3667QLife'S A Beech LLC · Wilmington, DEBuilt 1967 · S/N MA-269N3668DLkj Holdings LLC · Amarillo, TXS/N EA-92N3668QPaul B Meadowbrook Pc · Albany, ORFirst renewal noticeS/N MA-255N3668URedmond John L · Santa Clarita, CABuilt 1980 · S/N E-1701N3669DCvf Aviation LLC · Paoli, INS/N P-544N3669QMarshall Jerry W · Centennial, COBuilt 1967 · S/N MA-256N366HPRey Del Cielo LLC · San Antonio, TXBuilt 1974 · S/N E-632N366PSkyway Unlimited Inc · New London, NCBuilt 1997 · S/N E-3099N366PSA-Team Family LLC · Ashland, ORBuilt 1974 · S/N TE-971N366PWEuroaviation Inc Trustee · KematenBuilt 1992 · S/N EA-530N366ZMendel Carl · Port Charlotte, FLBuilt 1975 · S/N E-769N3670BAircraft Partner Holdings Inc Trustee · BerlinBuilt 1954 · S/N CH-63N3670EFresh-Pic Harvest Inc · La Quinta, CABuilt 1980 · S/N TK-124N3670UHoffman Kevin · Chatsworth, GABuilt 1980 · S/N TC-2332N3671FHenson Ronald E · Bonita Springs, FLS/N EA-94N3671MFigvam LLC · New York, NYBuilt 1980 · S/N E-1705N36724Reeves Richard G · La Verne, CABuilt 1980 · S/N TC-2333N3672QDye Laura G · Whispering Pines, NCBuilt 1967 · S/N MA-262N3675DS & L Air LLC · Torrington, WYBuilt 1980 · S/N P-546N3675QSwann Phyllis R · Madison, ALBuilt 1967 · S/N MA-266N3675RCl1 LLC · Baton Rouge, LABuilt 1980 · S/N E-1711N3675TFairbairn Stephen C · Carmel, INBuilt 1980 · S/N E-1672N3676QJobe Eric J · Parkville, MOBuilt 1967 · S/N MA-267N3676YYesco Administration LLC · Salt Lake City, UTBuilt 1980 · S/N D-10306N3677UNinomiya James T · Placitas, NMBuilt 1980 · S/N TC-2337N36787Manairco Inc · Wooster, OHBuilt 2004 · S/N E-3587N3679QBear Skin Run Llp · Clinton, NCBuilt 1967 · S/N M-1051N3679ZKlein Eric · Tenino, WABuilt 1980 · S/N E-1730N367BCVc Air LLC · Midland, TXBuilt 1989 · S/N CE-1409N367DMarquardt James H · Warner Robins, GABuilt 1979 · S/N E-1619N367HPN367hp LLC · Aberdeen, SDBuilt 1981 · S/N E-1811N368San Diego Air And Space Museum · San Diego, CABuilt 1943 · S/N 4883N3680RYatra Global LLC · Bedford, MABuilt 1980 · S/N E-1717N3680UMoughon Kirby W · Melbourne, FLBuilt 1980 · S/N E-1718N36829Prime Aviation LLC · Wilmington, DEBuilt 1980 · S/N E-1720N3682BQualitair LLC Trustee · MichelstadtBuilt 1954 · S/N CH-103N36847Thrash Howard G II · Lubbock, TXBuilt 1980 · S/N EA-115
Back to AD 99-05-13 R1 WD