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.

N57LCAero Fuel LLC · Leesburg, FLBuilt 2002 · S/N 9930CCN57WS4031 Aviation Inc · Bemidji, MNS/N 18-5463N5801HRodriguez Nicholas · Titusville, FLBuilt 1949 · S/N 16-417N5804ZColyer Gregory W · San Rafael, CABuilt 1963 · S/N 22-9657N5805DEasley Clarence E · Pleasanton, KSS/N 22-4480N5807HCollins James T · Blossvale, NYBuilt 1949 · S/N 16-424N5807ZBrown Duane A · Middletown, DES/N 22-9662N5808HReady Aim Flyer LLC · Hockessin, DEBuilt 1949 · S/N 16-425N5809ZLuckett Dennis G · Upland, CABuilt 1963 · S/N 22-9665N5810HInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 16-426N5813HLoewen Walter · Kodiak, AKBuilt 1949 · S/N 16-430N5813ZSmith Gregory E · White Lake, MIBuilt 1963 · S/N 22-9670N5814DMessinger Donald C · Wasilla, AKBuilt 1956 · S/N 22-4489N5814HPapich William · Boston, NYBuilt 1949 · S/N 16-431N5815HZernechel Craig A · Rockford, ILBuilt 1949 · S/N 16-432N5816DTurner Robert E · Talladega, ALBuilt 1956 · S/N 22-4491N5816ZPerdew Paul T · Mcfarland, WIBuilt 1963 · S/N 22-9674N5817HPiper Aviation Museum Foundation · Lock Haven, PABuilt 1949 · S/N 16-434N5817ZLamb Matthew P · Edmond, OKBuilt 1963 · S/N 22-9644N5818DCorral Oscar L · Fort Stockton, TXS/N 22-4493N5818HSlatter Lowell J · Buhl, IDBuilt 1949 · S/N 16-447N5819DMiceli Michael J · Frewsburg, NYBuilt 1956 · S/N 22-4494N5819HGaniere Constance L · Kemp, TXFirst renewal noticeBuilt 1949 · S/N 16-435N5819ZCristando Robert J · Wolfeboro, NHBuilt 1963 · S/N 22-9676N5820ZWilson Jonathon D · Breckenridge, MIBuilt 1963 · S/N 22-9677N5821HFifer Lucas J Trustee · Charlestown, INS/N 16-437N5822DFranz Stanley E · Yakima, WABuilt 1956 · S/N 22-4497N5822ZHogan Gerard T · Rockford, ILBuilt 1963 · S/N 22-9679N5824DWitthuhn Johnie B · Callaway, NEBuilt 1956 · S/N 22-4499N5827DNurge Richard · Gilroy, CAS/N 22-4502N5828DSchulz Lucas H · New Boston, MIBuilt 1956 · S/N 22-4503N58294Nance James Aaron · Woodbridge, VABuilt 1979 · S/N 18-7909055N5830CKueber Jake T · Anchorage, AKBuilt 1962 · S/N 18-7778N5830YMost Gordon G · Thedford, NEFirst renewal noticeS/N 18-8411N5831HJenrich Scott J · Lake Stevens, WABuilt 1949 · S/N 16-448N5832HForcey Charles F · Westville, INBuilt 1949 · S/N 16-450N5833DBixler Scott E · Rising Fawn, GABuilt 1956 · S/N 22-4509N5833HSchipul Melissa J · New Milford, CTBuilt 1949 · S/N 16-446N5833ZGrossman Larry R · White Pigeon, MIBuilt 1963 · S/N 22-9664N5834HPierce Gilbert H · Germantown, TNBuilt 1949 · S/N 16-453N5835ZNiemela Blair K · Wasilla, AKBuilt 1963 · S/N 22-9688N5836ZGaines Jesse B · Bryan, OHBuilt 1963 · S/N 22-9689N5838HPoliti Terris P · Lake Placid, NYFirst renewal noticeBuilt 1949 · S/N 16-457N5839HKinney Philip D · Audubon, MNBuilt 1949 · S/N 16-456N5839ZPhillips Michael K · Issaquah, WABuilt 1963 · S/N 22-9692N5840HFarrell Tammy · Sterling, AKBuilt 1949 · S/N 16-458N5841DLeopold Gary L · Winterset, IABuilt 1956 · S/N 22-4520N5842HUnivair Aircraft Corp · Aurora, COBuilt 1949 · S/N 16-460N5843HPerkins Jeffrey · Georgetown, TXBuilt 1949 · S/N 16-461N5843ZIkenberg H L · Butler, PABuilt 1963 · S/N 22-9697
Back to AD 99-01-05 R1