OpenAirDocs.org
AD 87-20-03 R2

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

N571CRegistered aircraftBuilt 1957 · S/N 32785N571VHVan Hoy Jeffrey D · Knightstown, INBuilt 1965 · S/N 15062392N5720CWienk Cody · Bellevue, NES/N 19826N5720EInstall Pro Construction LLC · Henderson, NVBuilt 1978 · S/N 17271926N5720TFrost Nathan L · Olympia, WABuilt 1964 · S/N 17251620N5721TSeattle Seaplanes LLC · Seattle, WABuilt 1964 · S/N 17251621N5722BVelasquez Benjamin · Anchorage, AKS/N 33722N5722CNeumann John F · Walden, NYBuilt 1950 · S/N 19676N5722GSchmitt Rudy · Bulverde, TXBuilt 1969 · S/N 15071222N5722RCalhoun Barry R · Richardson, TXBuilt 1965 · S/N 17253387N5723AAdamson Steven C · Jonesboro, GAS/N 28323N5723CMid Pacific Aero Services LLC · Wahiawa, HIBuilt 1951 · S/N 19677N5723JMcdonald Larry H · Little River, SCBuilt 1974 · S/N 18263498N5723RCoffey Bryan K · Anchorage, AKBuilt 1965 · S/N 17253389N5723TColeman David R · Limerick, MEBuilt 1964 · S/N 17251623N5724CRegistered aircraftS/N 19827N5724GCrnic John F · Kirksville, MOBuilt 1969 · S/N 15071224N5724JPurdue Aviation LLC · West Lafayette, INBuilt 1980 · S/N 17273827N5724RMartindale Bryan T · Springfield, ILBuilt 1965 · S/N 17253393N5726BBend Aircraft Rentals LLC · Bend, ORBuilt 1956 · S/N 33726N5726CPurcell Kim L · Placerville, CABuilt 1950 · S/N 19680N5726THall Edward M · Brainerd, MNBuilt 1964 · S/N 17251626N5727EZeitvogel Jeanine · Gulf Shores, ALBuilt 1978 · S/N 17271928N5727NQualitair LLC · MicheistadtBuilt 1977 · S/N 18503320N5727RBiederman Scott · Pompano Beach, FLS/N 17253396N5728AMcgiffen Christine L · Vincennes, INBuilt 1956 · S/N 28328N5728BHawkins Charles A Sr · Chillicothe, OHBuilt 1956 · S/N 33728N5729AThomas Scott S · Wytheville, VABuilt 1956 · S/N 28329N5729RMarreno Eddie J · Green Cove Springs, FLS/N 17253398N5729TConservair Inc · Montgomery, TXBuilt 1964 · S/N 17251629N572DHSportsmans Recon LLC · Hartwell, GABuilt 1974 · S/N 18263024N572EEcho Air LLC · Anchorage, AKBuilt 1972 · S/N 18502089N572GSickles James D · Caledonia, NYBuilt 1969 · S/N 18259932N572RJUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1973 · S/N 17261600N5730AMunson Steven L · Martinsburg, WVBuilt 1956 · S/N 28330N5730JLindley Field Flying School LLC · Greensboro, NCBuilt 1980 · S/N 17273828N5731CSmith Michael E · Willits, CABuilt 1951 · S/N 19685N5731JPaulick Adam J · Deerfield, WIBuilt 1969 · S/N P20600631N5731RGoward Steven Lee · Oakley, MIBuilt 1965 · S/N 17253400N5731TUhen Instruments Inc · Burlington, WIS/N 17251631N5732CHoulton Timbre R · Fairbanks, AKBuilt 1950 · S/N 19686N5732EWynn Josh · Bucyrus, OHBuilt 1978 · S/N 17271929N5733BRobertson Nate Allen · Aiken, SCBuilt 1956 · S/N 33733N5733CDuea Michael J · Savage, MNBuilt 1950 · S/N 19687N5733RWarren Jeffrey · Omaha, NEBuilt 1965 · S/N 17253402N5733TCountry Flyin Inc · Homestead, FLBuilt 1964 · S/N 17251633N5734AEisenbrey Glen T · Greenbank, WABuilt 1956 · S/N 28334N5734RZ&H Aviation · Portage, MIBuilt 1965 · S/N 17253403N5735RDavis Richard B · Reno, NVFirst renewal noticeBuilt 1965 · S/N 17253404N5736GGagana Aviation LLC · Leander, TXBuilt 1969 · S/N 15071236
Back to AD 87-20-03 R2