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.

N7989LPringle Nathan · Discovery Bay, CABuilt 1966 · S/N MA-150N7989RBack In The Saddle LLC · Nashville, TNBuilt 1969 · S/N TE-714N798BVaughn Ken W · Fort Bragg, CAS/N D-1810N798GMJust US Pilots Inc · Clearwater, FLBuilt 1998 · S/N E-3184N798JBMidwest Aircraft LLC · Olathe, KSBuilt 2002 · S/N E-3468N798RDSmith Lawrence M · Jacksonville, FLBuilt 1967 · S/N D-8528N7990LAshment Joseph E · Shepherd, MTBuilt 1966 · S/N MA-163N7993LFranklin Tonda Leah · Chatfield, TXBuilt 1966 · S/N MA-155N7994KReynolds Gary L · Colorado Springs, COBuilt 1964 · S/N D-7502N7994LConsummate Inc · Cedar City, UTBuilt 1966 · S/N MA-156N7995KHall Benjamin H Jr · Tullahoma, TNBuilt 1964 · S/N D-7501N7995LSheehy Gerald L · Wichita, KSS/N M-1005N7996LLester Mark Anthony · Simon, WVS/N M1006N7998DArizona Red Mountain Enterprises Inc · Mesa, AZBuilt 1957 · S/N D-5278N7998KHoughton Justin K · North Ferrisburg, VTBuilt 1965 · S/N BA-699N7998LMarkham Gerald W · Kodiak, AKBuilt 1966 · S/N MA-161N7998MBertelli Leonard DBA · Lancaster, SCBuilt 1966 · S/N D-8278N7998RSolberg Kevin L · West Fargo, NDBuilt 1969 · S/N TC-1241N7999KBristol Bay Capital LLC · Watkins, COS/N D-7578N79AGAmerican Airpower Heritage Fly Musm · Dallas, TXBuilt 1952 · S/N A-806N79APHigh Tide Aviation LLC · Naples, FLBuilt 1979 · S/N TJ206N79CCN79cc LLC · Paragould, ARBuilt 1969 · S/N TE-764N79DFMei Multi-Engine Instruction LLC · York, PABuilt 1975 · S/N TC-1883N79DRMcneill Steve · Santa Fe, NMBuilt 1994 · S/N EA-559N79DSBonanza Air Ventures LLC · Mammoth Lakes, CABuilt 1982 · S/N EA-326N79HCBmc Group · Hawthorne, CABuilt 1990 · S/N E-2538N79HEMontauk Flying Inc · Montauk, NYBuilt 2004 · S/N E-3542N79MCKruse Air LLC · Sheridan, WYBuilt 1981 · S/N E-1903N79MMMartin Martha S · Graford, TXBuilt 1969 · S/N CJ-21N79PRHutchinson Andrew J · Gardner, KSBuilt 1970 · S/N D-9138N79RKSlone Thad M · Flectcher, OHBuilt 1957 · S/N D-5172N79VABlack Aero LLC · Las Vegas, NVS/N D-6690N79XRaspa Anthony · Birchwood, TNBuilt 1967 · S/N TG-26N7AWWeese David · Yamhill, ORBuilt 1965 · S/N D-7834N7BBJuliet Whiskey LLC · Jenks, OKBuilt 1976 · S/N P-402N7BSRunyon Aviation LLC · Fort Worth, TXBuilt 1954 · S/N BA-18N7BW7bw LLC · Lewes, DEBuilt 1973 · S/N E-395N7BXHoneywell International Inc · Phoenix, AZBuilt 1975 · S/N TE-1020N7BYN7by LLC · Jensen Beach, FLBuilt 1991 · S/N CE-1611N7CJPropart Inc · Austin, TXBuilt 1990 · S/N E-2575N7CNMentor Flight LLC · Savoy, ILBuilt 1955 · S/N 52-8272N7CRR & R Exotic Machines LLC · Peoria, AZBuilt 1978 · S/N P-471N7EVYellow Star Mgmt LLC · Waco, TXBuilt 1998 · S/N E-3162N7EWMidas Aviation LLC · Royal Palm Beach, FLBuilt 1964 · S/N TC-764N7FHGroh David · Mason, MIBuilt 1977 · S/N E-1142N7JKosco Matthew D · Munster, INBuilt 2000 · S/N E-3316N7JNB & K Steel & Supply Inc · Ogden, UTBuilt 2000 · S/N EA-663N7KTOrtiz Alexander · Walnut Creek, CABuilt 1979 · S/N D-10268N7MBGlenn Michael H · Midland, TXBuilt 1959 · S/N BA-448N7MDReady Aim Flyer LLC · New Castle, DEBuilt 1959 · S/N TD-309
Back to AD 99-05-13 R1 WD