Registered aircraft · 54,017

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:87-20-03-R2') 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-20-03-R2') 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:87-20-03-R2')
    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-20-03-R2')
  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:87-20-03-R2')
  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-20-03-R2')
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.

N3300AAdams Air & Sea Inc · Wilmington, DEBuilt 1969 · S/N 337-1094 N3300JIngram Jay Wallis · El Paso, TXBuilt 1966 · S/N 15066000 N3300YRaulston Electric LLC · Bagwell, TXBuilt 1962 · S/N 18254300 N3301DJohnson Peter L · Chico, CAS/N 32099 N3301RJuliet Zulu Holdings LLC · Dover, DEBuilt 1967 · S/N 18258601 N3301VErhard Robert T · Granville, OHBuilt 1974 · S/N 15076453 N3302JWignot Andrew R · Oceanside, CABuilt 1966 · S/N 15066002 N3302YFoster James R · Mcpherson, KSBuilt 1962 · S/N 18254302 N3303JWilliams Charles S · Pearland, TXBuilt 1967 · S/N 15066003 N3303YWoolery David W Jr DBA · Lathrop, MOBuilt 1962 · S/N 18254303 N3304FStephan Pamela K · Anchorage, AKBuilt 1966 · S/N 18257304 N3305RLivingston Sonja L · Redding, CABuilt 1967 · S/N 18258605 N3305YWolfe Randall S · Wasilla, AKBuilt 1962 · S/N 18254305 N3306CSkylane Inc · Schaumburg, ILBuilt 1978 · S/N R18200269 N3306DAlquist Kevin B · Edwardsville, KSBuilt 1955 · S/N 32104 N3306EBlackwell Calvin C · Fort Worth, TXBuilt 1978 · S/N 17271498 N3306JRound Engine Aero · Nashville, MIBuilt 1966 · S/N 15066006 N3306UMartin Paul R Jr · Greensboro, GABuilt 1963 · S/N 18254706 N3306YSaunders Craig · Spring Hill, FLBuilt 1962 · S/N 18254306 N3307RPhan Tam M · Charlotte, NCBuilt 1967 · S/N 18258607 N3307UPatronyk Gregory M · Santa Barbara, CABuilt 1963 · S/N 18254707 N3308FBravo Hotel LLC · Lewes, DES/N 18257308 N3308RLocatelli Gabriel G · North Bend, ORBuilt 1967 · S/N 18258608 N3308SSutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 18502267 N3309CScott Parker H · Bulverde, TXBuilt 1978 · S/N R18200270 N3309JMomentum Foundation · Tullahoma, TNS/N 15066009 N3309SCessna 210 N3309s LLC · Yellville, ARBuilt 1969 · S/N 21059109 N3309YRuschak Donald A · Charleroi, PABuilt 1962 · S/N 18254309 N330BDD & J Holdings LLC · Ellis, IDBuilt 1973 · S/N 18261634 N330CTRobinson Paul J · Saint Joseph, MOBuilt 1974 · S/N 17702158 N330FSkydive Wayland LLC · Melbourne, FLBuilt 1957 · S/N 34329 N330GBBrenner Gary L · Mission Viejo, CABuilt 1975 · S/N 18264242 N330LCDe Witt Luba Owner Trustee · Fort Lauderdale, FLBuilt 1980 · S/N P3370352 N3310RSeitz Martin V · Brookfield, WIBuilt 1967 · S/N 18258610 N3310TFly448 LLC · Wausau, WIBuilt 1968 · S/N 17700045 N3310YRegistration Pending · Fayetteville, ARRegistration pendingS/N 18254310 N3311DPendergrass Joseph M · Wasilla, AKBuilt 1955 · S/N 32109 N3311RView From Above Inc · Columbia, CABuilt 1967 · S/N 18258611 N3311SExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1969 · S/N 21059111 N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611 N3311UBeck Gary · Albuquerque, NMBuilt 1963 · S/N 18254711 N3311YChavez Rafael J · Santa Fe, NMBuilt 1962 · S/N 18254311 N3312FWill Robert J · Fall City, WABuilt 1966 · S/N 18257312 N3312JAlternate Air Inc · Seattle, WABuilt 1966 · S/N 15066012 N3312RParish Mark · Earth, TXBuilt 1967 · S/N 18258612 N3312SBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059112 N3312URoberts Air Inc · Goodwin, ARBuilt 1963 · S/N 18254712 N3313JEsckelson Eric S · Cass City, MIS/N 15066013 N3313ULayton Robert H · Seminole, TXBuilt 1963 · S/N 18254713 N3313VAviation Enterprises Inc · Springfield, MOBuilt 1974 · S/N 15076457

Back to AD 87-20-03 R2