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.

N4923ZWeigel Martin C · Valley City, OHBuilt 1961 · S/N 22-8511N4924ZGlover Thomas B · Marana, AZBuilt 1961 · S/N 22-8514N4925ZKopacz Thomas H · Glen Flora, WIS/N 22-8515N4926YDenton Aerial Spraying Inc · Las Animas, COBuilt 1968 · S/N 25-4724N4928YSpragues Aerial Spraying Inc · Courtenay, NDBuilt 1968 · S/N 25-4727N4929ZDennis Robert · Rosamond, CAS/N 22-8519N492NDChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 4496241N492WAirplane Adventures LLC · Palos Heights, ILBuilt 1956 · S/N 23-611N4930PRegion Flyers LLC · Valparaiso, INS/N 27-523N4931ZThurmond Kenneth · Eastover, NCS/N 22-8521N4932ZWilczynski John J · Lake Village, INBuilt 1961 · S/N 22-8524N4933AAir Data Solutions LLC · Natchitoches, LAS/N 23-1718N4933ZSale Reported · Clio, MISale reportedS/N 22-8525N4934PAlm Holding LLC · Winton, CABuilt 1963 · S/N 27-527N4936ZDomeyer Daylen K · Cincinnati, OHS/N 22-8528N4938YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4738N4940PArpey Aviation Ltd · Colleyville, TXBuilt 1963 · S/N 27-535N4942PSchulz Beverly A · Merrill, WIBuilt 1963 · S/N 27-537N4943ZBlackford Robert G · Mt Airy, MDBuilt 1961 · S/N 22-8538N4944ZHoppes Larry J · Springville, INBuilt 1961 · S/N 22-8540N4945ZWillis James · Pelham, ALBuilt 1961 · S/N 22-8541N4947ZSatreaas Kenneth A · Verona, NDBuilt 1961 · S/N 22-8543N4948ZSenn Joshua · Depauw, INBuilt 1961 · S/N 22-8545N4949MCorben Sport Planes Museum LLC · Toccoa, GAS/N 20-640N4949PSonn Jeffrey R · Descanso, CAS/N 27-545N4949YPearce Richard Henry · Moses Lake, WAS/N 30-648N4949ZPeeples Ryan · Folkston, GABuilt 1961 · S/N 22-8546N494NJT And B Flying Adventures LLC · Middletown, DES/N 30-494N4951PKnights Aviation Services LLC · Westlake, OHBuilt 1963 · S/N 27-547N4955PJuber Glenn E · Coconut Creek, FLBuilt 1963 · S/N 27-555N4955ZSmetana Arthur E · Elmwood Park, NJBuilt 1961 · S/N 22-8561N4957EKuckkahn Dale P · Lake Tomahawk, WIS/N 22-4222N4958ZDacy Roy Wayne · Kingsland, TXBuilt 1961 · S/N 22-8560N4960250 Inc · Washington, DCS/N 24-4025N4960ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1961 · S/N 22-8562N4961PSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1963 · S/N 27-562N4964YFowler Larry K · Harrison, ARBuilt 1968 · S/N 25-4676N4964ZYoung Jimmy D · Watson, ARBuilt 1961 · S/N 22-8567N4965PKittner Robert T · Ellenville, NYBuilt 1963 · S/N 27-566N4966YSchmitt Rudy · Brookshire, TXBuilt 1968 · S/N 25-4767N4966ZIberlin John P · Gillette, WYBuilt 1961 · S/N 22-8573N4968ZGomm Bruce J · Shawano, WIBuilt 1961 · S/N 22-8572N4969ZJohnson James E · Stevensville, MTS/N 22-8577N496JDDonnelly Jamy Christopher · Crystal River, FLS/N 27-2028N4971PDodt Clinton Carl · Broomfield, COBuilt 1963 · S/N 27-573N4972ZFreeman David B · Liberty, NCBuilt 1961 · S/N 22-8570N4973PAviation Business Corp · Saint Louis, MOS/N 27-574N4974ZRobertson Douglas H · Frankston, TXS/N 22-8579N4977YQuality Aviation Inc · Marana, AZBuilt 1968 · S/N 25-4748N4977ZMcdorman Joshua · Collinsville, OKS/N 22-8583
Back to AD 85-02-05 R1