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.

N9118QBonanza Life LLC · Urbana, ILS/N D-9225N9119QPrestige Worldwide Aviation LLC · Kalispell, MTBuilt 1970 · S/N TC-1375N9119TDahab Richard E · Brightwaters, NYBuilt 1968 · S/N MA-333N911DHAllison Joshua S · Dickson, TNFirst renewal noticeBuilt 1952 · S/N D-3322N911EZDufrechou Carlton F · Metairie, LABuilt 1954 · S/N D-3870N911GHamilton Jason W · Jefferson, TXBuilt 1966 · S/N D-8198N911GSAir-Ric LLC · Mobile, ALBuilt 1981 · S/N E-1785N911JKRegistered aircraftBuilt 1976 · S/N D-9925N911KRaper David A · Mesa, AZBuilt 1966 · S/N D-8253N911MAJohnson Jeffery V · Floydada, TXBuilt 1973 · S/N P-225N911NKNorton Noel M · Petaluma, CABuilt 1968 · S/N D-8757N911PYOrchtrans Inc Trustee · Wilmington, DEBuilt 1960 · S/N LF-21N911SLund Mark · Wasilla, AKBuilt 1974 · S/N P-317N911UT9sixteen Motorsports · Lusby, MDS/N TC-928N911VGlatt Christopher D · Saint Paul, MNBuilt 1966 · S/N D-8091N911WTFernandez Daniel · Boca Raton, FLBuilt 1986 · S/N E-2298N9121QBehm Darren Wayne · Frisco, TXBuilt 1970 · S/N D-9228N9122SMercer Warren G · Bogart, GABuilt 1976 · S/N TC-1939N9126QSks Aviation LLC · Sherman, TXBuilt 1971 · S/N D-9226N9127QDopfel Bruce E · Belle Plaine, KSBuilt 1971 · S/N E-245N9127TSimon William Corey · Fruita, COS/N M-1148N9128QRegistered aircraftBuilt 1970 · S/N E-247N912DFSmith Doyle Cecil · Prattville, ALS/N TC-177N912HCivil Aviation Group LLC · Ada, OKBuilt 1966 · S/N TE-143N912HFMcs Aviation LLC · Sylvania, OHBuilt 1990 · S/N CE-1540N912LFFarmer Thomas E Jr · Galveston, TXBuilt 1974 · S/N D-9617N912MH James & Sons Inc · Fennimore, WIBuilt 2001 · S/N E-3379N9131RNogle Charles H · Champaign, ILBuilt 1956 · S/N BG-289N9133RWeaver Aircraft Co · Carson City, NVS/N G-802N9133SWebster Eric M · Two Rivers, WIS/N CE-647N9135SChelette Garry · Chicago, ILBuilt 1976 · S/N D-9874N9136QBeech 9136q Charter Aircraft LLC · Chico, CABuilt 1970 · S/N E-248N9136SProctor Racing Group LLC · Glendora, CABuilt 1976 · S/N E-844N9137QSam Tyson Builders Inc · Monroe, NCFirst renewal noticeBuilt 1970 · S/N D-9233N9137SCiontea James C · Santa Barbara, CABuilt 1976 · S/N E-820N9138SRegistered aircraftBuilt 1976 · S/N D-9860N9139QBollings Avionics LLC · Bristol, TNBuilt 1970 · S/N E-249N9139TBoss Peter J · Bruce, WIBuilt 1968 · S/N M-1155N913DSHaulin Ash Productions Inc · Franklin, TNS/N E-3523N913KMBlack Edward C · Orange, CABuilt 1979 · S/N CE-892N913QWA Parrotte'S View In Flight LLC · Wilmington, DEBuilt 1991 · S/N CE-1602N9140QTonka Seaplanes LLC · Minnetonka, MNBuilt 1971 · S/N D-9235N9140STregellas Tim E · Aledo, TXBuilt 1976 · S/N D-9861N9140TKay Aviation LLC · Merritt Island, FLBuilt 1968 · S/N M-1156N9141QBear Air LLC · Elizabeth City, NCBuilt 1970 · S/N CE-317N9141SZuckerman Charles J Trustee · San Diego, CABuilt 1976 · S/N CE-632N9142QLamb Christopher A · Perry, OKBuilt 1971 · S/N CE-338N9143QCarlson Jeffrey K · Lake Stevens, WAS/N D-9236N9143SBooton Charles E · Navarre, FLBuilt 1975 · S/N MC-397N9144QN9144q LLC · Brooklyn, NYBuilt 1970 · S/N E-250
Back to AD 99-05-13 R1 WD