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.

N9914PCounty Of Galveston · Dickinson, TXBuilt 1975 · S/N 36-7560022N991ACXin Han Aviation LLC · Randolph, MABuilt 1979 · S/N 44-8095011N991EMelson William · Palm City, FLBuilt 1964 · S/N 24-4083N991KLutkus Gerald A · Medina, OHBuilt 1964 · S/N 24-4055N991SESoutheastern Oklahoma State University · Durant, OKBuilt 2022 · S/N 4496543N992Baker Duke I · Jackson, MSBuilt 1957 · S/N 23-965N9923PMundell Terry D Trustee · Rosston, OKBuilt 1975 · S/N 36-7560033N9928PQuality Aviation Inc · Marana, AZS/N 36-7560039N992RMPalm Aerobatic Aircraft LLC · Port Saint Lucie, FLS/N 22-6863N992SESoutheastern Oklahoma State University · Durant, OKBuilt 2022 · S/N 4496544N9938PHeartland Aviation Inc · Alliance, NEBuilt 1975 · S/N 36-7560050N993DBBauer Dereck R · Springfield, ORS/N 22-6904N9947PQuality Aviation Inc · Marana, AZBuilt 1975 · S/N 36-7560058N994AQuality Aviation Inc · Marana, AZS/N 22-310N9950DSierra Charlie Aviation LLC · Sandpoint, IDS/N 22-6738N9951DDicenzo Eugene N · Cumberland, RIBuilt 1959 · S/N 22-6739N9952DLynch John E · Bourbonnais, ILBuilt 1959 · S/N 22-6740N9953DNiner Niner Five Three Delta LLC · Marshall, WIS/N 22-6742N9954DJoy Derek T · Bad Axe, MIBuilt 1959 · S/N 22-6743N9957DLinett Michael J · Elsmere, DEBuilt 1959 · S/N 22-6746N9957PPennsylvania College Of Technology · Williamsport, PABuilt 1975 · S/N 36-7560068N9958DMoore William H · Johnstown, COBuilt 1959 · S/N 22-6748N9959DJohnson Steven Donald · Pardeeville, WIBuilt 1959 · S/N 22-6749N9963DBurlak David M · Waverly, VABuilt 1959 · S/N 22-6754N9964PCabbage Kenneth S · Prosser, WABuilt 1975 · S/N 36-7560075N9966DZiemann Shaun · Jasper, INBuilt 1959 · S/N 22-6757N9966PGrubbs Terry L DBA · Gregory, SDBuilt 1975 · S/N 36-7560077N9971DAhern Daniel Patrick · Oxford, NCS/N 22-6762N9973DRoadarmel Brandon L · Three Forks, MTS/N 22-6764N9974FShipp G Carl Md · Little Rock, ARS/N 27-4835N9976DHamon Troy R · King Salmon, AKBuilt 1959 · S/N 22-6767N9976PSides Aviation LLC · Cambridge, NEBuilt 1975 · S/N 36-7560089N9977DMesserla David M · Manhattan, KSBuilt 1959 · S/N 22-6768N9979PFederal Aerial Applicators LLC · Wilmington, DEBuilt 1975 · S/N 36-7560092N997UPPotti Noah · Kalispell, MTBuilt 1950 · S/N 20-246N9981PButler Billy D · Hilger, MTBuilt 1975 · S/N 36-7560095N9985DTrimmer Marvin E · Willow, AKBuilt 1959 · S/N 22-6777N9986DWalsh Arthur B · Lincoln, NERegistration revokedBuilt 1959 · S/N 226778N998FBRegistered aircraftN-number assigned, not yet registeredS/N 27-440N9991DNothum Robert G · Dixon, MOBuilt 1959 · S/N 22-6783N9993DMunson Matthew C · Canby, ORBuilt 1959 · S/N 22-6786N9994DKnudsen Ernest W Jr · Ennis, TXBuilt 1959 · S/N 22-6787N9996PMid Continent Aircraft Corp · Hayti, MOS/N 36-7560097N9998DHarkins Cody · Grover, WYS/N 22-6791N9999ALake Mark S · Erie, COBuilt 1955 · S/N 22-2842N9999DAnderson Corlin L · North Branch, MNBuilt 1959 · S/N 22-6792N9999WScudder Adam · Orlando, FLBuilt 1976 · S/N 27-7654086N999FLMatthews Aviation LLC · Hardinsburg, KYBuilt 1957 · S/N 23-1115N999HKGeboy Alan R II · Newnan, GABuilt 1952 · S/N 22-574N999LAAero Equities LLC · Ventura, CABuilt 1978 · S/N 44-7995034
Back to AD 85-02-05 R1