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.

N8863CClearsky II LLC · Tyler Hill, PABuilt 1953 · S/N 22-1494N8863DSanders Darrel T · Camp Douglas, WIBuilt 1958 · S/N 22-6037N8864DMarsteller Paul A · Tallulah Falls, GABuilt 1958 · S/N 22-6038N8864YMiller Donald W · Harrisonburg, VABuilt 1970 · S/N 39-19N8865CMayo Jesse J · Fairbanks, AKS/N 20-1034N8865PBrown Travis E · Leicester, NCBuilt 1965 · S/N 24-4322N8866CEckels Shaun R · Pickerington, OHBuilt 1953 · S/N 20-1031N8866PSale Reported · Caseville, MISale reportedBuilt 1965 · S/N 24-4323N8867YPiper Thirty Nine LLC · Glasgow, MTBuilt 1970 · S/N 39-22N8868EArizona Soaring Inc · Maricopa, AZBuilt 2022 · S/N LA-260-21063N8868PBurrough Haus Properties LLC · San Marcos, TXBuilt 1965 · S/N 24-4325N8869YCome Fly Away LLC · Waterloo, ILBuilt 1970 · S/N 39-24N886ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496323N886FTChristiansen Aviation LLC · Wilmington, DES/N 4496349N886RASmith Daryl N · Coventry, CTBuilt 1959 · S/N 22-6944N8870CRegistration Pending · Canal Fulton, OHRegistration pendingBuilt 1953 · S/N 22-1479N8870DHaumschild Edward E · Marana, AZBuilt 1958 · S/N 22-6044N8871CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1953 · S/N 22-1484N8871DSmith James A · Lyle, WABuilt 1958 · S/N 22-6045N8871PMq Flights LLC · Missoula, MTBuilt 1965 · S/N 24-4328N8872CGibbs John D · Victoria, TXBuilt 1953 · S/N 20-1024N8872DJohnson Robert M · Ada, MNBuilt 1958 · S/N 22-6046N8872PBlackburn Robert F · Georgetown, TXBuilt 1965 · S/N 24-4329N8873CGibbs John D · Victoria, TXBuilt 1953 · S/N 20-1023N8873DWroe Daniel C · Denton, MDBuilt 1958 · S/N 22-6047N8873PTailwind Auditing Group LLC · Godley, TXBuilt 1965 · S/N 24-4330N8874PWiebe Aron · Seminole, TXS/N 24-4331N8875DBishop Bill I · Cross Plains, TXBuilt 1958 · S/N 22-6049N8876PWentworth Douglas G · Simpsonville, KYS/N 244333N8876YComanche 76y LLC · Waynesboro, VAS/N 39-32N8877CBall Fred · College Place, WABuilt 1953 · S/N 20-1025N8877DSale Reported · Crystal, MNSale reportedBuilt 1958 · S/N 22-6051N8877YVanhook Orville Richard · Somerset, KYBuilt 1970 · S/N 39-34N8878CJones Brian K · Scituate, MABuilt 1953 · S/N 22-1488N8878DHamilton Clyde Leon · Forest, VABuilt 1958 · S/N 22-6052N8878PHudson Albert Denning · Cornelius, NCBuilt 1965 · S/N 24-4337N8879CMadden John J Jr Co-Trustee · Frostproof, FLBuilt 1953 · S/N 22-1489N887PMHarris William M · Radford, VABuilt 1970 · S/N 39-25N887WCGalindo Don R Jr · Walnut Grove, CABuilt 1952 · S/N 22-887N8880YPlane Fun Inc Tr Trustee · Snellville, GABuilt 1970 · S/N 39-38N8881CMcintosh Ronald J · Walker, WVBuilt 1953 · S/N 22-1462N8881PIce Randall R · Pierre, SDBuilt 1965 · S/N 24-4340N8883CBall Travis W · Aleknagik, AKBuilt 1953 · S/N 22-1465N8883PFlynn James Jay · Seneca, SCBuilt 1965 · S/N 24-4342N8883YYank N Bank LLC · Greeley, COBuilt 1970 · S/N 39-41N8884CHartman Linda C · Malin, ORBuilt 1953 · S/N 22-1468N8884YFlight Logistics LLC · Westerville, OHS/N 39-46N8885HHoughton Patrick K · Villa Rica, GABuilt 1961 · S/N 24-2577N8885YWilson Cecil · Lithonia, GABuilt 1970 · S/N 39-43N8887CHorinek Troy C · Goodland, KSS/N 22-1470
Back to AD 85-02-05 R1