AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N87WAMann Ronald L · Pound Ridge, NYS/N 754-95N87WBWild Bitch LLC · Oklahoma City, OKS/N SN-483RN87WHPerry Larry B · Montross, VABuilt 1987 · S/N 1672N87WJKrueger Kenneth L · Newberg, ORS/N 553N87WRJohnston Donald C · Davis, CABuilt 1967 · S/N 520N87XPSutherland Brian · Nolensville, TNBuilt 2019 · S/N 087N8800JRobinson Jacob · Lewistown, MTS/N 28-2745N8800YAlexander City Aviation Corp · Alexander City, ALBuilt 1969 · S/N 30-1956N8801CBlue Chip Aviation LLC · Falling Waters, WVS/N 22-1414N8801MStein Bruce A · Punta Gorda, FLBuilt 1964 · S/N TD-569N8802Osterberg Douglas · Neenah, WIBuilt 1973 · S/N 492-73N8802FMc Lane Jonathan T · Morrisville, NCRevoked, canceledBuilt 1962 · S/N 0133N8802JShivers James C II · Columbus, OHBuilt 1965 · S/N 28-2750N8803Lindsay Lori K · Kenai, AKBuilt 1973 · S/N 472-73N88037Willke Sue E · Sewickley, PAS/N 15654N88038Quirk Charles L · Lake Charles, LABuilt 1946 · S/N 15655N88039Chapman Jeffrey C · Brownsburg, INBuilt 1946 · S/N 15656N8803DWhite Jacob · Soldotna, AKBuilt 1958 · S/N 22-5971N8803FAg Helicopters Inc · Ft Collins, CORegistration revokedBuilt 1962 · S/N 0134N8804Hail Jerry D · Keatchie, LABuilt 1973 · S/N 74-73N88047Rjr Airdrome Inc · Dover, DEBuilt 1974 · S/N 1036-74N8804NCarbon Regional Aero Club · Lehighton, PABuilt 1969 · S/N 28-25649N8804PJohnsen Christian · Lake Havasu City, AZBuilt 1975 · S/N BH-120-338N8804YMartino Aviation LLC · Wilmington, DES/N 30-1960N88055Lake Air Academy LLC · Richland, MIBuilt 1974 · S/N 715-74N88057Registered aircraftBuilt 1974 · S/N 716-74N88059Tidewater Soaring Society · Windsor, VAS/N 72-74N8805CSandifer Steve R · Barnwell, SCBuilt 1953 · S/N 22-1419N8806Loyd Robert Oliver Parke · Wallingford, KYBuilt 1973 · S/N 364-73N88063Evenson Gabriel J · Fargo, NDS/N 461-74N88065Obx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 460-74N88066Nightingale Patrick R · Lakewood, CABuilt 1974 · S/N 1037-74N8806CGribbins Aviation LLC · Campbellsville, KYBuilt 1953 · S/N 22-1420N8806JLytle Hugh R · Senoia, GABuilt 1965 · S/N 28-2756N8806NHorne Terry A · Carefree, AZBuilt 1969 · S/N 28-25652N8807Potter David · Huntley, ILBuilt 1973 · S/N 473-73N88078Khm Investments Inc · Lehi, UTBuilt 1974 · S/N 464-74N88079East Hill Flying Club Inc · Ithaca, NYBuilt 1974 · S/N 1038-74N8807DGorski Tim B · Larsen, WIBuilt 1958 · S/N 22-5975N8807JNorris Dana G III · Zanesville, OHS/N 28-2757N8807NTruax James D · Roanoke, INBuilt 1969 · S/N 28-25653N8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 30-1964N88081Butler Julie L · Los Osos, CABuilt 1974 · S/N 718-74N88083N3542w Inc · Wilmington, DEBuilt 1974 · S/N 719-74N88085Poulson Daniel J · Anchorage, AKBuilt 1974 · S/N 722-74N88086Saliba Eric · Mineola, NYBuilt 1974 · S/N 1039-74N8808DDwight Thomas W · Castalia, OHBuilt 1958 · S/N 22-5977N8808JCoulliette Brian K · Jacksonville, FLBuilt 1965 · S/N 28-2758N8808YAukes Brian E · Huxley, IABuilt 1969 · S/N 30-1965N8809Velociraptor Aviation LLC · Toney, ALBuilt 1973 · S/N 929-73
Back to AD 90-04-06 R1