OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,917

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.

N1004PVankirk Malcolm R · Frederick, MDBuilt 1954 · S/N 23-6N1008NK W Racing LLC · Angola, INBuilt 1973 · S/N 27-7305152N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050N100YGAnderton Doyle M · Royse City, TXS/N 31P-7530010N1017PZeivogel Jeanine · Gulf Shores, ALBuilt 1954 · S/N 2319N1018TLeon J Hapka · Halma, MNS/N 24-4884N1019TAndrew University · Berrien Springs, MIBuilt 2006 · S/N 4496232N101DHLarson David R · Boerne, TXBuilt 1960 · S/N 24-1833N101HHElmhurst Holdings LLC · East Rochester, NYBuilt 1980 · S/N 27-8054057N101NWVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1961 · S/N 27-475N101PLHay William G Jr · Gualala, CAS/N 27-7754156N101SLSweet Potato Flying Club LLC · Kalamazoo, MIBuilt 1959 · S/N 23-1832N101UAReichard David Elijah · Breinigsville, PABuilt 1960 · S/N 23-1950N1020HHw Barnhouse Inc · Vero Beach, FLBuilt 1968 · S/N 30-1569N102DHPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496597N102WRSt Onge Adam R · Sterling, AKBuilt 1952 · S/N 20-919N1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35N1033TManzo Deborah S · Lake Placid, FLBuilt 1973 · S/N 27-7405302N1036LN1036l Corp · Wilmington, DEBuilt 1976 · S/N 27-7654135N103BMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 44-8107007N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153N103PGHnd Operations LLC · Henderson, NVBuilt 1969 · S/N 30-1858N103RSZielke Michael M · Chuluota, FLBuilt 1957 · S/N 23-1165N104CPN7293l LLC · Waxahachie, TXBuilt 1966 · S/N 30-1276N105CHMach Tuck LLC · Daytona Beach, FLBuilt 1974 · S/N 27-7405419N105EBHardy Randall B · Argyle, TXBuilt 1956 · S/N 23-460N1065PChisum Robert · Lorenzo, TXS/N 23-75N1066QMoretti Anthony M · Deming, NMS/N 20-1055N106JLinder Michael A · Arvada, COBuilt 1961 · S/N 24-2668N106JLMusic City Air LLC · Rogersville, ALBuilt 1963 · S/N 27-2416N1070BCurtis Julia A · Holladay, UTBuilt 1964 · S/N 24-3620N1071PFlying Circus Aircraft LLC · Manitou Beach, MIBuilt 1954 · S/N 23-82N107PAPacific Fleet Aviation LLC · Rochester, NYS/N 27-7854002N10816Van Der Merwe Coenraad · Traverse City, MIBuilt 1968 · S/N 244753N10853St Johns Marine DBA · San Mateo, FLS/N 277854024N1089PDetert Bradley · Valparaiso, INBuilt 1954 · S/N 23-98N108CSFlight Expo Inc · Zimmerman, MNS/N 22-9054N108SGVahsholtz Matthew James · Conroe, TXBuilt 1958 · S/N 24-149N1099PHansen K Brent · Captain Cook, HIS/N 20-510N109CCTrans-Caribbean Air Exp & Imp Inc · Miami, FLBuilt 1968 · S/N 27-4024N10HFFrancis Harvey B · Fairbanks, AKS/N 22-2432N10MAPatterson Casey Paul · Kinston, ALS/N 24-4180N10NWLinzey David Wayne · Boone, NCBuilt 1963 · S/N 24-3548N10PSCarson Glen W · Garber, OKBuilt 1955 · S/N 22-2687N10SGBranyan Tyson E · Cushing, OKBuilt 1960 · S/N 24-2112N10YDDavenport Jimmy J · Hayesville, NCBuilt 1965 · S/N 27-2892N1100CGraves Robert E · Danville, INS/N 20-955N1100LRaider Aviation LLC · Lubbock, TXS/N 30-12N1106CRiver Town Aviation LLC · Williamstown, WVS/N 22-948
Back to AD 85-02-05 R1