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.

N4969ZJohnson James E · Stevensville, MTS/N 22-8577N4970HCordell Ryan O · Capitol, MTS/N 11-844N4971HNesin Christopher G · Chattanooga, TNBuilt 1948 · S/N 11-845N49722Kapeller James A · Wickenburg, AZBuilt 1943 · S/N 5-1438N4972ZFreeman David B · Liberty, NCBuilt 1961 · S/N 22-8570N4973HFodor Scott M · Barryton, MIBuilt 1948 · S/N 11-850N4973MHuddelston James D · Anchorage, AKBuilt 1948 · S/N 11-461N4974ZRobertson Douglas H · Frankston, TXS/N 22-8579N4975HMorris Shannon D · Deadwood, SDBuilt 1948 · S/N 11-854N49762Marici Christopher W · Lake Ariel, PAS/N 7475N4977YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4748N4977ZMcdorman Joshua · Collinsville, OKS/N 22-8583N4978HCool Taildraggers LLC · Red Oak, IAS/N 11-858N4980ZElliott Charles · Rock Spring, GABuilt 1961 · S/N 22-8588N4981MGeorge Andrew N · Alden, NYBuilt 1948 · S/N 11-468N4981ZSmith Carroll D · Ethel, LABuilt 1961 · S/N 22-8590N4983HGelinger Joseph J · Las Vegas, NVBuilt 1948 · S/N 11-863N4983YCaprock Soaring Association · Lubbock, TXBuilt 1968 · S/N 25-4787N4983ZKoerner Aviation Inc · Kankakee, ILBuilt 1961 · S/N 22-8592N4984ZRegistered aircraftS/N 22-8593N4985HHinkle Jason D · Cavalier, NDBuilt 1948 · S/N 11-853N4985MAerial Crop Care Co · Hebron, NDS/N 11-472N4986ZAlbers William J · Sidney, OHBuilt 1961 · S/N 22-8594N4987HSmutny John G · Auburn, WABuilt 1948 · S/N 11-870N49889Hoover Michael B · Ridgeland, WIS/N 5-1067N4988HBent James L Jr DBA · Palatine Bridge, NYS/N 18-1955N4988MSatreaas Kenneth A · Verona, NDBuilt 1948 · S/N 11-476N4988YVan Kleek Steve D · Milford, IABuilt 1968 · S/N 25-4797N4990PCrux Logistics & Consulting Ltd · Las Vegas, NVBuilt 1967 · S/N 18-8564N4990ZHanson Ethan C · Blanchard, NDBuilt 1961 · S/N 22-8598N4991HFaber Elgin J · Havre, MTBuilt 1948 · S/N 11-884N4991NSage Daniel M · Girdwood, AKS/N 18-872N4991ZSenneff James L · Clarence, NYBuilt 1961 · S/N 22-8599N4992HJaeger Bruce C · Hebron, NDBuilt 1948 · S/N 11-887N4993PHatch George R · Avon, MABuilt 1967 · S/N 18-8577N4994ZAom Aircraft LLC · Wilmington, DES/N 22-8604N4995HPeterson Ronald W Trustee · Mitchell, SDBuilt 1948 · S/N 11-886N4995ZBoyer James A · Lancaster, OHBuilt 1961 · S/N 22-8605N4997HBridgewater Benjamin J · Whitefish, MTBuilt 1949 · S/N 11-879N4997MNiner-Niner-7-Mike LLC · Palmer, AKBuilt 1948 · S/N 11-485N4997PBrown Tyler Cooper Trustee · Anchorage, AKBuilt 1967 · S/N 18-8580N4997ZRoyal Flush Farms LLC · Davey, NEBuilt 1961 · S/N 22-8607N4998HBartosh Jared F · Carthage, MOBuilt 1949 · S/N 11-893N4999ZMendoza Justin · Paso Robles, CABuilt 1961 · S/N 22-8544N49AKIllig Peter E · Anchorage, AKFirst renewal noticeBuilt 1956 · S/N 22-3814N49CFWtf Partnership · Anchorage, AKBuilt 1976 · S/N 18-7609110N49DPPrince David A · Homer, AKBuilt 1975 · S/N 18-7509035N49JCMeyer Benjamin R · Glenburn, MES/N 18-5327N49JKWilliams Casey D Trustee · Wasilla, AKBuilt 1954 · S/N 18-3329N49PCFoster David W · North Fort Myers, FLS/N 16-194
Back to AD 99-01-05 R1