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.

N9540DGibsons Gas Inc · Holland, NYBuilt 1958 · S/N 22-6456N9540PStuder Al C · Shelby, MIBuilt 1974 · S/N 25-7405628N9544DPhilpott Stuart L · Taylorsville, KYBuilt 1958 · S/N 22-6461N9545DFaught Jeffrey R · Bismarck, NDBuilt 1958 · S/N 22-6462N9546DTripacer Leasing LLC · Lauderhill, FLBuilt 1958 · S/N 22-6463N9546PVacaville Aero Services Inc · Williams, CABuilt 1974 · S/N 25-7405646N9547DStoltz Michael A · Portland, ORS/N 22-6464N954AReber Stephen D · Corrales, NMBuilt 1951 · S/N 22-266N9551DHhd Aviation LLC · Hamilton, OHS/N 22-6468N9554DChase 13 LLC · Wilmington, DES/N 22-6471N9555DGehring Robert A · Rubicon, WIBuilt 1958 · S/N 22-6472N9556DHanderson Ronald J Sr · Sitka, AKBuilt 1958 · S/N 22-6473N9558DMadison James Edward · Concord, CAS/N 22-6475N9558PStevens Raymond W · Norfolk, VABuilt 1974 · S/N 25-7405673N95594Sale Reported · Smyrna, GASale reported, pending cancellationBuilt 1965 · S/N 24-4188N9560PJetran LLC · Horseshoe Bay, TXBuilt 1974 · S/N 25-7405674N9561DHughey Randal P · Muskegon, MIBuilt 1958 · S/N 22-6478N9566DHerbert Brendan A · Portola, CAS/N 22-6483N9567DFurois Alex D · Bridger, MTBuilt 1958 · S/N 22-6484N9573PAerial Banners Inc · Pembroke Pines, FLBuilt 1974 · S/N 25-7405683N9576PPhiladelphia Glider Council · Hilltown, PABuilt 1974 · S/N 25-7405689N957ATetzlaff Christian · Athens, GABuilt 1951 · S/N 22-269N957SSkymark Airlines · Sacramento, CARegistration revokedBuilt 1962 · S/N 27-2136N9582DMontminy John · Berlin, NHBuilt 1958 · S/N 22-6489N9584PSugarbush Soaring Assn Inc · Warren, VTBuilt 1974 · S/N 25-7405702N9585DArnt James Robert Jr · Worthington, MNBuilt 1958 · S/N 22-6492N9586DHauser Nathan S · Newark, DES/N 22-6493N9588DGardner Brian D · Mesa, AZS/N 22-6495N958AMurray Martha D · Moneta, VABuilt 1951 · S/N 22-273N958BPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496653N9592DJohnson Jeremiah W · Tulsa, OKS/N 22-6499N9595DSchlosser Joseph V · Rockford, MNBuilt 1958 · S/N 22-6502N9596DRoss Jack H · Portland, ORBuilt 1958 · S/N 22-6504N9598DDurden William L · Tallahassee, FLBuilt 1958 · S/N 22-6506N959CVaero Inc · Vinton, VABuilt 1981 · S/N 27-8154029N95FSN95fs Ltd · Chicago, ILBuilt 1969 · S/N 30-1786N95TKTalos Aviation Group LLC · Blackstone, VABuilt 1970 · S/N 27-4555N9601DRiffle David T · Woodinville, WABuilt 1958 · S/N 22-6510N9603DHeartland Aviation Inc · Alliance, NES/N 22-6512N9605DDirty Side Down LLC · Downers Grove, ILBuilt 1958 · S/N 22-6514N9606DNiemi Danny L · Osage, MNS/N 22-6516N9607DRomo Mark A · Dillingham, AKBuilt 1958 · S/N 22-6517N9609PMerlin Aviation Inc · Moriarty, NMBuilt 1976 · S/N 25-7656007N9610DHicks Joseph O · Germanton, NCBuilt 1958 · S/N 22-6520N9612DSoto Edward · Wasilla, AKBuilt 1958 · S/N 22-6522N9615DPeterson Thomas M · Park Rapids, MNBuilt 1959 · S/N 22-6525N9617DWinton Christopher M · Valley Center, KSBuilt 1958 · S/N 22-6528N9618DRich Beryl G · Brush Prairie, WABuilt 1958 · S/N 22-6529N9619DSciotti Michael V · Wasilla, AKBuilt 1958 · S/N 22-6530N961DJSeibly Larry · Mckinney, TXBuilt 1960 · S/N 24-1955
Back to AD 85-02-05 R1