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.

N7571YPipers Are Still Better LLC · Carson City, NVBuilt 1964 · S/N 30-636N7572YBlack And Faraday Inc · Pencil Bluff, ARS/N 30-637N7573YLawrence Earl A · Alexandria, VABuilt 1964 · S/N 30-638N7574YWdc Aviation LLC · Williamsburg, VABuilt 1964 · S/N 30-640N7575PSharp Charles Barry · Fulton, KYBuilt 1961 · S/N 24-2785N7576PN7576p LLC · Sequim, WAS/N 24-2787N7576YJ & P Toys Inc · Fort Myers, FLBuilt 1968 · S/N 27-4076N7577PMeyer Peter L · Huntsville, ALBuilt 1961 · S/N 24-2788N7577YN1245d LLC · Wilmington, DEBuilt 1964 · S/N 30-643N7578ZSilent Flight LLC · Payette, IDBuilt 1965 · S/N 25-3651N7579ZRotor And Wing · Tioga, NDBuilt 1965 · S/N 25-3653N757PKoerner Lukes Gene · Wisconsin Rapids, WIBuilt 1967 · S/N 24-4604N7580PWiseman Charles D · Orlando, FLS/N 24-2791N7583YMege Ronald W · Port Jervis, NYS/N 30-649N7585PComanche Flyers Inc · East Palestine, OHBuilt 1961 · S/N 24-2796N75884A-Z Aviation LLC · Bay City, MIBuilt 1956 · S/N 20-811N7588YK&Cs Saveacomanche LLC · Spring Lake Park, MNBuilt 1964 · S/N 30-655N7592PStrobach Kristin K · Rib Lake, WIS/N 24-2803N7592ZBrain Paul W · Webster City, IABuilt 1965 · S/N 25-3677N7593PWaitkus James M · Oak Park, CABuilt 1961 · S/N 24-2804N7593YEpic Aviation Leasing LLC · Puyallup, WABuilt 1965 · S/N 30-662N7596YRodgers Kevin M · Vacaville, CAS/N 30-665N7597PSpinks Matthew Robert · Clarkesville, GAS/N 24-2808N7598PBurton Channing L · League City, TXBuilt 1961 · S/N 24-2809N75HDMorton Michael E · Hickory, NCS/N 30-757N75MPAniol Ashley · Glendale, AZS/N 22-8702N7600DMangos Charles A · Rochester, NYBuilt 1957 · S/N 22-5301N7600YSchell Joseph H · Granbury, TXBuilt 1964 · S/N 30-669N7601YMines Keith A · White Cloud, MIBuilt 1964 · S/N 30-671N7602PBischoff Brent J · Bandon, ORBuilt 1961 · S/N 24-2813N7604YHennum Gretchen I · Eagle, COBuilt 1965 · S/N 30-675N7605PKienle Richard L · Weatherford, TXBuilt 1968 · S/N 24-2816N7605YPlane Care LLC · Tucson, AZBuilt 1964 · S/N 30-676N7606KAmmons Curtis D · Hernando, MSBuilt 1950 · S/N 20-421N7608YJohnson Craig · Moreland, GAS/N 30-679N7609DBraden James L · Hillsboro, KSBuilt 1957 · S/N 22-5311N7609KShrode Rafe C · Jewett, TXS/N 20-512N7609YDowning Gregg R · Guymon, OKBuilt 1964 · S/N 30-680N7610DBug Smashers LLC · Winfield, KSS/N 22-5312N7610PMorris Scott R · Steilacoom, WABuilt 1961 · S/N 24-2821N7611DLazare Luke B · Merrill, WIS/N 22-5313N7611PChamberlain Paul E · Troup, TXBuilt 1961 · S/N 24-2822N7611YRandall Dean A · Reno, NVS/N 30-683N7611ZKnutson Wayne R · Tioga, NDBuilt 1965 · S/N 25-3716N7613DHendrickson Aaron C · Mazomanie, WIBuilt 1957 · S/N 22-5317N7613KSchramm Harold G · Utica, SDBuilt 1950 · S/N 20-429N7613PSimpson Randolph L · Shelburne Falls, MABuilt 1961 · S/N 24-2824N7614DBig Bend Community College Foundation · Moses Lake, WABuilt 1957 · S/N 22-5318N7614KGoering Rodney · Hutchinson, KSBuilt 1950 · S/N 20-430N7614YSky Walker Flight School LLC · Adrian, MIBuilt 1964 · S/N 30-687
Back to AD 85-02-05 R1