OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,920

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:85-02-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:85-02-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.

N500PFord Charles D · Clifton, TNS/N 24-341N500TDPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7854027N5010ZSchwagerman William C · Kingsville, MOBuilt 1961 · S/N 22-8621N5011ZHarders Justin · Cairo, NES/N 22-8624N5012AEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeBuilt 2001 · S/N 4496044N5014PSky Valley Aviation LLC · Waverly, IAS/N 24-17N5014ZHicks Francis · Elizabeth, PABuilt 1961 · S/N 22-8629N5015ZQuirk Charles Leo · Lake Charles, LABuilt 1961 · S/N 22-8630N5017PPineapple Air LLC · Wilmington, DEBuilt 1957 · S/N 24-20N5018YHighland Rim Aviation LLC · Springfield, TNBuilt 1963 · S/N 27-2020N5018ZDowning John D · Marion, MIBuilt 1961 · S/N 22-8633N5019ZCsapos Garry A · Ovid, MIS/N 22-8634N501BCJamestown Jet Center Inc · Jamestown, NDBuilt 1973 · S/N 27-7305157N501REIndependence Aerospace LLC · Kennesaw, GABuilt 1963 · S/N 30-194N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23N5021ZFansler Rick L · Delta, OHBuilt 1961 · S/N 22-8636N5023YAas LLC · Ovid, MIBuilt 1962 · S/N 27-2027N5023ZBauer Glenn D · Wishram, WABuilt 1961 · S/N 22-8638N5025ZDean Charles William III · Boyle, MSBuilt 1961 · S/N 22-8640N5026ZBrown Robert C III · Whiteville, NCBuilt 1961 · S/N 22-8641N5029PJordan Walter B · Chehalis, WABuilt 1958 · S/N 2432N5029ZSvec Adolph Ralph · Marengo, ILBuilt 1961 · S/N 22-8647N502DWSolamich Aviation LLC · Huntley, ILBuilt 1971 · S/N 39-124N5030ZBoring Walter A · Appomattox, VABuilt 1961 · S/N 22-8648N5033ZCada Kenneth C · Phoenix, AZS/N 22-8651N5034PNeufeld William J · Bostwick, FLBuilt 1958 · S/N 24-37N5035ZAmish Peter S · Newberry, FLBuilt 1961 · S/N 22-8653N5037ZBoyd Christian K · Corinth, TXBuilt 1961 · S/N 22-8655N5038YAileron Buzz LLC · Daytona Beach, FLBuilt 1962 · S/N 27-2044N5039ZWeatherford John A · Kinder, LABuilt 1961 · S/N 22-8659N503JALiem David H · Brea, CABuilt 1965 · S/N 24-4165N5042ZSmart Alan G · Lincoln, MEBuilt 1961 · S/N 22-8662N5045PMccarty Paul S · Wichita, KSBuilt 1958 · S/N 24-49N5045YWingsolutions Corp · Miami Lakes, FLS/N 27-2054N5045ZHollis Dustin · Pembroke, KYS/N 22-8667N5047ZVanvalkenburgh Sidney B · Madras, ORS/N 22-8671N5048PBrown Mark E · Charlotte, NCBuilt 1958 · S/N 24-52N5049ZHelderman Laban W · Newton, NCBuilt 1961 · S/N 22-8673N5050PBoucher Bobbi · Fredericksburg, VAS/N 24-54N5050ZSyers Jacob L · Canton, GABuilt 1961 · S/N 22-8674N5051PGrorud James R · Milbank, SDBuilt 1958 · S/N 24-55N5054ZSarver Kevin C · Mineral Wells, TXS/N 22-8678N5055ZStevens Mark F · Ocean Springs, MSBuilt 1961 · S/N 22-8679N5056ZLacy Scott · El Dorado, ARS/N 228680N5058PBakeman Michael G · Sturgis, MIBuilt 1958 · S/N 24-507N5059ZWarren Kenneth N · Anamosa, IABuilt 1961 · S/N 22-8684N505BJLa Beau Lawrence O · San Angelo, TXBuilt 1961 · S/N 24-2331N505GAlford Robert S · Columbus, GARegistration revokedBuilt 1964 · S/N 30-251N5062ZTerpstra Gregory K Trustee · Potosi, MOBuilt 1961 · S/N 22-8687N5063ZMuehlberg Timothy M · Tuttle, OKBuilt 1961 · S/N 22-8688
Back to AD 85-02-05 R1