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.

N1728GMeyer Fred F · Hampshire, ILBuilt 1962 · S/N D-6946N172QBonanza N172q LLC · Cedarburg, WIS/N D-7292N172XCisar Matthew Alexander · Eglin Afb, FLS/N D-6766N1731WCollins Air LLC · Kennett, MOBuilt 1972 · S/N E-369N1733GAlpine Aviation Inc · Mclean, VABuilt 1962 · S/N D-6949N1734GJ-Bird Air Service LLC · Cheyenne, WYBuilt 1962 · S/N TC-275N1736WAmbitious Aviation LLC · Newport News, VABuilt 1972 · S/N D-9403N1737BDiaz Juan B III · Portland, ORBuilt 1972 · S/N D-9405N1737GBraly John E · Surprise, AZBuilt 1962 · S/N D-6948N1738GSchneider Joel A · Cerrillos, NMBuilt 1962 · S/N D-6950N173DSanford Mark J · Ithaca, NYBuilt 1964 · S/N TC-825N173QLively Scott Jacob Charles · Greenbrier, ARBuilt 1964 · S/N D-7350N173TAughenbaugh Timothy A · Iroquois, SDS/N D-8259N1741GPlane Fun Inc Tr Trustee · Snellville, GABuilt 1956 · S/N D-4773N1743GYoung Harrison · Phoenix, AZBuilt 1962 · S/N TC-278N1743WThomas John J · Marana, AZBuilt 1972 · S/N D-9404N1744GWelsh Ayden · Dayton, OHBuilt 1962 · S/N D-6953N1745WThoroughscape Inc · Wellington, FLBuilt 1972 · S/N CE-409N1746GFrasier Samuel · Gainesville, FLBuilt 1962 · S/N D-6952N1748WBas Part Sales LLC · Greeley, COBuilt 1972 · S/N TE-887N174AFWelch William H Jr · Owosso, MIBuilt 1959 · S/N D-6187N174DQSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1981 · S/N M2310N174TATracewings LLC · Goodyear, AZS/N E-3499N17505Trout Christopher S · Albuquerque, NMBuilt 1977 · S/N D-9966N17509Starke Charles H III · Weirsdale, FLBuilt 1976 · S/N E-972N1750WYounger Benjamin · Narrowsburg, NYBuilt 1972 · S/N D-9406N17516Gillis Alan · Richmond, TXBuilt 1977 · S/N D-9978N17520Patterson William · Spring, TXBuilt 1976 · S/N E-974N17522M & A Business Propertys LLC · Wilmington, DEBuilt 1977 · S/N CE-690N17526Preferred Land Solutions LLC · Belden, MSBuilt 1977 · S/N TC-2031N1752WMichael S Austin Dmd Ms Psc · Utica, KYBuilt 1972 · S/N E-373N1753WConservative Three LLC · Taft, CABuilt 1972 · S/N CE-410N1755WAis Construction Equip Corp · Grand Rapids, MIBuilt 1972 · S/N E-374N17561Demott Andrew Dolphus III · Hernando, FLBuilt 1977 · S/N D-9983N17568Chance Research Corp · Mineral Wells, TXBuilt 1977 · S/N D-9984N1756WIverson Bradley · Grinnell, IABuilt 1972 · S/N D-9409N17571De Oliveira Derek · Meadow Vista, CABuilt 1977 · S/N E-983N17577James Rodney D · Bono, ARBuilt 1977 · S/N TE-1091N1757GMatrix Aviation Inc · Ponte Vedra Beach, FLBuilt 1962 · S/N TC-350N1758WJanneck Curtis · Mooresville, INBuilt 1972 · S/N CE-411N175LKern Charter Service Inc · Bakersfield, CABuilt 1977 · S/N E-985N175TPadgett Don K · Albuquerque, NMBuilt 1971 · S/N D-9259N17604Montgomery Aviation Corp · Montgomery, ALBuilt 1977 · S/N TE-1094N17607Juren Nicholas J · Los Osos, CABuilt 1977 · S/N CE-695N17618Kloptenstein Kevin S · Parker, AZBuilt 1977 · S/N CE-696N17621Boe Mark · Morgan, UTBuilt 1977 · S/N E-992N17625Oehler David W · Ponchatoula, LABuilt 1977 · S/N TC-2070N17626Beaugrenelle Aero Inc · Wilmington, DEBuilt 1977 · S/N TC-2061N17628Elliot Air LLC · Dunwoody, GABuilt 1977 · S/N E-993N17629Haven Av LLC · New Braunfels, TXBuilt 1977 · S/N D-9991
Back to AD 99-05-13 R1 WD