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.

N9549RMair David N · Keller, TXBuilt 1959 · S/N D-6100N9549YBiederman Clifton E · Jasper, FLBuilt 1962 · S/N TC-348N954DRLulafay LLC · Lewes, DES/N D-6141N954REvans William Heath · Groveton, TXBuilt 1981 · S/N CE-954N954RAAstillero Ricardo · Northfield, NJBuilt 1968 · S/N TD711N9550REngland Steven B · Dublin, OHBuilt 1959 · S/N D-6108N9551RDunn Agri & Aviation LLC · Kalispell, MTBuilt 1959 · S/N D-6109N9551YPinney Sidney G · Ocala, FLBuilt 1962 · S/N D-7028N9552YBanfe Kathy Kieran Hinds · Johns Island, SCBuilt 1962 · S/N D-7053N9553QTaylor Matt · Tahoka, TXBuilt 1966 · S/N D-8189N9553RAnderson James W · Kennebec, SDBuilt 1959 · S/N D-6104N9555BStern Aviation Inc · N Fort Myers, FLBuilt 1981 · S/N TC-2405N9555QRegistration Pending · Cottonwood, AZRegistration pendingBuilt 1966 · S/N D-8193N9555YRegistered aircraftBuilt 1973 · S/N TC-1577N9557YMckinnon Wayne · Douglas, GABuilt 1962 · S/N D-7030N955BESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N TC-1272N955CAJa Flight Services LLC · Sugar Grove, ILBuilt 1979 · S/N TC-2264N955DBWeyant Steven R · Bonney Lake, WABuilt 1978 · S/N TC-2195N955DJGray John Michael · Saint Petersburg, FLBuilt 1967 · S/N TE-300N955GBBioventures Leasing Corporation LLC · Brookhaven, GABuilt 1999 · S/N E-3286N955LJTk Healthcare Management LLC · Abilene, TXS/N E-3082N955QBuy Fly Sell LLC · Inverness, FLBuilt 1962 · S/N D-6835N955RHFrenzel Aviation Investments LLC · Brentwood, TNBuilt 1977 · S/N TC-2095N955RPBideler Nicholas · Saint Louis, MOBuilt 1979 · S/N TC-2243N955TMaynard Robert R · Inglewood, CARegistration revokedBuilt 1960 · S/N TD-401N9560RMacclements Jonathan E · Austin, TXBuilt 1959 · S/N D-6126N9561QOliver James L · Orion, MIBuilt 1966 · S/N D-8171N9561RPaul David A · Hot Springs, ARBuilt 1959 · S/N D-6127N9562RWashburn Tom · Terrell, TXBuilt 1959 · S/N D-6128N9564REl Avion Del Abuelo LLC · Ashburn, VABuilt 1959 · S/N D-6119N9565QBonanza II LLC · Milton, FLBuilt 1966 · S/N D-8282N9565RLawton Stephen A · Hillsboro, TNBuilt 1959 · S/N D-6115N9566QMoskol Jake · Madison, WIBuilt 1966 · S/N D-8201N9566YBell Charles Jay · Salina, KSBuilt 1962 · S/N D-7041N9567QDreger Jeffrey W · Poplar Grove, ILBuilt 1966 · S/N D-8202N9567RBentivogio Mariano · Hampton, GAS/N D-6137N9568QN9568q LLC · Lake Worth, FLBuilt 1966 · S/N D-8203N956PAKoelbl Aviation LLC · Whitesboro, TXBuilt 1969 · S/N TE-703N956SBBeaux Air LLC · England, ARBuilt 1973 · S/N TE956N956VParker Aerospace LLC · Warren, VTBuilt 1975 · S/N D-9817N9570RFedorowicz Walter P · Aurora, COBuilt 1959 · S/N D-6133N9572RThompson Charles R · Maysville, KYBuilt 1959 · S/N D-6164N9574QHarris Steven L Trustee · Sisters, ORBuilt 1966 · S/N D-8205N9574RBoykin Bobby · Brandon, MSS/N D-6166N9575RGotsdiner Alexander M · Panama City Beach, FLBuilt 1959 · S/N D-6170N9576RBuechle Mark T · Marshall, MIBuilt 1959 · S/N D-6171N9577RLawrie Daniel A · Mesa, AZBuilt 1959 · S/N D-6144N9578RJudd Richard M · Austin, TXS/N D-6174N9578YWitte Mark E · De Witt, IABuilt 1962 · S/N D-7042N9579RSotax Inc · Tacoma, WABuilt 1959 · S/N D-6176
Back to AD 99-05-13 R1 WD