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.

N4657ZShort Michael J · Independence, ORBuilt 1961 · S/N 22-8180N4658MKoinzan Steven D · Valentine, NEBuilt 1947 · S/N 11-166N4659HSale Reported · Lake Stevens, WASale reportedBuilt 1948 · S/N 15-368N4660HBarnes Michael S · Kamiah, IDBuilt 1948 · S/N 17-67N4660YManess Gary D · Eagle River, AKS/N 18-8948N4661HMurray Edward K · Fallbrook, CABuilt 1948 · S/N 17-68N4662ZRegistration Pending · Georgetown, TXRegistration pendingS/N 22-8189N4663HJestice Valerie · Viola, ARS/N 15-369N4663MLakeland Aero Club Inc · Lakeland, FLS/N 11-172N4664HMurphy Terrence W III · Belmont, NHBuilt 1948 · S/N 17-69N4664ZAsh Leslie A · Lebanon, TNBuilt 1961 · S/N 22-8193N4666HToland Lance P · Griffin, GABuilt 1948 · S/N 17-71N4666MNorthstar Aerospray Inc · Clara City, MNBuilt 1947 · S/N 11-175N4667MVeal Elijah C · Kenai, AKBuilt 1947 · S/N 11-176N4669YHollister Soaring Center LLC · Hollister, CABuilt 1967 · S/N 25-4392N466AKRuckman Jim D Jr · Anchorage, AKBuilt 1947 · S/N 12-3194N4670HGay Corben D · Tunkhannock, PAS/N 15-372N4673MShuey Kenny L · Neosho, MOBuilt 1947 · S/N 11-182N4673ZNeuenburg James A · Clark Fork, IDFirst renewal noticeS/N 22-8206N4674HYost Brandon C · Watertown, SDS/N 15-373N4674ZHoadley Todd F · Springfield, OHBuilt 1961 · S/N 22-8207N4675HMichael Anna B · Port Orange, FLBuilt 1948 · S/N 15-374N46760Caterinichio Gasper D · Eagle River, AKBuilt 1954 · S/N 18-3907N46764Hatbright Farm LLC · Wilmington, DEBuilt 1954 · S/N 18-3913N4676HClay Lawrence A · Ellsworth, NHBuilt 1948 · S/N 17-77N4676ZNielsen Nancy A · Eugene, ORBuilt 1961 · S/N 22-8209N46773Macannamac Inc · Millinocket, MEBuilt 1954 · S/N 18-3591N46775Lookner Augustus · Owls Head, MEBuilt 1954 · S/N 18-3594N4677MRussell Adam G · Easton, MEBuilt 1947 · S/N 11-186N4678HStevens Cole J · Coeur D Alene, IDS/N 17-79N4678MDoenges Levi T · Chugiak, AKBuilt 1947 · S/N 11-187N4678ZQrh LLC · Bartlesville, OKBuilt 1961 · S/N 22-8213N46798Shermer Darlene Francis · Brooklyn Park, MNBuilt 1954 · S/N 183327N4680MBrannon Dennis M · Chilton, WIBuilt 1947 · S/N 11-189N4680ZPropelling The Gospel Missions Inc · Standish, MEBuilt 1961 · S/N 22-8215N4681HBohrman Robert C · New Berlin, WIBuilt 1948 · S/N 17-80N4681MScootair LLC · Alburgh, VTBuilt 1947 · S/N 11-190N4682HN4682h Inc · Jacksonville, FLBuilt 1948 · S/N 17-81N4684HHarvey Robert C · Hortonville, WIBuilt 1948 · S/N 15-377N4684MKillam Flying Service LLC · Carlinville, ILBuilt 1947 · S/N 11-195N4684ZGordon Stephen M · Velpen, INBuilt 1961 · S/N 22-8219N4685HMann Thomas A · Ford, WABuilt 1946 · S/N 17-84N4686HEckels Shaun R · Pickerington, OHBuilt 1948 · S/N 17-83N4686MWalker Michael E · Lewistown, MTBuilt 1947 · S/N 11194N4686ZMacmoyle Scott · Blairstown, NJBuilt 1961 · S/N 22-8222N4687MHock Rocky · Culbertson, NEBuilt 1947 · S/N 11-196N4688HChouinard Christopher P · Friday Harbor, WAS/N 17-86N4688MBrewer Samuel T · Wasilla, AKFirst renewal noticeBuilt 1947 · S/N 11-197N4688ZBurlew Richard · Richlands, NCBuilt 1961 · S/N 22-8225N4689MRoy Cybulski Farms Inc · Caro, MIBuilt 1947 · S/N 11198
Back to AD 99-01-05 R1