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.

N7963LDanelski Darin L · Oconomowoc, WIBuilt 1966 · S/N M-999N7964DMcelwee Carl D · Lawrence, KSBuilt 1957 · S/N D-5249N7964KCentral Virginia Aviation Inc · Petersburg, VAS/N TC-685N7964LNordby Frederick · Felton, CABuilt 1966 · S/N MA-140N7965KBlake Manus · Rock Springs, WYBuilt 1964 · S/N D-7469N7966DRamo Cody H · Broomfield, COBuilt 1957 · S/N D-5228N7966MEagle Aviators LLC · Franklin, VABuilt 1966 · S/N D-8258N7967DKruger Sam · Bakersfield, CABuilt 1957 · S/N D-5241N7967MMercer Aero Service Inc · Aurora, COBuilt 1966 · S/N D-8260N7968DSarwat Mohammad Abu · Sammamish, WABuilt 1957 · S/N D-5235N7968RSierra View Aviation LLC · Verdi, NVBuilt 1969 · S/N TC-1237N7969MN7969m LLC · Double Oak, TXBuilt 1966 · S/N D-8283N796BStarnes Robert D · Lavonia, GAS/N D-1808N7971DWalsh Christopher A · Harrison, IDBuilt 1957 · S/N D-5237N7972KTeer John · Austin, TXBuilt 1964 · S/N D-7471N7972MRegistration Pending · Merrimack, NHRegistration pending, pending cancellationBuilt 1966 · S/N TD-674N7973KDreams A Loft LLC · Santa Barbara, CABuilt 1964 · S/N D-7470N7973M7973m LLC · Broomfield, COBuilt 1966 · S/N TE-208N7974DChaffin Grant M · Blythe, CAS/N D-5226N7974KDavis Jeremy · Longview, TXS/N D-7468N7975RHicks Jeffrey D · Ponca City, OKBuilt 1969 · S/N D-8991N7976DHudson John P III · Grapeland, TXBuilt 1957 · S/N D-5269N7976LFarrell Michael · Rockwall, TXBuilt 1966 · S/N MB-157N7976MHudson Kent O · Anchorage, AKBuilt 1966 · S/N D-8268N7977DTailwind Airplanes LLC · Wilmington, DEBuilt 1957 · S/N D-5239N7977MLoskill Edwin R · Lubbock, TXBuilt 1966 · S/N D-8269N7978DEkbcorp LLC · Helena, MTS/N D-5230N7978RTomme John Paul · Arlington, TXBuilt 1969 · S/N TC-1236N7979DFancy Pants Productions Inc · Sandusky, OHS/N D-5238N7979KTdiation Flights LLC · Madison, ALBuilt 1964 · S/N TC-689N7979MFrancis William · Lake Oswego, ORS/N D-8270N797BLong E V · Wichita, KSBuilt 1948 · S/N D-1809N797RHCya Ltd · Crystal Lake, ILBuilt 1965 · S/N D-8022N7981LLund Larry D · Manti, UTBuilt 1966 · S/N MA-143N7982DBlack David B · Guymon, OKBuilt 1957 · S/N D-5262N7983DSanocki Raveen D · Phoenix, AZBuilt 1957 · S/N D-5281N7983KCormier Christopher J · Anna, TXBuilt 1964 · S/N D-7584N7983MAjf Enterprises LLC · Des Moines, IABuilt 1966 · S/N TD-671N7984KBeech V-Tail LLC · Aurora, COBuilt 1964 · S/N D-7483N7986DClevenger Mark L · Porter, TXBuilt 1957 · S/N D-5276N7986LRegistered aircraftBuilt 1966 · S/N MB-164N7987DSparrowhawk Aviation LLC · Moraine, OHBuilt 1957 · S/N D-5273N7987KSharair LLC · Thomasville, GABuilt 1964 · S/N D-7491N7987LWhitten Michael Neil · Wimberley, TXBuilt 1966 · S/N MA-148N7987MKrikorian Philip R · Fresno, CABuilt 1966 · S/N D-8273N7987RHopeful Monster LLC · Ann Arbor, MIBuilt 1969 · S/N D-8975N7988KUnlimited Horsepower LLC · Lewisburg, WVBuilt 1964 · S/N D-7492N7988LMorris Aaron B · Louisville, GABuilt 1966 · S/N MA-159N7988MBlandon Pedro Md Pa · El Paso, TXBuilt 1967 · S/N D-8471N7989DMoss Charles B · York, SCBuilt 1957 · S/N D-5243
Back to AD 99-05-13 R1 WD