OpenAirDocs.org
AD 87-21-02 R1

Registered aircraft · 3,961

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-21-02-R1')
    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-21-02-R1')
  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.

N5HEFinancial Solution Services · Leesburg, FLS/N 340A0485N5HSRose Raymond P · San Diego, CABuilt 1962 · S/N 320A0026N5LHIsland Creek Partners LLC · Alpine, CABuilt 1973 · S/N 310Q0939N5NMNelson Jeffrey S · Darby, MTBuilt 1978 · S/N 414A0042N5NNRkgrier LLC · Beckley, WVS/N 421C0446N5PJGod Family Ministries International Inc · Elmont, NYBuilt 1972 · S/N 421B-0258N5UTK&L Salty Air LLC · Stephenville, TXBuilt 1976 · S/N 421C0101N5YFBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 310L-0084N5ZTAllen Airplane LLC · Durango, COBuilt 1973 · S/N 414-0477N600DCHerron Aviation Group LLC · Dexter, MIS/N 421C1007N600EXAire Tracks Corp · Wilmington, DEBuilt 1969 · S/N 310P0147N600HCCessna 414a LLC · Portland, ORBuilt 1978 · S/N 414A0025N600RRCompac Inc · Manassas, VABuilt 1963 · S/N 310H0108N600SMCapt Tony 185 LLC · Aurora, COBuilt 1966 · S/N 320E0084N600THN600th LLC · Fredericksburg, VABuilt 1981 · S/N 414A0668N602DCKeystone Xpress LLC · Rostraver Twp, PAS/N 421C0864N605DCT&C Aviators LLC · Green Cove Springs, FLS/N 421C-1005N605SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 421C1041N606PPAndriopulos Salguero Inc · Hialeah, FLS/N 414-0416N607JDJd 707 Air LLC · Edgerton, OHBuilt 1978 · S/N 414A0071N608RCRichland Aviation Inc · Sidney, MTS/N 404-0608N6098XKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1266N609DSTj Air Holdings Inc · Wilmington, DEBuilt 1981 · S/N T30300025N60DMDatom Inc · Culver City, CABuilt 1979 · S/N 340A0711N60EDawson Aircraft Inc · Clinton, ARBuilt 1979 · S/N 340A0663N60FYNew Castle Aviation Inc · Durham, NHBuilt 1969 · S/N 310P0109N60GMInternational Air Services Inc Trustee · Carson City, NVS/N 421C-0828N60PPJaams LLC · Shafter, CABuilt 1976 · S/N 340A0073N60WHSan Clemente David Paul · Edgewater, FLBuilt 1976 · S/N 340A0083N6101XJanhar Ales · Danville, CAS/N 310R1267N6104XTerairmar Services Inc · Monticello, FLBuilt 1978 · S/N 310R1272N6109XBlake Development Corp LLC · Fort Lauderdale, FLS/N 310R1278N610AKBaja Electric Service Inc · Punta Gorda, FLBuilt 1974 · S/N 310Q-1072N610RCHallada William A · Barnesville, GAS/N 310-0115N610W610w Holdings LLC · Sandy, UTS/N 310R-0322N6115CHat Investments LLC · Spartanburg, SCS/N 421C0890N6116CWaukegan Flyers LLC · Waukegan, ILBuilt 1978 · S/N 310R1283N6126CM20k LLC · Minot, NDBuilt 1978 · S/N 310R1293N612CGCasa Grande Homes Inc · Blanchard, OKBuilt 1973 · S/N 421B0416N612JPSkyline Air LLC · Ashburn, VABuilt 1968 · S/N 310N-0116N612JRQ & A Company LLC · Newport, RIBuilt 1980 · S/N 340A0927N6131XGv Air Inc · Medford, ORS/N 310R1296N6137XMoyer Aviation Inc · Ulysses, KSBuilt 1978 · S/N 310R1297N6142CKite Harris Property Group LLC · Zionsville, INS/N 310R1300N614CQC & H Aviation LLC · Lagrange, GABuilt 1977 · S/N 310R1239N6151QNitro Zeus Inc · Wilmington, DEBuilt 1967 · S/N 320F-0001N6152XPakan Dwight John · Charlotte, NCBuilt 1978 · S/N 310R1302N6156QGem State Transportation Inc · Hamilton, MTBuilt 1967 · S/N 320F-0006N615PCBurning Blue LLC · Greenwood, MSBuilt 1978 · S/N 340A0615N615PJEngelstad Dana P · Midland, TXFirst renewal noticeBuilt 1977 · S/N 340A-0260
Back to AD 87-21-02 R1