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.

N92753Mccollum J R · Mount Pleasant, TXBuilt 1973 · S/N 17261614N92757Omegna Suzanne M · Spanaway, WABuilt 1970 · S/N 18260342N92758Wayne Alan A · Flowery Branch, GABuilt 1970 · S/N 18260343N92764Bernstein Jeffrey J · Swanton, MDBuilt 1970 · S/N 18260345N9276ABrandon Airways LLC · Bakersfield, CABuilt 1949 · S/N 19037N9276BKinberger Chris E · Louisville, KYBuilt 1958 · S/N 55076N9277Lynn William S · Jackson, MSBuilt 1953 · S/N 25964N92776Rivera Rivera Jose Manuel Trustee · Royal Palm Beach, FLBuilt 1970 · S/N 18260349N92777Macatawa Flyers Inc · Allegan, MIBuilt 1973 · S/N 17261616N9277ATibor W Farkas · Georgetown, TXBuilt 1949 · S/N 19038N9277CIrwin Phillip R · Parker, COBuilt 1955 · S/N 31376N9277HChorman Spraying LLC · Milton, DEBuilt 1975 · S/N 17266065N9277UPeters Airway LLC · Pratt, KSBuilt 1976 · S/N 15078227N92787Quade James C · Duluth, MNBuilt 1970 · S/N 18260356N92788Bas Part Sales LLC · Greeley, COS/N 18260357N92789N5746u LLC · Dover, DES/N 17261619N9278AHanna Mark W II · Pendleton, INBuilt 1950 · S/N 19371N9279XKhoury Alain W · Wills Point, TXBuilt 1961 · S/N 18253679N927MPPrebish Matthew · Heath, TXBuilt 1980 · S/N R18201569N927NBlue Sky Business Services Inc · Gardiner, NYBuilt 1970 · S/N 18260320N927TCWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264152N9280BDreessen Steven C · Walkerton, INBuilt 1958 · S/N 55080N9280MRiley Dean A · Friday Harbor, WABuilt 1972 · S/N 17260490N92810Dilse Brian R · Grand Forks, NDBuilt 1973 · S/N 17261626N92814Kimbrell Tod L Jr · Itasca, TXBuilt 1970 · S/N 18260371N92815Halver Todd L Trustee · Advance, NCBuilt 1970 · S/N 18260372N92816Van Cleve G Steven · Windermere, FLBuilt 1970 · S/N 18260373N92817Millner James W Sr · Soldotna, AKBuilt 1973 · S/N 17261628N9281GRuffner Scott A · Luray, VABuilt 1971 · S/N 18260821N9281RBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N R18200678N9281UOtters Heinrich · Fredericksburg, TXBuilt 1976 · S/N 15078231N92822Roada Inc · Indio, CABuilt 1970 · S/N 18260378N92824C182 Wv LLC · Charleston, WVBuilt 1970 · S/N 18260380N9282AWest Sheryl M · Champlin, MNBuilt 1949 · S/N 19043N9282TCloud 9 Aviators LLC · Anchorage, AKBuilt 1960 · S/N 50782N9282USchur David · Lavernia, TXBuilt 1976 · S/N 15078232N92836Clark Wyatt · Ione, CABuilt 1970 · S/N 18260382N92837Staszak Sandra · Martinsville, ILBuilt 1973 · S/N 17261631N9283CFoerschler Dale · North Aurora, ILBuilt 1980 · S/N 17273783N9283GTexas Forever LLC · Denver, COBuilt 1971 · S/N 18260823N9283RAllied Sprayers Inc · Hawley, TXBuilt 1975 · S/N 18802211N92843Roehl John F Jr · Neapolis, OHBuilt 1970 · S/N 18260389N92844Smooth Sailing Flying Club Inc · Avon, INBuilt 1970 · S/N 18260390N92845Hainet Aero LLC · Wilmington, DEBuilt 1973 · S/N 17261633N92846Evans Millard D · Mobile, ALS/N 18260392N9284BBeckley Larry · Scottsburg, INBuilt 1958 · S/N 55084N92850Nelson Tabor K · Corona, CABuilt 1970 · S/N 18260395N92855Falcon Flying Club · Mesa, AZBuilt 1973 · S/N 17261634N9285HOrion Aviation Aircraft LLC · Carlsbad, CABuilt 1975 · S/N 17266068N9285XBlu Kaya LLC · Austin, TXS/N 18253685
Back to AD 87-20-03 R2