OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,638

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.

N1380AGlenn Douglas W · Palmer, AKBuilt 1951 · S/N 18-1211N13814Kubal Daniel K · Port Charlotte, FLBuilt 1971 · S/N 18-8958N13833Fox Kevin B · Wasilla, AKBuilt 1972 · S/N 18-8959N13858Covell Timothy N · Healy, AKBuilt 1971 · S/N 18-8964N1385CBlake Hughie R · Cordova, AKBuilt 1953 · S/N 18-2638N13863Johnson S Michael · Lakewood, NYBuilt 1974 · S/N 18-7409050N1386AState Of Alaska · Anchorage, AKBuilt 1951 · S/N 18-1219N1387GList Martinus R · Wasilla, AKS/N 18-3521N13880Gilbert Daniel K · Kodiak, AKBuilt 1974 · S/N 18-7409051N13895Gross Roger G · Beulah, WYBuilt 1974 · S/N 18-7409054N1389AMorris David G · Wasilla, AKBuilt 1951 · S/N 18-1220N138ABAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3915N13904St Louis Soaring Assoc Inc · Saint Louis, MOBuilt 1971 · S/N 18-8970N13910Coryell James M · Valdez, AKBuilt 1974 · S/N 18-7409055N13911Northern Aeroworks LLC · Eagle River, AKBuilt 1971 · S/N 18-8972N1391CSale Reported · Beech Creek, PASale reportedBuilt 1953 · S/N 22-1143N13925Lindsay John S · Freeport, PABuilt 1971 · S/N 18-8973N13927Zerck Joseph W · Anchorage, AKBuilt 1972 · S/N 18-8977N1392AHerrig Daniel C · King Salmon, AKBuilt 1951 · S/N 18-1228N13931Mahoney Edmund Mont · Anchorage, AKBuilt 1972 · S/N 18-8978N13937Rafter J Aviation LLC · Moab, UTS/N 18-8979N1393CHayden Daniel · North Pole, AKS/N 20-980N1394RRoss Bill · Meridian, MSBuilt 1952 · S/N 18-1983N1394YOjendyk Mark R · Newcastle, WABuilt 1953 · S/N 18-3357N13951Black Timber Aviation LLC · Rifle, COBuilt 1972 · S/N 18-8981N13960John Mark Air Repair LLC · Chugiak, AKBuilt 1972 · S/N 18-8984N13973Rs Specialties LLC · Anchorage, AKBuilt 1972 · S/N 18-8985N1397CDerr Rodney W · Frackville, PAS/N 22-1154N1398AN1398a LLC · Anchorage, AKS/N 18 1234N1399CShankster Thomas G · Aurora, COBuilt 1953 · S/N 22-1150N13DBBauer Dereck R · Springfield, ORS/N 12-2919N13FFVeal Tim S · Kenai, AKBuilt 1954 · S/N 18-3415N13RYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 18-1727N13YFTemple Peter L · Harrisville, NHS/N 12-848N14043Beranek James D · Cottage Grove, ORBuilt 1972 · S/N 18-8986N14044Myron Kurt J · Elbow Lake, MNBuilt 1972 · S/N 18-8987N1404ALindinger John I · Auburn, NEBuilt 1951 · S/N 22-318N1405CGbq LLC · New Prague, MNBuilt 1953 · S/N 22-1162N14064University Of Central Missouri · Warrensburg, MOBuilt 1972 · S/N 18-8989N1406NShirley Tyler A · Dalton, GABuilt 1947 · S/N 22929N1407CLafreniere Joseph A · Harmony, MNBuilt 1953 · S/N 22-1157N1411APetz Matthew M · Sandpoint, IDBuilt 1951 · S/N 22-323N1411CBraden James L · Hillsboro, KSS/N 22-1165N1412CStanley Gregory S · Glasgow, MTBuilt 1953 · S/N 22-1173N1415AHock Wesley S · Holbrook, NEBuilt 1951 · S/N 22-326N14167Davis Ronald L Jr · Soldotna, AKBuilt 1974 · S/N 18-7409097N1418CWaaam Volunteer Flying Association LLC · Hood River, ORS/N 22-1175N141TRipley Jesse W · Wasilla, AKBuilt 1953 · S/N 18-2255N1421AKoplitz Wesley D · Oshkosh, WIS/N 22-336N14226Lathem Douglas · Dalhart, TXBuilt 1974 · S/N 18-7409099
Back to AD 99-01-05 R1