OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N116RVJordan Jimmy W · Winnfield, LABuilt 1999 · S/N 60136N116SDA L Aviation LLC · Boiling Springs, SCS/N 359-73N116TRobinett Barton L · Frankston, TXBuilt 1952 · S/N 18-2230N116TBMcmullan Francis G · Weirsdale, FLS/N 362N116TSIrish Cindy L · Buckeye, AZBuilt 2003 · S/N 60399N116URobinson Michael E · Anthony, NMS/N 1557866N11702Tailwheeling It LLC · Algoma, WIBuilt 1972 · S/N 317-72N11704Jackman William L · Newman Lake, WAS/N 857-72N11706Hershberger Brian K · Wrightwood, CABuilt 1972 · S/N 319-72N11707Catfish Express Inc · Inverness, MSBuilt 1972 · S/N 15-72N11709Hutchins Reid C · Hanover, NHBuilt 1972 · S/N 859-72N1170AAbbott Barry R · Sterling, AKBuilt 1951 · S/N 18-768N1170JHoward Thomas D · Bunnlevel, NCBuilt 1974 · S/N 170N1170LSweet Aviation LLC · Dover, DES/N 332N1170MBryson William H III · Cook, MNBuilt 1969 · S/N 17258670N1170YMacmullen Kenneth P · Quakertown, PAS/N 15059570N1171CUnser Joshua D · Anchorage, AKBuilt 1953 · S/N 20-963N1171LN1171l LLC · Newport News, VABuilt 1982 · S/N 24-1330N11720Mcfarlane Kevin E · Dubuque, IABuilt 1972 · S/N 860-72N11721Yague-Martinez Eloy · Rochester, NYBuilt 1972 · S/N 320-72N11723Rader Mark Todd · Deland, FLBuilt 1975 · S/N 17702361N1172MTodd Kevin E · Bismarck, NDBuilt 1969 · S/N 17258672N1172PSteed William B · Winnsboro, SCS/N 23-175N11730Sendelbach John W · Cochrane, WIBuilt 1975 · S/N 17702362N1173CHolland Todd D · Mendota, ILBuilt 1977 · S/N 17702679N1173JCohelios LLC · Oviedo, FLBuilt 1974 · S/N 135N1173MFlathead Lake Aviation LLC · Polson, MTBuilt 1969 · S/N 17258673N1173XWnc Aviation LLC · Arden, NCBuilt 2006 · S/N 172S10379N1173YSorg Daniel T · Columbus, INS/N 001N1174EInman James Dylan · Parsons, TNS/N 1228-78N1174JOlson Michael J · Viroqua, WIBuilt 1974 · S/N 174N1174MWhitted Danny E · Candler, NCBuilt 1969 · S/N 17258674N1174PHardin John M · Terrell, TXBuilt 1955 · S/N 23-188N11756Creswell Philip M · Camden, ALBuilt 1975 · S/N 17702365N1175ABurmeister Aaron R · Nenana, AKBuilt 1951 · S/N 18-777N1175ENannini Gary S · Lincoln City, ORBuilt 1977 · S/N 314-77N11760Davis Richard M · League City, TXBuilt 1934 · S/N A-689N1176EIrving Holdings LLC · Greensboro, NCBuilt 1977 · S/N 988-77N1176UPlane Leasing LLC · Wilmington, DEBuilt 1976 · S/N 17266877N1177Kma LLC · New Port Richey, FLBuilt 1942 · S/N 75-5046N11771Boss Gary W · Bronston, KYBuilt 1975 · S/N 17702366N1177BTakacs John Paul III · Colorado Springs, COBuilt 1991 · S/N 651-91N1177GFuellner Seanl · Shelocta, PAS/N C.P.M.-2N1177NWilton William H · Kailua Kona, HIS/N 367N1178COliveira Frank Jr · Pawtucket, RIBuilt 1977 · S/N 17702680N1178MLehman David G · Kent, WABuilt 1969 · S/N 17258678N1178XN1178x LLC · Dover, DEBuilt 1975 · S/N 28-7505220N11793Reed Gary L · Bethel, OHBuilt 1936 · S/N A717N11799Borba Steven D · Woodland, CABuilt 1975 · S/N 17702369N1179EPlane Air LLC · Paducah, KYFirst renewal noticeBuilt 1977 · S/N 1220-77
Back to AD 90-04-06 R1