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.

N258TCDunn Mark A · Lufkin, TXBuilt 1966 · S/N D-8351N259CN259c LLC · Woodward, OKBuilt 2001 · S/N EA-684N259JHall James A · Bozeman, MTBuilt 1973 · S/N D-9430N259MMDavidson Bryan H · Sarasota, FLBuilt 1986 · S/N E-2311N259TTaylor Ted H · Corsicana, TXBuilt 1967 · S/N D-8664N25ARSmith Darvin L · Atlanta, GAS/N TD-431N25BMaine Instrument Flight · Augusta, MES/N ME-49N25BTFernandez Sergio R · Port Saint Lucie, FLBuilt 1981 · S/N D-10373N25CGMcdonough Aviation LLC · Montgomery, ALBuilt 1978 · S/N E-1297N25DAAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1978 · S/N P-483N25FPEastern Stearman Inc Trustee · Leesburg, VABuilt 1992 · S/N E-2720N25HHCorn Dustin M · Muncie, INBuilt 1953 · S/N D-3693N25JFaria Manuel Steven Trustee · Tipton, CABuilt 1974 · S/N CE-536N25JKCoastal Slr Corperation · Port Orange, FLBuilt 1968 · S/N TE-533N25JRDjair · Winchester, VABuilt 1961 · S/N TC-132N25KSleeper William H · Bainbridge Island, WABuilt 1944 · S/N 6881N25LRRoam Airlines LLC · Eugene, ORBuilt 1981 · S/N EA-196N25LSBzaviation LLC · Saint Louis, MOBuilt 1994 · S/N E-2838N25LTCaudell Currin B · Dallas, TXBuilt 1957 · S/N D-5330N25MJHb Flying LLC · Pampa, TXS/N E-3236N25QGrant Janice · Friday Harbor, WABuilt 2001 · S/N E-3398N25QYCuller Richard E · Winston Salem, NCBuilt 1976 · S/N CE-653N25RDHamilton Robert L · Vashon, WABuilt 1971 · S/N CE-358N25RHPoseidon Transport Inc · Watertown, NYBuilt 1982 · S/N CE-1009N25RMSky Travel LLC · Clayton, MOS/N TJ-459N25RXOlde Same Place LLC · Thiensville, WIBuilt 1971 · S/N TE-832N25TMYankee Tango Mike LLC · Dublin, TXS/N EA-265N25UPNewsome Jeffery S · Blackwell, OKBuilt 1977 · S/N E-987N25VBOtto Aircraft Sales Inc · Sarasota, FLBuilt 1976 · S/N D-9841N25WWRainey Aerial Ag Service Inc · Obion, TNBuilt 1976 · S/N E-842N26035Aom Aircraft LLC · Wilmington, DES/N BA-754N260AACarpenter Timothy A · Phoenix, AZBuilt 1966 · S/N D-8325N260ARDeep South Flying Services LLC · Albany, GABuilt 1983 · S/N TJ436N260EABlue Sky Airfleet LLC · Kalispell, MTBuilt 2004 · S/N E-3408N2613CThree Two Five Echo Fc · Corinth, TXBuilt 1985 · S/N E-2293N261AARoy Michael W · Pear Valley, TXBuilt 1959 · S/N D-5855N261BWinnie Mae Inc · Tallahassee, FLBuilt 1957 · S/N DH-134N261EABrownstone Aviation II LLC · Houston, TXBuilt 2001 · S/N E-3423N2625MB-Hive Inc · Augusta, GABuilt 1973 · S/N TC-1586N2626Fletcher Flying Service 419 LLC · Labelle, FLS/N 283N262DHansen Nicholas R · Dayton, MTS/N D-3024N262EAJeaps Aviation LLC · Edgewater, FLBuilt 2001 · S/N E-3417N262PMBig Bend Community College · Moses Lake, WABuilt 1992 · S/N CE-1681N263AAWilkey Michael B · Kingston, GABuilt 1958 · S/N D-5581N263CNorpoth Robert L · Circleville, OHS/N LB28N263EAJdcwac LLC · Blair, NEBuilt 2002 · S/N E-3437N263SAColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1999 · S/N E-3283N2646PAlas De La Aguila LLC · Kalispell, MTS/N E-2313N264EStark David M · Merkel, TXS/N 4888N264JGSparkling Diamond LLC · Middleton, WIBuilt 1999 · S/N E3264
Back to AD 99-05-13 R1 WD