OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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.

N6019DKuper Carl J II · Dalhart, TXBuilt 1956 · S/N 22-4672N6019PN6019p LLC · Washington, DCBuilt 1959 · S/N 24-1114N601ALValley Group Inc · Fishersville, VABuilt 1969 · S/N 61-0036-73N601BBKing Aviation Services LLC · Marietta, OHBuilt 1977 · S/N 61P-0431-159N601BSThird Coast Aircraft LLC · Mobile, ALBuilt 1970 · S/N 28R-35798N601DJMullen James J · Estero, FLBuilt 1980 · S/N 61P07798063392N601DQSilver Eagles Aviation Association · Mesa, AZS/N 60334N601EAExecutive Air Transport Inc · Norton Shores, MIBuilt 1978 · S/N 28-7916124N601EMValestin Donald P · Queen Creek, AZBuilt 1977 · S/N 61P-0389-131N601FTSanson Paul H · Deland, FLBuilt 1989 · S/N 2841195N601GZDependable Drain Cleaning And Plumbing Repairs LLC · Lake Charles, LABuilt 1976 · S/N 61P-0371-119N601HBPatrick Ronald A · Louisville, KYBuilt 1979 · S/N 61P06467963298N601HCJohnson Timothy R · Owatonna, MNS/N 006N601LANicely Juan · Mount Vernon, KYS/N 1473N601MAlvis Michael Ernie DBA · Sparta, TNBuilt 1975 · S/N 61P-0253-046N601NGBullard Aviation Services Inc · Ormond Beach, FLBuilt 1980 · S/N 61P07908063402N601NNJones Flying LLC · Helena, MTBuilt 1975 · S/N 61P-0242-039N601NTRegistration Pending · Winter Park, FLRegistration pendingBuilt 1980 · S/N 61P07668063381N601PSchmidt Richard E · Fort Myers, FLBuilt 1979 · S/N 61P06587963306N601PAMendenhall Michael L · Douglasville, GABuilt 1977 · S/N 17269030N601PEVcs Transportation LLC · Hampton, VABuilt 1977 · S/N 61P-0421-153N601PSCastle Rock Services LLC · Helena, MTBuilt 1999 · S/N 60001N601PTWf Aviation LLC · Bozeman, MTBuilt 1980 · S/N 61P07988063409N601PZSkyking Aviation Services LLC · Carson City, NVBuilt 1980 · S/N 61P08288163436N601RBBandy Robert W · Ridgecrest, CABuilt 1969 · S/N 61-0040-77N601RDPichon Dean M · Essex, VTBuilt 2001 · S/N 2981N601RKNorthampton Aeronautics Inc · Northampton, MABuilt 1978 · S/N ME-71N601RVFly Right LLC · Reno, NVBuilt 2003 · S/N 60325N601SHJohnson Martin L · Henderson, NVBuilt 1970 · S/N 61-0067-124N601TGKenmore Crew Leasing Inc · Bellingham, WAS/N 28R-7235214N601TTAgee John M Trustee · Sunriver, ORBuilt 1991 · S/N 786N601TVOrlando Aircraft Sales LLC · Orlando, FLBuilt 2000 · S/N 0836N601VSJireh Wings LLC · Las Vegas, NVS/N 2036LN601XSmc Developers Inc · San Jose, CABuilt 1977 · S/N 61-0393-117N6020DDufreche David S · Sanger, TXBuilt 1956 · S/N 22-4673N6020KDuont LLC · Portola Valley, CABuilt 2004 · S/N T18208236N6020LJenkins David B · Hemet, CABuilt 1972 · S/N AA5-0120N6020PClark Katherine A · Spring, TXBuilt 1979 · S/N MC-653N6020QN6020q LLC · Jensen Beach, FLBuilt 1965 · S/N 3231N6020WBritton Jeffrey A · Accident, MDBuilt 1964 · S/N 28-20020N6021QR&L Aviation Inc · Philadelphia, PAS/N 3232N6021WA&C Aviation LLC · Lawrenceville, GABuilt 1964 · S/N 28-20021N6021ZAerial Banners Inc · Pembroke Pines, FLS/N 25-25N6022LIrving Donald J · Deland, FLBuilt 1975 · S/N 0712N6022PRegistered aircraftBuilt 1959 · S/N 24-1117N6022SAhlberg Merick D · Eagle River, AKBuilt 1979 · S/N M-2156N6022WDelgado Mario J · Baldwin Park, CAS/N M-2153N6023AKirkendall Shane O · Cedar Park, TXBuilt 1993 · S/N 14604N6023DBusta Daniel N · Los Angeles, CABuilt 1956 · S/N 22-4676N6023XSytsma Douglas A · Canton, MIBuilt 1960 · S/N 1611
Back to AD 87-10-06 R1