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.

N337VRed Devil Skymasters LLC · Helena, MTBuilt 1971 · S/N 33701369 N337VGBvj Skymaster Inc · Appleton, MNS/N 337-0435 N337WAGyron Eagle Ltd · Pasadena, CABuilt 1975 · S/N 33701651 N337WGGrady Charles Martin · La Verne, CABuilt 1965 · S/N 337-0091 N337WTSunset Aviation LLC · Wilmington, DEBuilt 1967 · S/N 337-0661 N337WWTobias John M · Sedona, AZBuilt 1973 · S/N P3370106 N337WZAir Data Solutions LLC · Natchitoches, LABuilt 1971 · S/N 33701397 N337XCHoover Rodney A · Wasilla, AKBuilt 1966 · S/N 15062891 N337XXPfister David E · Harlan, INS/N 337-0726 N337YBrokaw Burton · Tucson, AZBuilt 1966 · S/N 337-0449 N3380DRussell Robert J · Wasilla, AKBuilt 1956 · S/N 32178 N3380JEsparza Edel · Chula Vista, CABuilt 1967 · S/N 15066080 N3380RHunter Robert R · Springville, PABuilt 1967 · S/N 18258680 N3380YLaramie Flying Club Inc · Laramie, WYBuilt 1962 · S/N 18254380 N3381FAttema Symon Nmi · Norco, CABuilt 1966 · S/N 18257381 N3381UCenter Of Excellence Corp · Cheyenne, WYBuilt 1963 · S/N 18254781 N3382DBond Jeffrey A · Las Cruces, NMBuilt 1955 · S/N 32180 N3382RWatch Out LLC · Scottsdale, AZBuilt 1967 · S/N 18258682 N3382SNorthern Sonic Alaska Inc · Fairbanks, AKBuilt 1973 · S/N 18502288 N3382YJenkinson John III · Lakin, KSBuilt 1962 · S/N 18254382 N3383DStyer Michael J · Amarillo, TXBuilt 1955 · S/N 32181 N3383RDeatley Derek · Mohave Valley, AZBuilt 1967 · S/N 18258683 N3383SStewart Bryan · Carson City, NVBuilt 1969 · S/N 21059183 N3383TBerkstresser John A · Ellijay, GABuilt 1967 · S/N 17700683 N3383YJohnson Brian B · Monroe, LABuilt 1962 · S/N 18254383 N3384R3384 Romeo LLC · Jackson, MOBuilt 1967 · S/N 18258684 N3384VNewby Aviation LLC · Pingree Grove, ILS/N 15076484 N3384YOliveira John S · Plant City, FLBuilt 1962 · S/N 18254384 N3385JGonzales Mark S · Dothan, ALS/N 15066085 N3385LTonka Seaplanes LLC · Minnetonka, MNS/N 185-1337 N3385RHill David A Jr · Needham, MABuilt 1967 · S/N 18258685 N3385YNoah Aviation LLC · Ellabelle, GABuilt 1962 · S/N 18254385 N3386ED Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 17271526 N3386FN3386f Flying Club Inc · Pickerington, OHBuilt 1966 · S/N 18257386 N3386VFrg III Inc DBA · Lincoln Park, NJBuilt 1974 · S/N 15076486 N3387FChristensen Robert F · Gillette, WYBuilt 1966 · S/N 18257387 N3387JMy Piper Pacer LLC · Everett, WAS/N 15066087 N3387RSkypartners LLC · Buhler, KSBuilt 1967 · S/N 18258687 N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687 N3387USkynick Enterprises Inc · Tarzana, CAS/N 18254787 N3387YBhogal Balvinder S · Biloxi, MSBuilt 1962 · S/N 18254387 N3388RFamily Air Fares LLC · Wilmington, DEBuilt 1967 · S/N 18258688 N3388SShaffer Barbara J · Franklin, KYBuilt 1969 · S/N 21059188 N3388TKing Eric J · Zillah, WABuilt 1967 · S/N 17700688 N3388UMenard Charles H · Grand Blanc, MIBuilt 1963 · S/N 18254788 N3388YMeeks Peris M · Gardena, CAS/N 18254388 N3389DRegistered aircraftBuilt 1955 · S/N 32187 N3389EBarnfather James D · Sequim, WABuilt 1978 · S/N 17271528 N3389UThompson Anthony D Trustee · Rockwall, TXS/N 18254789 N338BMMorton William · Darby, MTBuilt 1979 · S/N 18267111

Back to AD 87-20-03 R2