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.

N5764ZModra Anthony K · Fredonia, WIS/N 22-9606N5767DNorthern Lights Ventures LLC · Moose Pass, AKS/N 18-5257N5767HSereg John Michael · Indianola, IABuilt 1949 · S/N 16-381N5768DOdonnell Daniel V · Dover, DEBuilt 1956 · S/N 18-5269N5768HHatton George L · Talihina, OKBuilt 1949 · S/N 16-380N57698Falkner Jeffrey A · Glennallen, AKBuilt 1977 · S/N 18-7709126N5769DLange Keith J · Merrill, WIS/N 18-5270N5769ZFox John F Jr · Mc Cormick, SCS/N 22-9611N5770HBellino Dominic P · Florence, COBuilt 1949 · S/N 16-386N5771DEllison Stephen · Anchorage, AKBuilt 1956 · S/N 18-5273N5771ZDavenport Brad E · Eagle River, AKBuilt 1963 · S/N 22-9613N5772DLong Randy B · Coleman, TXBuilt 1956 · S/N 18-5274N5773DGolden Arrow Aviation Inc · Wilmington, DEBuilt 1956 · S/N 18-5275N5773HSchneider Beth A · Midway, UTBuilt 1949 · S/N 16-384N5773MHulslander Taylor · North Pole, AKBuilt 1975 · S/N 18-7509082N5774HPerron Ted J · White Bear Lake, MNFirst renewal noticeBuilt 1949 · S/N 16-385N5774ZLiming Danny O · Andrews, TXS/N 22-9610N57753Golden Arrow Aviation Inc · Wilmington, DES/N 18-7709128N5775HBlake Clark D · Belle Fourche, SDFirst renewal noticeS/N 18-1688N5776HMastre Joshua M · Soldotna, AKBuilt 1949 · S/N 16-389N57777Thorsgard Keith A · Mcville, NDBuilt 1978 · S/N 18-7809094N57778Seidler Matthew J · Anchorage, AKS/N 18-7709129N57787Shoultys Shawn P · Denali Park, AKBuilt 1977 · S/N 18-7709131N5778ZWhelan Cynthia Vs · Seneca, SCBuilt 1963 · S/N 22-9623N57792Arizona Game & Fish Dept · Phoenix, AZBuilt 1977 · S/N 18-7709132N5779DAltenburg Scott J · Anchorage, AKBuilt 1956 · S/N 18-5295N5779HKelly David L · Pendleton, ORBuilt 1949 · S/N 16-395N5779ZSvec Adolph R · Marengo, ILBuilt 1963 · S/N 22-9624N577CMEllison Ranching Co · Elko, NVBuilt 1977 · S/N 18-7709134N5780HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1949 · S/N 16-393N5780ZBergstrom Robert L · Amelia Court House, VABuilt 1963 · S/N 22-9625N5782HTomas Douglas J · East Troy, WIBuilt 1949 · S/N 16-397N5783HBellas Bryan T · Geneva, OHBuilt 1949 · S/N 16-398N5783ZAlix Brian R · Valley Falls, NYBuilt 1963 · S/N 22-9627N5784HWright William J · Raeford, NCS/N 16-399N5786HLynn Leroy D · New Carlisle, OHBuilt 1949 · S/N 16-402N5787HLagace Donald O · Augusta, MEBuilt 1949 · S/N 16-403N5787ZFaust David E · Windber, PAS/N 22-9631N5788HMillar George B · Le Claire, IABuilt 1949 · S/N 16-404N57891East Hampton Air LLC · Wainscott, NYBuilt 1941 · S/N 5-1308N5789DTripacer Bretheren LLC · Longview, WABuilt 1956 · S/N 22-4465N5789HBlumer Charles · Fullerton, CAS/N 16-405N5790DJohnston Jeff · Edgewood, NMBuilt 1956 · S/N 22-4466N5791DBrown Todd G · Corvallis, ORBuilt 1956 · S/N 22-4467N5793HZrelak Patrick · Apple Valley, CAFirst renewal noticeBuilt 1949 · S/N 16-409N5794HChristopherson Jack T Trustee · Overgaard, AZS/N 16-410N5796ZJankow Edward W · Clinton Township, MIBuilt 1963 · S/N 22-9647N5797DSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 22-4473N5798HKroenlein Donald G · Moweaqua, ILBuilt 1949 · S/N 16-414N5799DBusse Charles U · Oakwood Hills, ILBuilt 1956 · S/N 22-4364
Back to AD 99-01-05 R1