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.

N534RBCloud 9 Wings LLC · Webberville, MIBuilt 1953 · S/N G-300N534YWahl Charles S · Cameron Park, CAS/N BG-70N5351EDelta Vee LLC · Savannah, GABuilt 1959 · S/N D-5832N5353EDillard Enterprises Inc · Pensacola, FLBuilt 1959 · S/N D-5856N5354EBisson Scott E · Livermore, CABuilt 1959 · S/N D-5853N5356ERedden Zana R · Sacramento, CABuilt 1959 · S/N D-5869N5359ESchaperkotter Harold M Jr · Nashville, TNBuilt 1959 · S/N D-5875N535BEValiair Lc Trustee · Casper, WYBuilt 1970 · S/N D-9170N535PTaylor Jim A · Kernersville, NCBuilt 1966 · S/N D-8119N535QGeaux Fly LLC · Bossier City, LABuilt 1968 · S/N TE-609N535RARich Aviation Services LLC · Fort Worth, TXBuilt 1968 · S/N TC-1126N535SBSpeedy Bonanza LLC · Waitsfield, VTBuilt 1964 · S/N D7485N535TXCoolidge Robert P · Rio Vista, TXBuilt 1960 · S/N D-6396N535VBSchellenger Jonathan H · Port Saint Lucie, FLBuilt 1975 · S/N D-9742N535WNichols David A · Oneonta, ALBuilt 1965 · S/N D-7897N5360EStrahm Ralph E · Holtville, CABuilt 1959 · S/N D-5848N5361GBaker Kimberly L · Monticello, INS/N BG-55N5364EGaddis Jason · North Las Vegas, NVBuilt 1959 · S/N D-5836N5365EOsborne Steven V · Douglas, WYBuilt 1959 · S/N D-5854N5367EHentges Anthony · Canby, MNBuilt 1959 · S/N D-5846N5368EHarris Adventures LLC · El Prado, NMS/N D-5847N5369EKing Curtis M · Tenino, WABuilt 1959 · S/N D-5850N536AMTriniair LLC · Warner Robins, GABuilt 1978 · S/N E1172N536BAPlasko Enterprises LLC · Trumbull, CTBuilt 1978 · S/N E-1170N536BCChavers Construction Inc · Cantonment, FLS/N E-2160N536DShiloh Aviation LLC · Ramer, TNBuilt 1962 · S/N DH-338N536EUSarabay Aviation Partners LLC · Sarasota, FLBuilt 2005 · S/N E-3616N536JSShoffner James P Jr · Denver, COBuilt 1984 · S/N EA-418N536KEngage Helicopters LLC · Sarasota, FLS/N E3220N536PSky High II LLC · Clinton, NCBuilt 1998 · S/N E3197N536TCI C Aviation LLC · Scottsdale, AZBuilt 1988 · S/N EA-481N536WWright Jack · Fortson, GABuilt 2002 · S/N E-3458N536WGAdvantage Aviation Inc · Palo Alto, CABuilt 1990 · S/N CE-1446N5372EThief River Aviation Inc · Thief River Falls, MNBuilt 1959 · S/N D-5905N5373EMoyer Thomas L · Fayetteville, GABuilt 1959 · S/N D-5861N5377EHamilton Chris · Livermore, CABuilt 1959 · S/N D-5863N5379EMahoney Blair P · Columbia Station, OHBuilt 1959 · S/N D-5877N537BN537b LLC · Crowley, LAFirst renewal noticeBuilt 1948 · S/N D-1553N537DStonebraker Properties LLC · Sierra Vista, AZS/N D-8791N5382EGmoser Michael T · Hamilton, OHBuilt 1959 · S/N D-5876N5383Treefo Bravo LLC · Hawkins, TXBuilt 1964 · S/N TC-755N5383ERegistered aircraftBuilt 1959 · S/N D-5886N5385EGeiger William G · New Castle, KYBuilt 1959 · S/N D-5933N5386EAllen Karen J · Walnut Grove, CAS/N D-5917N5388EGandy Dale D · Aurora, MOBuilt 1959 · S/N D-5894N5389EWagner Paul A Jr · Madison, ALBuilt 1959 · S/N D-5890N5391EGosser James A · Nicholasville, KYBuilt 1959 · S/N D-5873N5394ERusak Robert J · Paris, TXBuilt 1959 · S/N D-5898N5397ECasella David A · Sonoma, CABuilt 1959 · S/N D-5896N539REdward Jennings LLC · Valdosta, GABuilt 1985 · S/N E-2296
Back to AD 99-05-13 R1 WD