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.

N4539MBent James L Jr · Palatine Bridge, NYBuilt 1947 · S/N 11-43N4540ABeard Ryan Christopher · Oconomowoc, WIS/N 22-3849N4540MBiloff Chet Allen · Palmer, AKBuilt 1947 · S/N 11-44N4540ZBerdine Kenneth B · Arnoldsburg, WVBuilt 1961 · S/N 22-8045N4542HJ Weston Phillips · West Jefferson, NCBuilt 1948 · S/N 15-316N4542MHyrkas Thomas K · Calumet, MIBuilt 1947 · S/N 11-46N4542ZWaters Caleb M · Merritt Island, FLBuilt 1961 · S/N 22-8047N4543HRockdale Tiger Flight · Rockdale, TXS/N 15-317N4543MJoan Sunet Scutary · Umatilla, FLBuilt 1947 · S/N 11-47N4543ZSvec Adolph Ralph · Marengo, ILBuilt 1961 · S/N 22-8048N4544APhoenix Stephen R · Olympia, WABuilt 1956 · S/N 22-3853N4544HSarason Jay A · Monte Vista, COBuilt 1948 · S/N 15-318N4544MNorman Edward M · Palmer, AKS/N 11-59N4544ZTinker David G · Emlenton, PABuilt 1961 · S/N 22-8049N45458Plane Fun Inc Tr Trustee · Snellville, GABuilt 1967 · S/N 18-8553N4546HGivens Christopher A · Frankfort, OHBuilt 1948 · S/N 15-320N4546ZPutter Jerry · Wellington, KSBuilt 1961 · S/N 22-8051N45477Johnson Timothy D · Chapel Hill, NCS/N 18-8309003N4547AJones Richard F · T Or C, NMBuilt 1956 · S/N 22-3856N4548APue Thomas A · Marshfield, WIBuilt 1956 · S/N 22-3857N4549HPradhan Anis · Torrance, CABuilt 1948 · S/N 15-323N4549MBoardman Thomas M · Greenwich, NYS/N 11-49N4549YAbbott Christopher J · Gordon, NEBuilt 1971 · S/N 18-8937N454ABAerial Banners North Inc · Pembroke Pines, FLBuilt 1974 · S/N 25-7556048N454QTwin Buttes Ranch Inc · Shawnee, WYBuilt 1956 · S/N 18-4902N454WKeller Douglas · West Linn, ORBuilt 1979 · S/N 18-7909110N4550HParris David Tevis · Virginia Beach, VAS/N 15-324N4550MToth Frank L · Schenevus, NYBuilt 1949 · S/N 11-1009N4550YMiller Andy D · Marana, AZS/N 25-4201N4551HLehnert Roger J · Kennett Square, PABuilt 1948 · S/N 15-325N45526Mvs Air LLC · Kalispell, MTBuilt 1982 · S/N 18-8109035N4552AHall Mark R · New Smyrna Beach, FLBuilt 1956 · S/N 22-3862N4552HWatkins John J · Dalhart, TXBuilt 1948 · S/N 15-326N4553MClay Ernie · Huntington, WVBuilt 1947 · S/N 11-104N4553ZRisbon Scott W · Crystal Spring, PABuilt 1961 · S/N 22-8058N45543Colwell Mark C · ArrhusBuilt 1983 · S/N 18-8309014N4554HGehrels Leslie D · Spirit Lake, IABuilt 1948 · S/N 15-327N45552Aerospace Trust Management LLC Trustee · Wilmington, DES/N 18-8563N4555ALifetime Adventures LLC · Bellevue, MIBuilt 1956 · S/N 22-3866N4555HHuntley Lawrence H · Hernando, FLBuilt 1948 · S/N 15-328N4555ZScottini Ryan M · Kent, OHBuilt 1961 · S/N 22-8060N4556AScott Brent A · Fulton, MOS/N 22-3867N4556HGlenn Danny M · Centerville, IABuilt 1948 · S/N 15-331N4557ABuskey Walter B · Etna, NHBuilt 1956 · S/N 22-3868N4557HDeierlein Peter O · Chittenango, NYBuilt 1948 · S/N 15-329N4557MSkadsheim Richard L · Columbia, CABuilt 1947 · S/N 11-58N4557YPogany Stone C · Anchorage, AKBuilt 1971 · S/N 18-8938N4558MWilson Michael C · Mcminnvile, ORS/N 11-60N4559HWestern Antique Aeroplane & Automobile Museum · Hood River, ORS/N 15-333N4560YCleveland William B III · Canal Fulton, OHBuilt 1973 · S/N 18-7309017
Back to AD 99-01-05 R1