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.

N59EEKern Raymond L · Bedford, INS/N 27-3390N59LVGreek John W · Tustin, CABuilt 1959 · S/N 24-1229N59RHSmith Mikeal A · Acton, CABuilt 1959 · S/N 24-1006N5BKRegistered aircraftBuilt 1961 · S/N 24-2677N5BYWolff Emanuel C Md · Tucson, AZBuilt 1963 · S/N 30-105N5EBN5eb LLC · Medina, OHBuilt 1967 · S/N 30-1474N5HMEvans Hayward D · Saint Augustine, FLBuilt 1973 · S/N 27-7305041N5MAScola Daniel B · Port Orange, FLBuilt 1967 · S/N 30-1622N5UZRick Aviation Inc · Newport News, VABuilt 1980 · S/N 44-8107008N5WKEz Air Inc · Wilmington, DES/N 30-1853N5WWClark Nikita C · Ontario, ORBuilt 1965 · S/N 30-708N6000PMoseley Timothy D · Calhoun, KYBuilt 1957 · S/N 23-1236N6001DJohnson Scott V · Scottsdale, AZBuilt 1956 · S/N 22-4652N6001PZarate Roger L · La Mirada, CABuilt 1959 · S/N 24-1095N6008XMangum Gary W · Centreville, VABuilt 1969 · S/N 301836N6009BMiller Robert L III DBA · Kittrell, NCS/N 22-8271N6009DKirkendall James A · N Richland Hills, TXS/N 22-4661N600AMid Atlantic Air Museum · Reading, PABuilt 1955 · S/N 22-3N600AHCoastal Road Aviation LLC · Mukilteo, WABuilt 1969 · S/N 24-4863N600RJRankin Richard · Germantown, TNBuilt 1979 · S/N 27-7954114N6010DTrenkamp John F · Oskaloosa, IAS/N 22-4662N6011YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3193N6013DBennett Garrett Douglas · Bonners Ferry, IDBuilt 1956 · S/N 22-4665N6014PTwo Men And A Plane Inc · Dearborn, MIBuilt 1959 · S/N 24-1109N6015PWeeks Vaughan B · Racine, WIBuilt 1959 · S/N 24-1110N6016DWells Roger M · Stratford, TXBuilt 1956 · S/N 22-4669N6016PCorson Dana · Helena, MTBuilt 1959 · S/N 24-1111N6016ZPrestenbach Kyle A · Vacherie, LAS/N 25-19N6017YTulsa Technology Center School District No 18 · Tulsa, OKS/N 27-3200N6018DBader Ronald W · Montrose, MIBuilt 1956 · S/N 22-4671N6019DKuper Carl J II · Dalhart, TXBuilt 1956 · S/N 22-4672N6019PN6019p LLC · Washington, DCBuilt 1959 · S/N 24-1114N6020DDufreche David S · Sanger, TXBuilt 1956 · S/N 22-4673N6021ZAerial Banners Inc · Pembroke Pines, FLS/N 25-25N6022PRegistered aircraftBuilt 1959 · S/N 24-1117N6023DBusta Daniel N · Los Angeles, CABuilt 1956 · S/N 22-4676N6024DPunt Matthew L · Wasilla, AKBuilt 1956 · S/N 22-4677N6027DSnyder Logan J · Wasilla, AKBuilt 1956 · S/N 22-4680N6027PJourney Over Destination Aviation LLC · Golden, COBuilt 1959 · S/N 24-1122N6029DRonnie L Tremain · Sherwood, ORBuilt 1956 · S/N 22-4682N602AKimberlin Lisa · San Francisco, CABuilt 1951 · S/N 22-5N6030DKnipper Larry R · New Lenox, ILBuilt 1956 · S/N 22-4683N6030PAngel Aviation LLC · Paradise, KSBuilt 1959 · S/N 24-1126N6030YReddick Brent · Paragould, ARBuilt 1969 · S/N 27-4370N6031DCeruto Jorge · Auburndale, FLS/N 22-4684N6032PStarrynight Bonanza Group LLC · Brighton, COBuilt 1959 · S/N 24-1128N6034YTan American Corporation · New York, NYRegistration revokedBuilt 1966 · S/N 27-3219N6035PWhited Craig L · Redington Beach, FLBuilt 1959 · S/N 24-1131N6035ZAerial Banners Inc · Pembroke Pines, FLBuilt 1959 · S/N 25-42N6036PKoop Christopher N · Lake Orion, MIS/N 24-1132
Back to AD 85-02-05 R1