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.

N8804XDixon Peter J · Carlton, WABuilt 1961 · S/N 18253204N8804ZPoorboy Flying Club LLC · Erick, OKFirst renewal noticeBuilt 1966 · S/N 17255454N8805GMazor Chris · Van Buren Twp, MIS/N 15062905N8805SBatt Timothy D · Mc Grath, AKBuilt 1965 · S/N 15062105N8805TMoore Chase M · Billings, MTBuilt 1960 · S/N 52705N8806ZFrancechi Marc Anthony · Phoenix, AZBuilt 1966 · S/N 17255456N8807BLee Kendall Nathan · Madras, ORS/N 36507N8807GHague Ryder S · Bradfordsville, KYS/N 15062907N8807UHarkins Robert W · Arnold, CAS/N 15078002N8808SReber Scott D · Newcastle, UTBuilt 1965 · S/N 15062108N8808TGreissing John P · Aguila, AZBuilt 1960 · S/N 52708N8808UValiair Limited Company Trustee · Casper, WYS/N 17252715N8809BEagles Wings Inc · San Angelo, TXBuilt 1957 · S/N 36509N8809SJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1965 · S/N 15062109N8809XParker James G Jr · Bellevue, NEBuilt 1961 · S/N 18253209N880CBJ-Airco LLC · Nashville, TNBuilt 1973 · S/N 17262582N880CKOlson Craig J · Bettendorf, IABuilt 1959 · S/N 50555N880LSYoshitomi Chad M · Anchorage, AKBuilt 1976 · S/N 18265073N880MTKibler John · Kalispell, MTBuilt 1952 · S/N 20805N880PMTimeless Flight LLC · Spanaway, WABuilt 1966 · S/N 15065825N880THAviation Peter Corp Of New York · New York, NYBuilt 1980 · S/N 172RG0522N8810GSobers Dolton D A Jr · Caguas, PRBuilt 1966 · S/N 15062910N8810UWebesharing LLC · Orange Beach, ALBuilt 1965 · S/N 17252717N8810XLaughlin Robert L · Santa Ynez, CAS/N 18253210N8811BMatty Elizabeth · Tucson, AZBuilt 1957 · S/N 36511N8811UAlder William D III · Athens, OHBuilt 1965 · S/N 17252718N8811XSchwarzmann Bryce A · Falls Church, VABuilt 1961 · S/N 18253211N8812Zzz Aviation LLC · Newberg, ORBuilt 1976 · S/N 18503217N8812SAnderson Benjamin J · Mondovi, WIBuilt 1965 · S/N 15062112N8812XOconnor Brian Edmond · Portland, ORS/N 18253212N8813TBruno Samuel P · Missoula, MTBuilt 1960 · S/N 52713N8813UAerios Air LLC · Midland, TXBuilt 1965 · S/N 17252720N8813XMeccanized LLC · Kalispell, MTBuilt 1960 · S/N 18253213N8813ZDuman Adrianna A · Los Angeles, CABuilt 1966 · S/N 17255463N8814BEvans Roy L · Winnemucca, NVBuilt 1957 · S/N 36514N8814TSchildberg Gregory M · Casey, IABuilt 1960 · S/N 52714N8814XCloudstreet Flying Services · Broomfield, COBuilt 1961 · S/N 18253214N8815BWiser Kurtis · Kennewick, WAS/N 36515N8815TWills Casey B · Gulf Shores, ALS/N 52715N8815ZAerowood Aviation LLC · Monroe, NCBuilt 1966 · S/N 17255465N8816UHocus Holdings LLC · Carrollton, OHBuilt 1965 · S/N 17252723N8817SRomeo Tango Aircraft Holding LLC · Merritt Island, FLBuilt 1965 · S/N 15062117N8817TTop Hand Inc · Laurel, MTBuilt 1960 · S/N 52717N8817ZRegistration Pending · Redmond, WARegistration pendingS/N 17255467N8818BFairfield Eugene D · Wiscasset, MEBuilt 1957 · S/N 36518N8818TEngel Samina · San Diego, CABuilt 1964 · S/N 17251521N8818UUfford Christian T · Vershire, VTBuilt 1965 · S/N 17252725N8819GGipson Aviation LLC · Winchester, TNBuilt 1966 · S/N 15062919N8819SSmith Cory M · Naples, FLBuilt 1965 · S/N 15062119N8819UBoss Gary W · Bronston, KYBuilt 1965 · S/N 17252726
Back to AD 87-20-03 R2