OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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-01-05-R1')
    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-01-05-R1')
  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.

N2390AAgnew Michael D · Pardeeville, WIS/N 22-756N2390HBrott Brian A · Kasilof, AKBuilt 1979 · S/N 18-7909176N2390PLubben Thomas H · Madison, WIBuilt 1955 · S/N 22-2781N2391POberholtzer Robert H · Streator, ILBuilt 1955 · S/N 22-2782N2392HPeterson John A · Anchorage, AKBuilt 1979 · S/N 18-7909170N2392PWagar Dennis M · Marion, MTBuilt 1955 · S/N 22-2783N2393MKahn R Douglas · Boston, MABuilt 1946 · S/N 12-1634N2394AMykyte Dustin D · Houston, TXFirst renewal noticeS/N 22-758N2394PLamontagne Kyle H · Portland, TNBuilt 1955 · S/N 22-2785N2396JMeyer John Forrest · Pewaukee, WIBuilt 1979 · S/N 18-7909116N2397MBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCBuilt 1946 · S/N 12-1513N2399HApplegate Crist Amber · Derby, KSBuilt 1979 · S/N 18-7909180N2399PHoffa John C · South Bend, INS/N 22-2790N2399SWright Patrick S · Mullen, NES/N 18-7909143N2399UChilhowee Soaring Association Inc · Benton, TNBuilt 1972 · S/N 25-5429N23RBCaldwell Caleb Z · Anchorage, AKBuilt 1956 · S/N 22-4108N23TTEsp Ranch · Hardin, MTS/N 18-6684N2400SState Of Alaska · Anchorage, AKS/N 18-7909144N24010Fox Brent A · Janesville, WIBuilt 1980 · S/N 18-8009061N2402PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1956 · S/N 18-4261N2403MBossie Jeff J · Unity, MEBuilt 1947 · S/N 12-1638N2404MTodhunter John S · Hemet, CABuilt 1947 · S/N 12-1525N2404PKirby Ronald S · Reno, NVBuilt 1955 · S/N 18-4266N2405HPrevatt Stephen W DBA · Kodiak, AKBuilt 1979 · S/N 18-7909181N2405JHorne Donald Bayne Jr · Corpus Christi, TXS/N 18-7909118N2406JPorter Wade R · Durham, CABuilt 1979 · S/N 18-7909119N2409AVeldhuizen Richard B · Jesup, GABuilt 1952 · S/N 22-778N2409MNiner Mike LLC · Gonvick, MNS/N 12-1526N2410MSpicher Samuel C · Harrisonburg, VAS/N 12-1523N2410PPerry William N · Anchorage, AKBuilt 1955 · S/N 18-4277N2411PBurchfield Jon D · Gallatin, TNS/N 18-8009010N2412AWetzel Jay L · Xenia, OHBuilt 1952 · S/N 20-924N24146Wright Jeffrey N · Copper Center, AKBuilt 1961 · S/N 22-8258N2414PVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1955 · S/N 18-4289N2415PGlahn Guy R · Surprise, AZBuilt 1955 · S/N 18-4290N2416AKoenig Caleb A · Huntsville, TXBuilt 1952 · S/N 22-782N2417ASitta Donald C · Farmington, NMBuilt 1952 · S/N 22-781N2417PMehling Craig · Hardin, MTS/N 18-4293N2418ANation Linda S · Sanford, FLBuilt 1952 · S/N 22-784N2418MBallow Richard C · Valdez, AKBuilt 1947 · S/N 12-1652N2419ABoehlke Kevin P · New Baltimore, NYBuilt 1952 · S/N 22-786N2419PRegistration Pending · Lavale, MDRegistration pendingBuilt 1955 · S/N 22-3091N241KCChase Kenneth W · Anvik, AKS/N 22-4138N241TJenison Lawrence E · Chelsea, MIBuilt 1953 · S/N 18-2355N241TWScotton Bradley D · Galena, AKBuilt 1996 · S/N TW96-002N241WHMiller Michael A · Huffman, TXBuilt 1951 · S/N 18-816N2421PBoyko Matthew · Gilbert, AZBuilt 1955 · S/N 22-2792N2421SW Grotendiek LLC · Portland, ORBuilt 1979 · S/N 18-7909147N2422HBell Scott W · Greeley, COS/N 18-7909183N2424ABarnard Brian · Tallahassee, FLBuilt 1993 · S/N 1809075
Back to AD 99-01-05 R1