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.

N6037DDale Steven L · Monrovia, CABuilt 1956 · S/N 22-4690N6038DDiscovery Bay Aviation LLC · Port Townsend, WAFirst renewal noticeBuilt 1956 · S/N 22-4691N6039DPapp Adina M · Fort Edward, NYBuilt 1956 · S/N 22-4692N6039PProcredential LLC · Raleigh, NCBuilt 1959 · S/N 24-1135N6039YAllen Aviation Inc · Aynor, SCBuilt 1966 · S/N 27-3224N6040PWerner Christopher R · Anderson, CABuilt 1959 · S/N 24-1136N6043DDown And Green LLC · Trenton, MIBuilt 1956 · S/N 22-4696N6043PRoberts Ronald L · Pismo Beach, CABuilt 1959 · S/N 24-1139N6044YPinnock Charles W · Port St Lucie, FLBuilt 1966 · S/N 27-3230N6045DBigby Greg A · Reno, NVBuilt 1956 · S/N 22-4698N6045PEverroad Richard L · Bloomington, INBuilt 1959 · S/N 24-1141N6046DSlaughter Don Wayne · Farmville, NCBuilt 1957 · S/N 22-4699N6046YWells Douglas A · Chino, CAS/N 27-3233N6047ZValley Soaring Club · Middletown, NYBuilt 1959 · S/N 25-54N6048DHightower Samantha Gail · Kenai, AKFirst renewal noticeBuilt 1956 · S/N 22-4701N6048PJohnson Keith A · Atlantic Beach, FLBuilt 1959 · S/N 24-1144N6049DWalker John A · Kotzebue, AKS/N 22-4702N6049PMurolo Michael · Clancy, MTS/N 24-1145N6049ZLockwood Shawn O · Volborg, MTBuilt 1959 · S/N 25-56N604AMcmurtrey Loy D · Mountain Grove, MOBuilt 1951 · S/N 22-7N6050PNeuman Michael R · Valencia, PABuilt 1959 · S/N 24-1146N6052POn Site Aviation Inc · Hillsboro, NDBuilt 1959 · S/N 24-1148N6052YCentral Kentucky Aviation Inc · Bardstown, KYBuilt 1966 · S/N 27-3243N6052ZJackson Paul D · Phoenix, AZBuilt 1959 · S/N 25-59N6053ZSlack Brenda · Norfolk, VABuilt 1959 · S/N 25-60N6054PMartinez Juan R · San Bruno, CABuilt 1959 · S/N 24-1150N6056PN6056p LLC · Sonoma, CABuilt 1959 · S/N 24-1152N6057PAerdonlen · Pensacola, FLBuilt 1959 · S/N 24-1153N6058DJohnson Aaron J · Lewiston, IDBuilt 1956 · S/N 22-4711N6058YEltgroth Peter G · Livermore, CABuilt 1966 · S/N 27-3251N6058ZBlackstone Aircraft LLC · Hartselle, ALBuilt 1960 · S/N 25-18N6059PShearer Jay E · Coshocton, OHBuilt 1959 · S/N 24-1155N6060DHughes Truman C · Delta Junction, AKBuilt 1956 · S/N 22-4713N6062DKeeler Robert C · Scottsdale, AZS/N 22-4715N6062PYoung Tracy K · Newcomerstown, OHS/N 24-1158N6062YJahba LLC · Coral Springs, FLBuilt 1966 · S/N 27-3257N6064DAcadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1956 · S/N 22-4717N6066DDaily John F · Chugiak, AKBuilt 1957 · S/N 22-4719N6067PRoark William B · Silverdale, WABuilt 1959 · S/N 24-1163N6068DThorn Blake A · Coupeville, WAS/N 22-4721N6069YAngelman Aviation LLC · Prosper, TXBuilt 1966 · S/N 27-3267N606AAero Services Lc · Woods Cross, UTS/N 22-9N606CACv Wings LLC · Canby, MNBuilt 1972 · S/N 27-4853N6070PParcell Charles W · La Canada Flt, CABuilt 1959 · S/N 24-1166N6071DRiffle Thane G · Addy, WABuilt 1956 · S/N 22-4725N6071PKohler Thomas M · Brant Beach, NJS/N 24-1167N6073DDetrick Louis F · Eighty Four, PABuilt 1956 · S/N 22-4727N6073PBradshaw James L · Lenoir, NCBuilt 1959 · S/N 24-1169N6074PBerlingen Michael W · Oregon City, ORBuilt 1959 · S/N 24-1170N6075PMoore Leslie D · Raymore, MOBuilt 1959 · S/N 24-1171
Back to AD 85-02-05 R1