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.

N3302MKinn Folk LLC · Anchorage, AKBuilt 1947 · S/N 12-2157N3302ZMeginnes Mark A · Tucson, AZS/N 22-7234N3303MWorringer Richard G · Tower, MNBuilt 1947 · S/N 12-2156N3303ZZanis Paul M · Wolfeboro, NHBuilt 1959 · S/N 22-7233N3304BDoty Danial J · Talkeetna, AKBuilt 1956 · S/N 22-2119N33063Kirschke John K · Seneca Falls, NYBuilt 1946 · S/N 5-443N33078Horan Mark E · Windsor Locks, CTBuilt 1940 · S/N 5-426N3307MTolbert Withers V · King Salmon, AKBuilt 1947 · S/N 12-2160N33082Lewis Milton K · Cortez, COBuilt 1940 · S/N 5-431N33087Swanson Timothy James · Bannister, MIS/N 5-437N3308ARegistered aircraftBuilt 1953 · S/N 22-1580N3308ZWeber Daniel Troy · Port Charlotte, FLS/N 22-7239N3309MWillford George A · Waterville, OHBuilt 1947 · S/N 12-2042N3309ZRubbert Randy C · Reynolds, NDBuilt 1959 · S/N 22-7241N330ARegistered aircraftBuilt 1954 · S/N 22-1939N330KRCherry Hill Aviation Inc · Freetown, INBuilt 1956 · S/N 22-4152N330TVan Hatten Derek R N · Anchorage, AKS/N 18-2444N33102Fort Bobby J · O Brien, FLBuilt 1940 · S/N 5819N33105Rogers William H III · Blackshear, GABuilt 1940 · S/N 5822N3310AKonrad Robert M · Centennial, COS/N 22-1587N3310BHilgendorf Ross E · Welcome, MNBuilt 1954 · S/N 22-2125N3310MToepper Richard B · Port Ludlow, WABuilt 1947 · S/N 12-2041N3311ARitchie John A Jr · Gold Hill, NCBuilt 1953 · S/N 22-1586N3311BJackson Tal H · Spearman, TXBuilt 1954 · S/N 22-2126N3311MAdams David R · Concrete, WABuilt 1947 · S/N 12-2170N3312ARegistration Pending · Myerstown, PARegistration pendingBuilt 1953 · S/N 22-1584N3312MDiedrich Paul E · Fort Mill, SCBuilt 1947 · S/N 12-2167N3312ZDemontigny Tyler R · Redding, CAS/N 227244N3313BOlling Stanley J Trustee · Wanatah, INBuilt 1954 · S/N 22-2128N33141Tarakji Mohamad H · Van Nuys, CABuilt 1940 · S/N 5859N3314AMichalek Construction Inc · Keosauqua, IABuilt 1953 · S/N 22-1589N3315MRegistered aircraftAssigned, pending cancellationS/N 12-2159N3316AStanley Daniel P · Hindman, KYS/N 22-1593N3316MHickey Aero Services LLC · White Hills, AZS/N 12-2169N3316NBender Dennis R · Johnson, VTBuilt 1946 · S/N 22515N3317MJacobs Robert E · Santa Fe, NMBuilt 1947 · S/N 12-2172N33180Van Wagner Aerial Media LLC · Hollywood, FLS/N 5-456N33187Haggerty John J Jr · Skaneateles, NYBuilt 1940 · S/N 5-462N3318BDeane Daniel G · Park City, UTBuilt 1954 · S/N 22-2133N3318MMh Aviation LLC · Foster City, CAFirst renewal noticeBuilt 1947 · S/N 12-2176N33193Boze Ken Marco · Palmer, AKFirst renewal noticeBuilt 1940 · S/N 4-1350N3319AThomas Brian D · Corning, IABuilt 1953 · S/N 22-1595N3319MWhirley Bradley J · Brainerd, MNBuilt 1947 · S/N 12-1883N331TShimkus Stanley M · N Huntingdon, PABuilt 1953 · S/N 18-2445N33204Crc Air Assets LLC · Houston, TXS/N 5910N3320MFena Daniel J · Side Lake, MNBuilt 1947 · S/N 12-2177N3320ZHolton Mark · Lebanon, MOBuilt 1960 · S/N 22-7255N3321BLee Donald R · Talkeetna, AKS/N 22-2136N33227Cranwill Joseph H · Chatham, ILBuilt 1940 · S/N 5902N33229Bowers Curt E · Jennings, LABuilt 1940 · S/N 5903
Back to AD 99-01-05 R1