Registered aircraft · 54,019

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N30353Stracuzzi Charles J · Ocala, FLBuilt 1968 · S/N 17701207 N30357Cammack Brian W · Edgewood, NMBuilt 1968 · S/N 17701209 N3035BFlying W Aviation Enterprises · Bellevue, NEBuilt 1952 · S/N 7918 N3035UFindley William R · Los Gatos, CABuilt 1963 · S/N 17250635 N3035X29 Soaring Club Inc · Twentynine Palms, CABuilt 1966 · S/N 15064435 N3035YWardlaw Consulting LLC · Truckee, CABuilt 1962 · S/N 18254035 N30363Talbot Douglas J · Sandpoint, IDS/N 17701210 N3036Q3 Rivers Airshare Llp · Sheridan, MTBuilt 1967 · S/N 18258036 N3036YPeterson Zachary E · Fargo, NDBuilt 1962 · S/N 18254036 N30370Fellow Ship Aviation LLC · Monticello, GABuilt 1974 · S/N 17264136 N30374Canihan William R · Novato, CABuilt 1973 · S/N 21059918 N3037BQualitair LLC Trustee · MichelstadtBuilt 1952 · S/N 7920 N3037JMello Ben · Bainbridge Island, WAS/N 15061137 N3037QState Of Arizona · Holbrook, AZBuilt 1967 · S/N 18258037 N30384Knutson Wayne R · Thompson, NDS/N 15064473 N30387Watkins Bruce K · Houston, TXBuilt 1968 · S/N 17701226 N3038FTaylor Spencer H · Lake City, FLBuilt 1966 · S/N 18257138 N3038JPauls Flying Service LLC · Dundee, MSBuilt 1965 · S/N 15061138 N3038SAbove All Aviation · Goleta, CABuilt 1967 · S/N 15066938 N30390Rimmer Nathan S · Seattle, WABuilt 1968 · S/N 17701229 N30393Graden Timothy J · Polo, ILBuilt 1968 · S/N 17701231 N30396Sill John A · Cable, WIBuilt 1968 · S/N 17701233 N30399Schwanke Donald D · Springfield, ILBuilt 1968 · S/N 17701236 N3039VMiller Zachary L · Roseau, MNBuilt 1974 · S/N 15076364 N303ABMarc Inc · Bolton, MSBuilt 1981 · S/N T30300028 N303BSLegacy Restoration Services Inc · Cumming, GABuilt 1980 · S/N 182-67622 N303CCSpectrum Aviation Inc · Wilmington, DEBuilt 1982 · S/N T30300069 N303CGSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N T30300022 N303CMAdvantage Aviation Inc · Charlotte, NCBuilt 1984 · S/N T30300296 N303CTFloyd Brian · Eatonton, GABuilt 1978 · S/N 21062591 N303DBBas Part Sales LLC · Greeley, COBuilt 1981 · S/N T30300043 N303DKTrading Planes Inc · Wilmington, DEBuilt 1982 · S/N T303-00068 N303HLLao Che Airfreight LLC · North Weymouth, MABuilt 1982 · S/N T30300038 N303JPJep Inc · Clarksville, TNBuilt 1982 · S/N T30300067 N303KJBrother Michael Andrew · Bedford, TXBuilt 1984 · S/N T303-00301 N303KSSmoky Hill Ag LLC · Healy, KSBuilt 1982 · S/N T30300223 N303LKWestwind Aviation Inc · Bremerton, WABuilt 1973 · S/N 17262140 N303MBBas Part Sales LLC · Greeley, COBuilt 1982 · S/N T30300157 N303PBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N T30300290 N303RJTr Zato Heir Land & Cattle LLC · Spur, TXBuilt 1970 · S/N 18501728 N303SDHarris County Sheriff'S Office · Spring, TXBuilt 1973 · S/N 18261849 N303WAWacker Logistics LLC · Naples, FLBuilt 1984 · S/N T30300265 N303WJQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N T30300087 N303WWQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N T30300226 N303XStocki Ronald W · Centennial, COBuilt 1960 · S/N 52957 N30404Cardinal Flyers LLC · Powell, OHBuilt 1969 · S/N 17701237 N30407Cardinal Cronies LLC · Clarinda, IABuilt 1968 · S/N 17701238 N30409Schmitt Cameron · Fort Dix, NJBuilt 1968 · S/N 17701239 N3040FJump Tn LLC · Greeneville, TNBuilt 1966 · S/N 18257140 N3040JCrabtree Steven B · Canyon, TXBuilt 1965 · S/N 15061140

Back to AD 87-20-03 R2