Registered aircraft · 1,982

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

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-10-02') 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-10-02') ORDER BY n_number

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-10-02')
    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-10-02')
  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.

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-10-02')
  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-10-02')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N10007Insko Matthew T · Papillion, NEBuilt 1966 · S/N 21058839 N100DZSkydive Santa Barbara LLC · Lompoc, CABuilt 1966 · S/N U206-0693 N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N101JHHi-Per Aviation Inc · Arroyo Grande, CABuilt 1972 · S/N 21059759 N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404 N10242Alexander Holding Services Inc · Newark, DEBuilt 1972 · S/N 21059704 N102BNDelta State University · Cleveland, MSBuilt 1978 · S/N U20604268 N104KJb Aircraft LLC · Anchorage, AKBuilt 1969 · S/N 20700122 N1051VSackett Ryan W · Anchorage, AKBuilt 1974 · S/N U20602421 N1061PRemote Properties LLC · Anchorage, AKBuilt 1983 · S/N U20606773 N1067MShore Enterprises Of Gainesville LLC · Gainesville, FLBuilt 1970 · S/N 21059367 N107JPPayne Thomas E · Old Forge, NYBuilt 1973 · S/N U20602079 N109RCLentfer Clinton H A · Anchorage, AKBuilt 1974 · S/N U20602616 N109SWChugiak Aviation Leasing LLC · Chugiak, AKBuilt 1977 · S/N U20603799 N10CCSmith Kord S · Salmon, IDBuilt 1964 · S/N 206-0166 N10DBBrandon Donald A Trustee · El Monte, CABuilt 1977 · S/N 21062016 N10HGGerardy Harlan D · Gruver, TXBuilt 1974 · S/N 21060169 N10HLHoyt Robert H Trustee · Canby, ORBuilt 1975 · S/N 21060646 N10RVKoehn Shane Michael · Scooba, MSBuilt 1964 · S/N 21058418 N10YSeitz William D · Gordonville, TXBuilt 1972 · S/N 21059697 N110BDArgus Craig J · Atlantic City, NJBuilt 1981 · S/N 21064427 N110NJState Of New Jersey · Trenton, NJBuilt 1986 · S/N U20606938 N110YDLloyd Clee · Canby, ORBuilt 1975 · S/N 21060858 N1110SMob Aviation USA LLC · Kissimmee, FLS/N 21061119 N111NJNew Jersey Forest Fire Service · Trenton, NJBuilt 1964 · S/N U206-0278 N1120VKodiak Marine Construction · Oakley, IDBuilt 1976 · S/N U20603130 N1137MN1137m LLC · Bentonville, ARBuilt 1977 · S/N 21061921 N113AGOrban Cedric · Coral Springs, FLBuilt 1977 · S/N U20603750 N114AGRlc Aviation LLC · Ansted, WVBuilt 1979 · S/N U20604674 N1157QRrc Inc · Madison, MSBuilt 1975 · S/N U20602848 N1157WAdams Chad D · Dayton, ORBuilt 1970 · S/N U20601578 N1158ZMoffitt Carl A · Orange, CAS/N U20606634 N115CWWhitlock Gary D · Melbourne, FLBuilt 1974 · S/N 21060520 N1190QBritell Andrew Paul · Sandwich, NHBuilt 1972 · S/N 21059690 N1191VWilmarth Rebecca C · Red Devil, AKBuilt 1974 · S/N U20602506 N119MSAeronorth LLC · Ann Arbor, MIBuilt 1969 · S/N 21059121 N11LATwo-Ten LLC · Ramona, CABuilt 1968 · S/N 21059058 N120JHC&C Cessna LLC · Baltimore, MDBuilt 1977 · S/N U20603636 N121CEAdvanced Flight Instruction LLC · Greenwood, DEBuilt 1974 · S/N 21060503 N121LLWild Blue Air LLC · Homer, AKBuilt 1977 · S/N U20603756 N1220GGastrock Robert C Trustee · Anchorage, AKBuilt 1973 · S/N U20602232 N122FSiver Creek Capital LLC · Emery, SDS/N 21058967 N123CEBas Part Sales LLC · Greeley, COS/N 21061054 N123TMJaars Inc · Waxhaw, NCS/N U20601768 N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004 N124WNTemple Steve D · Superior, MTBuilt 1972 · S/N U206-01832 N1255VHanson Lanny Lane · Polson, MTBuilt 1974 · S/N U20602540 N125CFInternational Air Services Inc Trustee · Carson City, NVS/N 21064253 N126LSMerritt Aaron S · Manhattan, MTS/N 21062038 N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991

Back to AD 85-10-02