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.

N5729DLanzara Anne M · Salem, VABuilt 1956 · S/N 22-4427N5729HAbbott Sean N · South Paris, MEBuilt 1949 · S/N 16-341N5730HSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1949 · S/N 16-342N5731DBamford Gregory R · Pace, FLBuilt 1956 · S/N 22-4431N5731ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1963 · S/N 22-9570N5732DAerospace Center For Excellence Inc · Lakeland, FLBuilt 1956 · S/N 22-4432N5732HWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1949 · S/N 16-346N5735ZCrouch Michael G · Brazoria, TXBuilt 1963 · S/N 22-9574N5736HEdwards Stephen L Trustee · Wasilla, AKBuilt 1949 · S/N 16-348N5736ZMiller Andy D · Marana, AZBuilt 1963 · S/N 22-9575N5738HWalker Scott E · Largo, FLBuilt 1949 · S/N 16-350N5739DSmith James A · Lyle, WABuilt 1956 · S/N 22-4439N5739HRegistered aircraftBuilt 1949 · S/N 16-351N5740HPritchett Michael L · Benton, ARS/N 16-352N5740ZLashley Chad P · Wentzville, MOBuilt 1963 · S/N 22-9579N5741DJ&H Sewing & Vacuum Inc · Soldotna, AKBuilt 1956 · S/N 22-4441N5742DHemminger Blair · Gwinner, NDBuilt 1956 · S/N 22-4442N5744DDempsey Timothy P · Pacific, MOBuilt 1956 · S/N 22-4444N5745HManos Theodore W II · Omaha, NEBuilt 1949 · S/N 16-358N5747DMcmillian Roger L · Camdenton, MOBuilt 1956 · S/N 22-4447N5749ZTroy Michael J · Albion, NYBuilt 1963 · S/N 22-9588N574KRPhoenix Rising Aviation Inc · Bartlesville, OKS/N 22-5273N574LBThoft Matthew M · Wasilla, AKBuilt 1977 · S/N 18-7709109N574XAsher Curtis K · Wasilla, AKS/N 18-1030N5750ZFaux George F 11 · Newcastle, MEBuilt 1963 · S/N 22-9592N57532N57532 LLC · Wasilla, AKS/N 18-7809089N57534Sale Reported · Drake, NDSale reported, pending cancellationBuilt 1978 · S/N 18-7809090N5753HLindberg Samuel L · Odebolt, IAS/N 16-364N5753ZFereday Richard R · Mccall, IDBuilt 1963 · S/N 18-8026N5754DRocca John · Box Elder, SDS/N 22-4454N5754HPiper Aviation Museum Foundation · Lock Haven, PABuilt 1949 · S/N 16-365N5754ZKumley William A · Camarillo, CABuilt 1963 · S/N 22-9596N57550Freese Marc Alan · Fulda, MNBuilt 1977 · S/N 18-7709122N57555Norden Paul E · Anchorage, AKS/N 18-7709124N5755DNathan Timothy A · Arnold, MDBuilt 1956 · S/N 22-4455N5755HMccafferty Gerald F · Tumwater, WABuilt 1949 · S/N 16-367N5755ZSkibinski James J · Senoia, GABuilt 1963 · S/N 22-9597N57562Sitter Timothy L · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 18-7809093N5756YLamascus Mark S · King City, CAS/N 18-8325N5757HWahlquist Andrew J · Honey Grove, TXBuilt 1949 · S/N 16-369N5758ZColt 135 LLC · Lexington, NEBuilt 1963 · S/N 22-9600N5759ZBuds Auto Parts Ltd · Gowen, MIBuilt 1963 · S/N 22-9601N5760DCrow Jack R · Bethel, AKBuilt 1956 · S/N 18-5262N5760HPickering Jarold A · Columbus, KSBuilt 1949 · S/N 16-372N57617Elijah Air LLC · Bethel, AKBuilt 1977 · S/N 18-7709125N5762APort Michael J · Twisp, WABuilt 1957 · S/N 185733N5762ZGulley Gordon L · Manteno, ILS/N 22-9604N5763DGronning Chris D · Anchorage, AKS/N 18-5265N5763ZCarlton Marvin R · Tomahawk, WIBuilt 1963 · S/N 22-9605N5764DKoelsch Wayne M · Anchorage, AKBuilt 1956 · S/N 18-5266
Back to AD 99-01-05 R1