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.

N99HARuka Consulting LLC · Pewaukee, WIBuilt 1977 · S/N R1722281N99HEJackson Andrew · Odessa, FLS/N R1722996N99HPMckee Eli · Brighton, COBuilt 1964 · S/N 185-0709N99HRSilver Express Co · Miami, FLBuilt 1978 · S/N 15282972N99MVWinkler Gabriel M · Kailua Kona, HIBuilt 1975 · S/N 18263592N99NAPozzi Andrew E · Crescent City, CABuilt 1977 · S/N 17702697N99PGWilliams James R · Batesville, INBuilt 1978 · S/N 17272044N99PTWiger Theodore L · Falcon Heights, MNS/N 17249265N99PXCeo Flight Inc · Arlington Heights, ILS/N 17702149N99QTNielsen4 LLC · Seattle, WABuilt 1968 · S/N U206-1017N99RPMarden Management Company Inc · Reno, NVS/N R182-01517N99RTTennessee Museum Of Aviation Inc · Sevierville, TNBuilt 1962 · S/N P17257165N99SHRegistered aircraftBuilt 1964 · S/N 18255599N99TCUltimate Resort Vacations Inc · Weston, FLBuilt 1980 · S/N 172RG0412N99TMMagdabenja Holdings LLC · Corona, CABuilt 1977 · S/N 21061712N99TNHuskey Ryan J · Edmond, OKS/N 17265107N99TSLorenzen Carl A · Blair, NEBuilt 1963 · S/N 17250870N99WGWilson Norman · Mount Pleasant, TXBuilt 1978 · S/N 210-62618N99YED & E Recreation LLC · Dowling, MIBuilt 1975 · S/N 18264030N99YFAspire Partners LLC · Evansville, INBuilt 1968 · S/N U2060940N99YZEdwal Aviation LLC · Reno, NVBuilt 1981 · S/N 21064608N99ZHHolman Michael J · Anchorage, AKBuilt 1963 · S/N 18051291N9ARKelting Foundation · Blountstown, FLS/N 15062765N9BPLynn Marshall · Milford, MIBuilt 1973 · S/N 18262078N9BTParlin Troy W · Wills Point, TXS/N 18255639N9CGLindow Anthony D · Soldotna, AKBuilt 1960 · S/N 50732N9CSChristensen Jon D · Kiowa, COBuilt 1973 · S/N P3370122N9CTSafe And Sound LLC · Kalispell, MTBuilt 1972 · S/N P3370011N9CVSeymour Ryan B · Coral Springs, FLBuilt 1972 · S/N P3370057N9CXUr Culinary Xperience Catering Services LLC · Miami, FLBuilt 1973 · S/N P3370080N9EDTaylor Monty · Cornelius, NCBuilt 1972 · S/N 21059612N9FQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 18502855N9FRDonaldson Thomas M · Granbury, TXBuilt 1977 · S/N 17702666N9GCCleland Michael J · Pleasanton, CABuilt 1963 · S/N 205-0253N9HMRonay Thomas G Trustee · Nampa, IDBuilt 1980 · S/N 18053165N9HQBacon Joseph M · Fenton, MIS/N 18051946N9JPEcho Air Inc · Woodstock, GABuilt 1973 · S/N 210-59926N9KAEssex Aviation · Indianapolis, INS/N 15284552N9KYArgos Retail LLC · Mcallen, TXBuilt 1973 · S/N P337-0052N9LAEvanoff Thomas E · Fowlerville, MIS/N 17249542N9LGCalfee Ray I · Charleston, TNBuilt 1962 · S/N 18254559N9LJBurgauer Aviation LLC · Mount Calm, TXS/N 33701777N9MDWaage Matthew L · Elkhart Lake, WIBuilt 1975 · S/N 15077170N9MLBobcheeto LLC · Newark, DEBuilt 1978 · S/N R18200620N9MTGaroutte Kirk Edward · Anchorage, AKBuilt 1949 · S/N 7394N9MYBermudez Tacito Octavio · Conyers, GABuilt 1976 · S/N 17267616N9NCulley Terry L · Lebanon, INBuilt 1978 · S/N 18266518N9PCMeloche Michael S Trustee · Hamilton, MTBuilt 1949 · S/N 7437N9PDPowell Distributing Co Inc · Portland, ORBuilt 1969 · S/N 18052062N9RLKrug Heath · Colusa, CABuilt 1964 · S/N 18255986
Back to AD 87-20-03 R2