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.

N4395AWheeler Michael P · Declo, IDBuilt 1956 · S/N 18-4810N4395MCurenton Brett · Elmore, ALS/N 12-3334N4396ABrachtenbach Eric · Hill City, KSS/N 18-4811N4396ZLanding Jerry D · Sullivan, MOBuilt 1968 · S/N 18-8727N4398AIberlin Ranch · Gillette, WYBuilt 1956 · S/N 18-4813N4398ZW I Moore Ranch Co Inc · Douglas, WYS/N 18-8731N4399ABent James L Jr DBA · Palatine Bridge, NYS/N 18-4816N4399HEakin Robert C · Franklin, PAS/N 15-183N4399MN4399m LLC · Morgan, UTBuilt 1947 · S/N 12-3339N4399ZFurber David E · Anchorage, AKBuilt 1974 · S/N 18-7409046N43CJLester Trevor L · Monte Vista, COBuilt 1959 · S/N 22-6928N43EHPowers Elbie L · Roseboro, NCBuilt 2000 · S/N 9906CCN4400HStein Wesley · Pierre, SDBuilt 1948 · S/N 15-184N4400ZTalon Air Service Inc · Soldotna, AKBuilt 1968 · S/N 18-8732N4401HMcclure Dennis N · Mc Alpin, FLS/N 15-185N4401MKubecka Jill · Edna, TXBuilt 1947 · S/N 12-3341N4402HKressler Brendan · Coopersburg, PAS/N 15-187N4402YGoven Benjamin T · Turtle Lake, NDBuilt 1966 · S/N 25-4008N4403HDjm Investments Inc · Menno, SDBuilt 1948 · S/N 15-188N4404AHanson Toby J · Webster, MNBuilt 1956 · S/N 22-3731N4404ZChapin William V · Fayetteville, GABuilt 1968 · S/N 18-8737N4405HAmmons Curtis D · Hernando, MSBuilt 1948 · S/N 15-190N4405ZLux Leon E · Hartsel, COBuilt 1968 · S/N 18-8738N4406HHenion John D · Trumansburg, NYBuilt 1948 · S/N 15-191N4406MSmith Matthew E · St Charles, ILBuilt 1947 · S/N 12-3358N4407ALange Brent W · Howard, OHBuilt 1956 · S/N 22-3735N4407HHollenbeck Kim D · Mobridge, SDS/N 15-192N4407ZSoule Clauson D · Cooperstown, NYBuilt 1968 · S/N 18-8740N4408AGalloway Douglas A · Sandusky, OHBuilt 1956 · S/N 22-3736N4408HHiebert Marvin R · Yelm, WABuilt 1948 · S/N 15-193N4408MGlen John Robert · Anchorage, AKBuilt 1947 · S/N 12-3360N4408ZHarwood Thomas K · Fairbanks, AKS/N 18-8741N4409HPelletier Willis E · Ridgeland, SCBuilt 1948 · S/N 15-194N4409MAnderson Ryan L · Roseville, MNBuilt 1947 · S/N 12-3361N4409ZStenga James E · Soldotna, AKBuilt 1968 · S/N 18-8742N4410EEkstrand Anders R Jr · Palmer, AKS/N 18-8109038N4410MAyresouth Aviation Inc · Lithia Springs, GABuilt 1947 · S/N 12-3362N4411HVagabond Flyers Inc · West Hartford, CTBuilt 1948 · S/N 15-196N4411ZTrower Charles T · Scobey, MTBuilt 1968 · S/N 18-8744N4412MSwinden Jonathan E · Danville, PABuilt 1947 · S/N 12-3363N4413ASaubert Steven R · Florence, ORBuilt 1956 · S/N 22-3741N4413MWings Of The North · Eden Prairie, MNBuilt 1947 · S/N 12-3364N4413ZBlackcountry Flying Experience Inc · Kalispell, MTBuilt 1968 · S/N 18-8746N4415ACanter Russell L · Enterprise, KSBuilt 1956 · S/N 22-3743N4415HLatham Richard · Loudon, NHBuilt 1948 · S/N 15-201N4416AAltendorf Richard C · Northwood, NDBuilt 1956 · S/N 18-5161N4416XByker Aviation Inc · Hawarden, IAS/N 12-44N4418ZHigh Wind Aviation Service LLC · Ludlow, VTBuilt 1968 · S/N 18-8753N4419HRicketts Jack E · Pensacola Beach, FLBuilt 1948 · S/N 15-208N4420HHauser Nathan S · Newark, DES/N 15-204
Back to AD 99-01-05 R1