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.

N1219AFeltman Joshua C · Kenai, AKS/N 18-834N121BAPapst David · Freeland, MIS/N 22-9815N121BBFearon Terrence J · Whitehouse Station, NJBuilt 1963 · S/N 18-7908N1221AGerbi Charles R Trustee · Auke Bay, AKBuilt 1951 · S/N 18-832N1222ADawley Creek Ranch Nv LLC · Ruby Valley, NVBuilt 1951 · S/N 18-837N1224CIdaho Airplanes LLC · Boise, IDBuilt 1953 · S/N 22-1030N1225CTroxler Maxwell C · Greensboro, NCBuilt 1953 · S/N 22-1028N1226AWalsh Brendan · Seattle, WAS/N 18-841N1226CFortine Joseph A · Adin, CABuilt 1953 · S/N 22-1031N1227CMccall John L · Arlington, TXS/N 22-1034N122BEBarton Preston S · San Antonio, TXS/N 182360N122KYSeminole Flying & Soaring Inc · Clermont, FLBuilt 1968 · S/N 25-4576N122TCarraher Timothy J · Spalding, NEBuilt 1952 · S/N 18-2236N122WDyer James E · Brighton, COBuilt 1940 · S/N 4-846N1230CRandall Daryl Robert · Sutter Creek, CABuilt 1953 · S/N 22-1046N1232CLundquist Lance A · Wheaton, MNBuilt 1953 · S/N 22-1036N1233ADecker Leon T · Hollister, CABuilt 1951 · S/N 18-848N12381Bowers James E DBA · Galloway, OHBuilt 1961 · S/N 18-7746N1238AArnold Joe R · Burns, ORBuilt 1951 · S/N 18-1031N1238CPeters Grover C · The Hills, TXBuilt 1953 · S/N 22-1050N123BVInfinity Metalworks Inc · Newton, KSBuilt 1957 · S/N 22-5756N123SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1951 · S/N 181372N123WCLazare Luke B · Merrill, WIBuilt 1960 · S/N 22-7448N1241CPanagiotis Markopoulos · Suffolk, VABuilt 1952 · S/N 22-1049N1243CEndahl Eric A · Iowa City, IABuilt 1953 · S/N 22-1059N1244APickard Martha Anne Gabriel · Hudson, OHBuilt 1957 · S/N 18-1037N1246Lablanc Michael T · Intl Falls, MNBuilt 1954 · S/N 18-3347N12464Bell Todd J · Joliet, MTBuilt 1947 · S/N 12464N12465Sherburn Daniel E · Spring Lake, MIBuilt 1961 · S/N 22-9057N1246AGay Ranch Inc · Broadus, MTBuilt 1951 · S/N 18-1039N1247CSmith Paul J · Fremont, OHBuilt 1953 · S/N 20-968N1248ABaugh Andrew Lawrence · Anchorage, AKBuilt 1951 · S/N 18-1041N1248CCollier Luther Neal · Mc David, FLBuilt 1953 · S/N 22-1056N1249AAirmotive Service LLC · Brigham City, UTBuilt 1951 · S/N 18-1042N124GSDetommaso James F · North Pole, AKBuilt 1956 · S/N 5287N124TTappan East LLC · New Philadelphia, OHBuilt 1952 · S/N 18-2238N1251APappas Timothy G · Big Lake, AKS/N 18-1047N1252CDavis Doyle M · Clancy, MTBuilt 1953 · S/N 18-2491N1253ALange Keith J · Wasilla, AKBuilt 1951 · S/N 18-1049N1257Burns Richard O · Wasilla, AKBuilt 1963 · S/N 18-7907N1258ALake Country Lodge Inc · Port Alsworth, AKS/N 18-1053N1258CSmith Samuel Richard · Seward, AKBuilt 1953 · S/N 18-2497N1259AHigh Exposure Inc · Wilmington, DEBuilt 1951 · S/N 18-1054N1259CBowers Michael · Chugiak, AKBuilt 1953 · S/N 18-2500N125FGState Of Alaska · Kodiak, AKBuilt 1951 · S/N 18-1046N125KWilson Nancy J · Grand Rapids, MNBuilt 1976 · S/N 18-7709033N125RWallace Flying Service Inc · Wallace, NEBuilt 1976 · S/N 18-7709017N125RCChambers William M · Elkmont, ALS/N 20-615N1261CSale Reported · Denver, COSale reportedS/N 22-1053N1263AMurphy Janet A · Stafford, KSBuilt 1951 · S/N 18-1059
Back to AD 99-01-05 R1