OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,015

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-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.

N8523UEllis Clifford E · Emmitsburg, MDFirst renewal noticeS/N 17252423N8524BBecker Robert A · Santa Rosa, CABuilt 1957 · S/N 36224N8524SLoyer Victor D · Palmer, AKBuilt 1965 · S/N 18256624N8524TMurlin David · Hemet, CABuilt 1959 · S/N 52424N8524ULewis Steven · Anchorage, AKBuilt 1964 · S/N 17252424N8524XPedroza Everett W · Tehachapi, CABuilt 1962 · S/N P17257124N8525JBicknell Hilary E · Warwick, RIS/N 15066425N8525TSmith Randall M · Escondido, CABuilt 1959 · S/N 52425N8525XBradford John R · Sheridan, ARBuilt 1962 · S/N P17257125N8526BMallory John C · Fairbanks, AKBuilt 1957 · S/N 36226N8526GLong Sean · Germantown, TNBuilt 1966 · S/N 15062626N8526QKenworthy Winston C · Odessa, TXBuilt 1976 · S/N U20603382N8526TJoachim Barry L · Lubbock, TXBuilt 1960 · S/N 52426N8527BWeber Randy J · Homer, AKS/N 36227N8527GAcosta Alfredo · Yuma, AZBuilt 1965 · S/N 15062627N8527XMicheliche Robert · Federalsburg, MDS/N P17257127N8528BReiber Robert F · Riverside, CABuilt 1957 · S/N 36228N8528GTulsa Technology Center School Dist No 18 · Tulsa, OKBuilt 1965 · S/N 15062628N8528SLucas Robert I · Jackson, WYS/N 18256628N8528TLonni Rasmussen · Lehi, UTBuilt 1959 · S/N 52428N8528UKanning Brandon A · Graham, WABuilt 1976 · S/N 15077943N8528XWilson Andrew · Sault Sainte Marie, MIBuilt 1962 · S/N P17257128N8529BBlakely Jerry C · Winona, MSBuilt 1957 · S/N 36229N8529JBrucks Mark D · Peachtree City, GABuilt 1967 · S/N 15066429N8529SWollan David · Shelby, MTBuilt 1965 · S/N 18256629N8529XWheeler Kevin M Trustee · Comstock Park, MIBuilt 1962 · S/N P17257129N852DAHendrix Rex · Pell City, ALBuilt 1975 · S/N 17264427N852SDauenhauer Manufacturing Inc · Ketchum, IDBuilt 1978 · S/N P21000081N8530TZakis Stephen · Hillsdale, WYBuilt 1959 · S/N 52430N8531JCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 15066431N8531THarms Reuben S · Jackson, GABuilt 1959 · S/N 52431N8532JWerner Felix A · Picayune, MSBuilt 1967 · S/N 15066432N8532UMethe James L · Omaha, NEBuilt 1964 · S/N 17252432N8533BBungert Heidi J · Inver Grove, MNBuilt 1957 · S/N 36233N8533TAirmotive Service LLC · Brigham City, UTBuilt 1960 · S/N 52433N8533USustarich Stephen M · Ketchikan, AKBuilt 1964 · S/N 17252433N8533XApex Aviation LLC · Highlands Ranch, COBuilt 1962 · S/N P17257133N8534GBennett Julie L · Titusville, FLBuilt 1965 · S/N 15062634N8534SBorreson Anthony · Mariposa, CABuilt 1965 · S/N 18256634N8534TCoonrods Garage LLC · Dodd City, TXBuilt 1959 · S/N 52434N8534ULusson Adam R · Cameron, WIBuilt 1964 · S/N 17252434N8534XGingrich Garrick Ray · Las Vegas, NVBuilt 1962 · S/N 17257134N8535GSpeedbird Aviation One LLC · Glenn Heights, TXBuilt 1965 · S/N 15062635N8535UGibbons Patrick C · Sunrise Beach, TXBuilt 1964 · S/N 17252435N8536GMarcu David · Killen, ALS/N 15062636N8536KRegistered aircraftBuilt 1969 · S/N 18501573N8536SClear Skies Aviation LLC · Reserve, MTBuilt 1965 · S/N 18256636N8536TLalonde Terrence E Trustee · Gardnerville, NVS/N 18501784N8536UIndigo Of South Fl Inc · Sunrise, FLBuilt 1976 · S/N 15077944N8537GNugent David R · Jensen Beach, FLBuilt 1965 · S/N 15062637
Back to AD 87-20-03 R2